Edit file File name : burqup.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); include("../include/burq.php"); validate_admin(); if($_REQUEST['submitForm']=='yes' && $_REQUEST['request_type']=='create'){ $request_type=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['request_type']); $order_id=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['order_id']); $burq_store=$_POST['stid']; $burq_store=array_unique($burq_store); $burq_order=$obj->query("select ship_full_address,ship_fname,ship_lname,ship_mobile,delivery_note,ship_type from tbl_order where id='$order_id'"); $burq_order_rslt=$obj->fetchNextObject($burq_order); if($burq_order_rslt->ship_type=='Home Delivery'){ $orderprefix="QD"; }else{ $orderprefix="QP"; } if($burq_order_rslt->ship_full_address==''){ $ship_address=$burq_order_rslt->ship_house_no.' '.$burq_order_rslt->ship_complex.' '.$burq_order_rslt->ship_street.', '.$burq_order_rslt->ship_city_id.', '.$burq_order_rslt->ship_state.', USA'; }else{ if($burq_order_rslt->ship_complex){ $ship_address=$burq_order_rslt->ship_complex.' '.$burq_order_rslt->ship_full_address; }else{ $ship_address=$burq_order_rslt->ship_full_address; } } for($x=0; $x<count($burq_store); $x++){ $burq_itemarr=array(); $storeItem_query=$obj->query("select product_name,qty from tbl_order_itmes where order_id='$order_id' and storeid='$burq_store[$x]'"); while($storeitem_result=mysqli_fetch_assoc($storeItem_query)){ $burq_itemarr['size']="medium"; $burq_itemarr['name']=$storeitem_result['product_name']; $burq_itemarr['quantity']=$storeitem_result['qty']; $itemarray[]=$burq_itemarr; } $burq_store_detailQry=$obj->query("select storename,storeaddress,phone from stores where storeid='$burq_store[$x]'"); $burq_store_detailQry_rslt=$obj->fetchNextObject($burq_store_detailQry); $item_list=$itemarray; $pickup=$burq_store_detailQry_rslt->storeaddress; $dropoff=$ship_address; $d_name=$burq_order_rslt->ship_fname." ".$burq_order_rslt->ship_lname; $d_phone=$burq_order_rslt->ship_mobile; $d_notes=$burq_order_rslt->delivery_note; $p_name=$burq_store_detailQry_rslt->storename; $p_phone=$burq_store_detailQry_rslt->phone; $p_notes="Pick up with care"; $tip="0"; $order_desc="Food Items"; $order_id=$orderprefix.$order_id; $burq_response=create_delivery($pickup,$dropoff,$item_list,$d_name,$d_phone,$d_notes,$p_name,$p_phone,$p_notes,$tip,$order_desc,$order_id); $burq_response=json_decode($burq_response, true); //print_r($burq_response); $burq_identifier = $burq_response['id']; $err=$burq_response['message']; if($burq_identifier){ $obj->query("update tbl_order_itmes set ups_tracking_no='$burq_identifier', courier='BURQUP' where storeid='$burq_store[$x]' and order_id='".$_REQUEST['order_id']."'"); //Assign to driver $initiate_response=initiate_delivery($burq_identifier); $initiate_response=json_decode($initiate_response, true); $err=$initiate_response['message']; $_SESSION['sess_msg']="Order assigned to BURQUP successfully.!"; }else{ $burq_error="Create : ".$err; $obj->query("update tbl_order_itmes set ups_tracking_no='$burq_error', courier='BURQUP Failed' where storeid='$burq_store[$x]' and order_id='$order_id'"); $_SESSION['sess_msg']="Order not assigned to BURQUP due to ".$err; } } header("location:order-list.php"); exit; } elseif($_REQUEST['submitForm']=='yes' && $_REQUEST['request_type']=='cancel') { $request_type=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['request_type']); $order_id=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['order_id']); $burq_store=$_POST['cstid']; $burq_store=array_unique($burq_store); for($x=0; $x<count($burq_store); $x++){ $store_query=$obj->query("select ups_tracking_no from tbl_order_itmes where storeid='$burq_store[$x]' and ups_tracking_no!='' and courier='burqup' and order_id='$order_id'"); $rslt_store=$obj->fetchNextObject($store_query); $identifier=$rslt_store->ups_tracking_no; $burq_response=cancel_delivery($identifier); $burq_response=json_decode($burq_response, true); $err=$burq_response['message']; if($err){ }else{ $obj->query("update tbl_order_itmes set courier='BURQUP Cancel' where storeid='$burq_store[$x]' and order_id='$order_id'"); } } if(!$err){ $_SESSION['sess_msg']="Order canceled for BURQUP.!"; }else{ $_SESSION['sess_msg']="Order not canceled to BURQUP due to ".$err; } header("location:order-list.php"); exit; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title><?php echo SITE_TITLE; ?></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/admin.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> function validate(obj){ if(obj.order_status.value=='') { alert("Please select status"); obj.order_status.focus(); return false; } if(obj.payment_status.value==1){ if(obj.pay_via.value!='' && obj.pay_via.value=='Credit/Debit Card'){ if(obj.transaction_id.value=='') { alert("Please enter transaction id"); obj.transaction_id.focus(); return false; } } if(obj.pay_amount.value==''){ alert("Please enter received amount"); obj.pay_amount.focus(); return false; } }} </script> <script type="text/javascript"> function showFields(val){ if(val==1){ document.getElementById('pay_details').style.display=''; }else{ document.getElementById('pay_details').style.display='none'; } } </script> <script type="text/javascript"> function showCardDetail(val){ if(val==1){ document.getElementById('card_details').style.display=''; }else{ document.getElementById('card_details').style.display='none'; } } </script> <script type="text/javascript" src="js/jquery-1.7.2.min.js"></script> <link rel="stylesheet" href="calender/css/jquery-ui.css"> <script src="calender/js/jquery-ui.js"></script> <script> $(document).ready(function () { $("#create").show(); $("#cancel").hide(); }); function burqSelection(selectionValue){ if(selectionValue == 'create'){ $("#create").show(); $("#cancel").hide(); } if(selectionValue == 'cancel'){ $("#create").hide(); $("#cancel").show(); } } </script> </head> <body> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="middle" class="headingbg bodr text14"><em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Assign to BURQUP On Order ID : <?php echo $_REQUEST['order_id']; ?></td> </tr> <tr> <td height="100" align="left" valign="top" bgcolor="#f7faf9" class="bodr"> <form name="frm" method="POST" enctype="multipart/form-data" action="" onSubmit="return validate(this)"> <input type="hidden" name="submitForm" value="yes" /> <input type="hidden" name="order_id" value="<?php echo $_REQUEST['order_id'];?>" /> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" style="color:#C00;"><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']=''; ?></td> </tr> <tr><br> <td width="33%" align="right" class="paddBot11 paddRt14"><strong>Request Type</strong></td> <td width="67%" align="left" class="paddBot11"><select name="request_type" onchange="burqSelection(this.value)" style="width:240px;" > <option value="create" selected>Create</option> <option value="cancel">Cancel</option> </select></td> </tr> <tr> <table id="create" width="100%"> <tr> <?php $sql_section=$obj->query("select section from tbl_order_itmes where order_id='".$_REQUEST['order_id']."' and courier!='burqup' and ups_tracking_no='' group by section"); if($obj->numRows($sql_section)){ while($rslt_section=$obj->fetchNextObject($sql_section)){ ?> <tr> <td width="33%" align="right" class="paddBot11 paddRt14"><br><strong><span style="font-size: 14px; color: #000"><?php echo ucwords($rslt_section->section); ?></strong></td> <td width="67%" align="left" class="paddBot11"></td> </tr> <?php $sql_store=$obj->query("select ot.storeid,storename from tbl_order_itmes ot join stores s on s.storeid=ot.storeid where order_id='".$_REQUEST['order_id']."' and courier!='burqup' and ups_tracking_no='' and section='$rslt_section->section' group by storeid"); while($rslt_store=$obj->fetchNextObject($sql_store)){ ?> <tr> <td width="33%" align="right" class="paddBot11 paddRt14"><strong><?php echo ucwords($rslt_store->storename); ?></strong></td> <td width="67%" align="left" class="paddBot11"><input type="checkbox" checked name="stid[]" value="<?php echo $rslt_store->storeid; ?>"></td> </tr> <?php } } ?> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td width="33%" align="right" class="paddRt14 paddBot11"> </td> <td width="67%" align="left" class="paddBot11"><input type="submit" name="submit" value="Send to Burqup" class="submit" border="0" /> </td> </tr> <?php }else{ echo "<td width='100%' align='center' style='color:red'><strong>Nothing to create</strong></td>"; }?> </tr> </table> <table id="cancel" width="100%"> <tr> <?php $sql_section=$obj->query("select section from tbl_order_itmes where order_id='".$_REQUEST['order_id']."' and courier='burqup' and ups_tracking_no!='' group by section"); if($obj->numRows($sql_section)){ while($rslt_section=$obj->fetchNextObject($sql_section)){ ?> <tr> <td width="33%" align="right" class="paddBot11 paddRt14"><br><strong><span style="font-size: 14px; color: #000"><?php echo ucwords($rslt_section->section); ?></strong></td> <td width="67%" align="left" class="paddBot11"></td> </tr> <?php $sql_store=$obj->query("select ot.storeid,storename from tbl_order_itmes ot join stores s on s.storeid=ot.storeid where order_id='".$_REQUEST['order_id']."' and courier='burqup' and ups_tracking_no!='' and section='$rslt_section->section' group by storeid"); while($rslt_store=$obj->fetchNextObject($sql_store)){ ?> <tr> <td width="33%" align="right" class="paddBot11 paddRt14"><strong><?php echo ucwords($rslt_store->storename); ?></strong></td> <td width="67%" align="left" class="paddBot11"><input type="checkbox" checked name="cstid[]" value="<?php echo $rslt_store->storeid; ?>"></td> </tr> <?php } } ?> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td width="33%" align="right" class="paddRt14 paddBot11"> </td> <td width="67%" align="left" class="paddBot11"><input type="submit" name="submit" value="Cancel for Burqup" class="submit" border="0" /> </td> </tr> <?php }else{ echo "<td width='100%' align='center' style='color:red'><strong>Nothing to Cancel</strong></td>"; }?> </tr> </table> </table> </form></td> </tr> <tr> <td align="center"></td> </tr> <?php $commentArr=$obj->query("select * from $tbl_order_comments where order_id='".$_REQUEST['order_id']."' order by id desc "); if($obj->numRows($commentArr)>0){?> <tr> <td><table width="100%" border="0" cellspacing="4" cellpadding="4" bgcolor="#f7faf9" class="bodr"> <tr> <td width="21%"><strong>Date</strong></td> <td width="21%"><strong>Pay Via</strong></td> <td width="21%"><strong>Received Amount</strong></td> <td width="21%"><strong>Received Date</strong></td> <td width="58%"><strong>Comment</strong></td> </tr> <?php while($resultComment=$obj->fetchNextObject($commentArr)){?> <tr> <td><?php echo date('d M Y H:i',strtotime($resultComment->posted_date)); ?></td> <td><?php if($resultComment->pay_via=='Credit/Debit Card'){ if($resultComment->transaction_id!=''){ echo 'Transaction ID:#'.$resultComment->transaction_id."<br/>"; } if($resultComment->card_number!=''){ echo 'Crad Last digits:'.$resultComment->card_number."<br/>"; } ?> <?php } else{?> Cash <?php }?></td> <td><?php if($resultComment->pay_amount!=0){echo 'Rs. '.stripslashes($resultComment->pay_amount);} ?></td> <td><?php if($resultComment->posted_date!='0000-00-00'){ echo stripslashes($resultComment->posted_date); }?></td> <td><?php echo stripslashes($resultComment->comments); ?></td> </tr> <?php } ?> </table></td> </tr> <?php } ?> </table> </td> </tr> </table> <?php if($resultOrder->coupon_code!=''){ // insert refer a friend reward point if($_REQUEST['order_status']==3 && $_REQUEST['payment_status']==1){ $referarr=$obj->query("select ref_user_id,hero from tbl_coupon where coupon_code='$resultOrder->coupon_code' and status=1"); $resultrefer=$obj->fetchNextObject($referarr); if($resultrefer->ref_user_id!='' && $resultrefer->hero==''){ $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='500', type='Cr', added_date='now()', status='1'"); } // insert be a hero reward point if($resultrefer->ref_user_id!='' && $resultrefer->hero=='0'){ $start_date= date('Y-m-01',strtotime(date('Y-m-d'))); $last_date = date('Y-m-t',strtotime(date('Y-m-d'))); $cArr=$obj->query("select count(*) as ordered from $tbl_order where coupon_code='$resultOrder->coupon_code' and order_date>'$start_date' and order_date<'$last_date'"); $os=$obj->fetchNextObject($cArr); if($os==5){ $rewardearned=5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } if($os==10){ $rewardearned=5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } if($os==15){ $rewardearned=5000; $obj->query("insert into tbl_reward_history set user_id='$resultrefer->ref_user_id', order_id='$order_id', reward_point='$rewardearned', type='Cr', added_date='now()', status='1'"); } } } } ?> </body> </html> Save