query("SELECT * FROM sl_users WHERE uid='$loged_userid'"); $rec=$obj->fetchNextObject($sql); $storeid=getFieldWhere('storeid', 'stores', 'uid', $loged_userid); session_start(); include("top-head.php"); if(isset($_POST['btnAddSchedule'])) { $prodreference_id=$_POST['id']; $schedule_date=$_POST['schedule_date']; $schedule_time=$_POST['schedule_time']; $info=$obj->query("select * from tbl_order_itmes where section='quicklly-puja' AND id='".$prodreference_id."'"); $inforow=$obj->fetchNextObject($info); $infoe=$obj->query("select * from tbl_puja_schedule where sc_id='".$_POST['sc_id']."'"); $inforowe=$obj->fetchNextObject($infoe); $schedule=''; if($inforowe->schedule_date==0000-00-00) { $schedule='schedule'; } else { $schedule='reschedule'; } $sql="update tbl_puja_schedule set prodreference_id='$prodreference_id',schedule_date='$schedule_date',to_schedule_date='".$_POST['to_schedule_date']."',schedule_time='$schedule_time',current_status='Video call Scheduled',updated_at='".date('Y-m-d h:i:s')."' where sc_id='".$_POST['sc_id']."'"; $obj->query($sql); echo ""; $results = callAPI('POST','https://ormwebapi.quicklly.com/digitalpuja/chat-email-notification',array("emailtype"=>$schedule,'userid'=>$inforowe->user_id,'statusid'=>$_POST['sc_id'],'pid'=>$inforowe->pid)); echo ""; } if(isset($_GET['cmpid'])) { $sql="update tbl_puja_schedule set current_status='complete',updated_at='".date('Y-m-d h:i:s')."',order_complete_date='".date('Y-m-d H:i:s')."' where prodreference_id='".$_GET['cmpid']."'"; $obj->query($sql); echo ""; echo ""; } if(isset($_POST['btnOrderStatus'])) { $sql="update tbl_puja_schedule set current_status='".$_POST['order_status']."',order_status_comment='".$_POST['puja_cancelled']."',updated_at='".date('Y-m-d H:i:s')."',order_complete_date='".date('Y-m-d H:i:s')."' where sc_id='".$_POST['sc_id']."'"; $obj->query($sql); if($_POST['order_status']=='cancel') { $infoe=$obj->query("select * from tbl_puja_schedule where sc_id='".$_POST['sc_id']."'"); $inforowe=$obj->fetchNextObject($infoe); // $results = callAPI('POST','https://ormwebapi.quicklly.com/digitalpuja/chat-email-notification',array("emailtype"=>'cancel','userid'=>$inforowe->user_id,'statusid'=>$_POST['sc_id'],'pid'=>$inforowe->pid)); $slotid=$_POST['slotid']; if($slotid!='' || $slotid!=null) { $slotquery=$obj->query("select id,avaibility_date,from_time,to_time,timegap from tbl_puja_avaibility_date_time where id='".$slotid."'"); $getslot=$obj->fetchNextObject($slotquery); //$obj->query("update tbl_puja_schedule set booked_date='".$getslot->avaibility_date."',to_booked_date='".$getslot->avaibility_date."',booked_slot='".$getslot->from_time."',schedule_time='".$getslot->from_time."',schedule_date='".$getslot->avaibility_date."',to_schedule_date='".$getslot->avaibility_date."',current_status='Video call Scheduled',chat_status=1 where sc_id='$pujaid'"); $obj->query("update tbl_puja_avaibility_date_time set booking_status=0 where id='$slotid'"); if($getslot->timegap==20) { $pricequeryp=$obj->query("select size from tbl_productprice where wholesale_min=0 and product_id='272098' order by display_order asc"); while($productp=$obj->fetchNextObject($pricequeryp)){ $begin = new DateTime($getslot->from_time); $end = new DateTime($getslot->to_time); while($begin < $end) { $gap=$productp->size; $output1 = $begin->format('Y-m-d H:i:s'); $begin->modify('+5 minutes'); $output = $begin->format('Y-m-d H:i:s'); $obj->query("update tbl_puja_avaibility_date_time set booking_status=0,status=1,updated_at=now() where avaibility_date='".$getslot->avaibility_date."' and (from_time<='".$output1."' AND to_time >='".$output."') and timegap='".$gap."'"); } } } else { $obj->query("update tbl_puja_avaibility_date_time set booking_status=0 WHERE avaibility_date='".$getslot->avaibility_date."' and (from_time<='".$getslot->from_time."' and to_time >= '".$getslot->to_time."' or (from_time>='".$getslot->from_time."' and to_time <= '".$getslot->to_time."'))"); } } } echo ""; echo ""; } ?>

Order Info

='".$_REQUEST['search_from_date']."' and o.order_date<='".$_REQUEST['search_to_date']."' "; } if($_REQUEST['search_category']!='') { $name=$_REQUEST['search_category']; $where.=" and p.categories='".$name."' "; } ?>
query("SELECT ps.*,c.maincategory,p.product_name,o.payment_status,o.ship_fname,o.ship_lname,o.ship_mobile,o.ship_full_address,o.ship_house_no,o.ship_street,o.ship_complex,o.ship_area,o.ship_city_id,o.ship_state,o.ship_pincode FROM `tbl_puja_schedule` ps inner join tbl_product p on ps.pid=p.id inner join tbl_maincategory c on c.id=p.categories inner join tbl_order o on o.id=ps.order_id $where ORDER BY `sc_id` DESC;"); while($orrow=$obj->fetchNextObject($orders)) { $i=$i+1; ?>
S No. Customer Detail Payment Status Order Date Order ID Puja Reference Date Reference Slot / Time Puja Schedule Status Category Product Detail Prasad QTY Amount Delivered Date Comment Action
ship_fname . " " . $orrow->ship_lname); ?>
ship_mobile; ?>
Add: ship_full_address==''){ echo $orrow->ship_house_no . ", " . $orrow->ship_street . ", " . $orrow->ship_complex . ", " . $orrow->ship_area . " " . $orrow->ship_city_id . " " . $orrow->ship_state . ", " . $orrow->ship_pincode; } else { echo $orrow->ship_full_address. ", ".$orrow->ship_complex .", " . $orrow->ship_pincode; } ?> 		payment_status=='1'){ echo ""; } else { echo ""; } ?> created_at));?> order_id?> booked_date==$orrow->to_booked_date) { if($orrow->booked_date!='' AND $orrow->booked_date!='0000-00-00'){ echo date('d M Y', strtotime($orrow->booked_date)); } } else { ?> booked_date!='' AND $orrow->booked_date!='0000-00-00'){ echo date('d M Y', strtotime($orrow->booked_date)); } if($orrow->to_booked_date!='' AND $orrow->to_booked_date!='0000-00-00'){ echo "- To -".date('d M Y', strtotime($orrow->to_booked_date)); } } ?> booked_slot!='') { $arr=explode(" - ",$orrow->booked_slot); // echo date('h:i a', strtotime($arr[0]))." - ".date('h:i a', strtotime($arr[1])); echo echo date('h:i a', strtotime($arr[0])); } ?> schedule_date!=0000-00-00) { if($orrow->schedule_date==$orrow->to_schedule_date) { $date1 = $orrow->schedule_date; $time=$orrow->schedule_time; $datefrom=date('d M Y', strtotime($date1)); $timeto=date('h:i A', strtotime($time)); echo $datefrom; echo "
"; echo $timeto; } else { $date1 = $orrow->schedule_date; $date2 = $orrow->to_schedule_date; $time=$orrow->schedule_time; $datefrom=date('d M Y', strtotime($date1)); $dateto=date('d M Y', strtotime($date2)); $timeto=date('h:1 A', strtotime($time)); echo $datefrom." - ".$dateto ; echo "
"; echo $timeto; } } //$inforow->schedule_date ?> 		current_status=="Video call Scheduled") { echo "".$orrow->current_status.""; } else if($orrow->current_status=="complete") { echo "".$orrow->current_status.""; } else if($orrow->current_status=="cancel") { echo "".$orrow->current_status.""; } else { echo "Pending"; } ?> maincategory; ?> product_name?> maincategory=="Astrology") { if($orrow->name!='') { echo "
NameDate of BirthBirth PlaceemailBirth CountryQuestion
".$orrow->name." ".date('d M Y h:i a', strtotime($orrow->dob))." ".$orrow->birthplace." ".$orrow->useremailid." ".$orrow->birthcountry." ".$orrow->questionTodiscussion."
"; } } else { $priceinfo=$obj->query("select puja_info,price_detail,sell_price as price from tbl_productprice where id='".$orrow->price_id."'"); $priceinfodetail=$obj->fetchNextObject($priceinfo); echo $priceinfodetail->price_detail; } $priceinfo=$obj->query("select puja_info,price_detail,sell_price as price from tbl_productprice where id='".$orrow->price_id."'"); $priceinfodetail=$obj->fetchNextObject($priceinfo); ?> 		puja_info?> qty?> $price, 2);?> order_complete_date?> order_status_comment?>