View file File name : insta-update-store-order-status.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); include("../include/simpleimage.php"); include_once("insta_order_webhooks_oms_update.php"); validate_admin(); //echo "<pre>";print_r($_REQUEST);die; if($_REQUEST['submitForm']=='yes'){ $comments=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['comments']); $order_status=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['order_status']); $order_id=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['order_id']); $payment_status=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['payment_status']); $partner_order_id = $_REQUEST['partner_order_id']; $tracking_url = $_REQUEST['tracking_url']; $tracking_no = $_REQUEST['tracking_no']; $tracking_url = implode(',', $tracking_url); $tracking_no = implode(',', $tracking_no); $courier_vendor = $_REQUEST['courier_vendor']; $recordId = $_REQUEST['rdid']; //$tracking_url_2 = mysql_real_escape_string($_REQUEST['tracking_url_2']); //$tracking_no_2 = mysql_real_escape_string($_REQUEST['tracking_no_2']); if(!empty($tracking_url)) { $cond = " ,tracking_urls='$tracking_url',tracking_no='$tracking_no' , courier_vendor='$courier_vendor'"; } /* if(!empty($tracking_url_2)) { $cond2 = " ,tracking_urls2='$tracking_url_2',tracking_no2='$tracking_no_2' "; }*/ $obj->query("insert into insta_order_comments set comments='$comments',order_status='$order_status',payment_status='$payment_status',order_id='$order_id',posted_date=now(), storeid='$recordId'"); $obj->query("update insta_order_itmes set order_status='$order_status' $cond where order_id='$order_id' and storeid='$recordId' "); //die; if($order_status=='1') { //partner_order_accepted($order_id,$partner_order_id,"","",$obj); } if($order_status=='2') { //partner_order_update($order_id,$partner_order_id,$obj); } if($order_status=='3') { //partner_order_update($order_id,$partner_order_id,$obj); } if($order_status=='4') { //partner_order_update($order_id,$partner_order_id,$obj); } if($order_status=='5') { partner_order_update($order_id,$partner_order_id,$obj); } if($order_status=='6') { //partner_order_update($order_id,$partner_order_id,$obj); } if($order_status=='7') { //partner_order_canceled($order_id,$partner_order_id,$comments,$obj); $obj->query("update insta_order_itmes set order_status='$order_status' where order_id='$order_id' and storeid='$recordId' "); } if($order_status=='8') { //partner_order_rejected($order_id,$partner_order_id,$comments,$obj); } if($order_status=='9') { partner_order_update($order_id,$partner_order_id,$obj); } $_SESSION['sess_msg']="Order updated successfully.!"; } ?> <!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.order_status.value=='9') { if(obj.courier_vendor.value=='') { alert("Please courier type"); obj.courier_vendor.focus(); return false; } if(obj.tracking_no.value=='') { alert("Please tracking number"); obj.tracking_no.focus(); return false; } if(obj.tracking_url.value=='') { alert("Please tracking Url"); obj.tracking_url.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> $(function() { $( "#pay_date" ).datepicker({ changeMonth: true, changeYear: true, numberOfMonths: 1, dateFormat:'yy-mm-dd' , yearRange:'2014:<?php echo date('Y'); ?>', }) }); function showTrackInfo(divId, element) { var selectedItem = element.value; //document.getElementById(divId).style.display = element.value == 9 ? 'block' : 'none'; if(selectedItem == 9) { document.getElementById('show9_1').style.visibility = "visible"; document.getElementById('show9_2').style.visibility = "visible"; document.getElementById('show9_3').style.visibility = "visible"; document.getElementById('show9_5').style.visibility = "visible"; }else { document.getElementById('show9_1').style.visibility = "hidden"; document.getElementById('show9_2').style.visibility = "hidden"; document.getElementById('show9_3').style.visibility = "hidden"; document.getElementById('show9_5').style.visibility = "hidden"; } } </script> <script type="text/javascript"> $(document).ready(function () { var counter = 1; $("#add").click(function () { var tblid = "addedfield_" + counter; $("#resultField").append('<table width="100%" border="0" cellspacing="0" cellpadding="0" id="' + tblid + '" ><tr id="show9_1" style="visibility: visiable" ><td width="33%" align="right" class="paddBot11 paddRt14" ><strong>Tracking Number '+ counter+'</strong></td><td width="67%" align="left" class="paddBot11"><input type="text" name="tracking_no[]" id="tracking_no" size="36" /></td></tr><tr><td align="right" class="paddBot11 paddRt14" width="33%"><strong>Tracking Url '+ counter+'</strong></td><td align="left" class="paddBot11"><input name="tracking_url[]" type="text" size="36" value="" /><a href="javascript:void(0)" onclick="removeTxField('+ counter + ')" id="remove"> <img src="images/remove.png" title="Remove" border="0" /></a></td></tr> </table>'); counter++; }) }) function removeTxField(txtID) { //counter = counter - 1; counter = txtID; var tblid = "#addedfield_" + counter; $(tblid).remove(); } </script> </head> <body> <table width="100%" border="0" cellspacing="0" cellpadding="0" id="ins_main_table"> <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: Add Comment 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'];?>" /> <input type="hidden" name="partner_order_id" value="<?php echo $_REQUEST['partner_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> <td width="33%" align="right" class="paddBot11 paddRt14"><strong>Current Status</strong></td> <td width="67%" align="left" class="paddBot11"><select name="order_status" style="width:240px;" onchange="showTrackInfo('show9', this)" > <option value="">Select Status</option> <?php $statusArr=$obj->query("select * from insta_order_status where status=1 "); $current_status=getField('order_status','insta_order_itmes',$_REQUEST['order_id']); while($resultStatus=$obj->fetchNextObject($statusArr)){ ?> <option value="<?php echo $resultStatus->id; ?>" <?php if($resultStatus->id==$current_status){ ?>selected<?php } ?>><?php echo stripslashes($resultStatus->order_status); ?></option> <?php } ?> </select></td> </tr> <tr> <td width="33%" align="right" class="paddBot11 paddRt14"><strong>Comment</strong></td> <td width="67%" align="left" class="paddBot11"><textarea name="comments" rows="2" cols="30"></textarea></td> </tr> <tr id="show9_5" style="visibility: hidden"> <td width="33%" align="right" class="paddBot11 paddRt14"><strong>Courier Type</strong></td> <td width="67%" align="left" class="paddBot11"><select name="courier_vendor" style="width:240px;" > <option value="">Select Courier Type</option> <?php $statusArr=$obj->query("select * from tbl_courier_vendor where status=1 "); $current_ctype=getField('courier_vendor','insta_order_itmes',$_REQUEST['order_id']); while($resultStatus=$obj->fetchNextObject($statusArr)){ ?> <option value="<?php echo $resultStatus->id; ?>" <?php if($resultStatus->id==$current_ctype){ ?>selected<?php } ?>><?php echo stripslashes($resultStatus->title); ?></option> <?php } ?> </select></td> </tr> <tr id="show9_1" style="visibility: hidden" > <td width="33%" align="right" class="paddBot11 paddRt14" ><strong>Tracking Number</strong></td> <td width="67%" align="left" class="paddBot11"> <input type="text" name="tracking_no[]" id="tracking_no" size="36" /> </td> </tr> <tr id="show9_2" style="visibility: hidden"> <td width="33%" align="right" class="paddBot11 paddRt14"><strong>Tracking Url</strong></td> <td width="67%" align="left" class="paddBot11"> <input type="text" name="tracking_url[]" id="tracking_url" size="36" /> </td> </tr> <tr> <td colspan="2" id="resultField"></td> </tr> <tr id="show9_3" style="visibility: hidden"> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"><!--<a href="javascript:void(0)" id="add"> <img src="images/add.png" title="Add More" border="0" /></a>--> </td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td align="left" class="paddRt14 paddBot11" colspan="2"><span style="font-weight:bold;color:red;">Note:</span></td> </tr> <tr> <td align="left" class="paddRt14 paddBot11" colspan="2">Shipping: The order has been shipped by the partner. include the tracking URL and number.</td> </tr> <tr> <td align="left" colspan="2" class="paddRt14 paddBot11">Delivered: The order has been delivered and is completed</td> </tr> <tr> <td align="left" colspan="2" class="paddRt14 paddBot11">Canceled: The order has been canceled. Either rejected by the partner OMS.</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="Submit" class="submit" border="0" /> </td> </tr> </table> </form></td> </tr> <tr> <td align="center"></td> </tr> </table> </td> </tr> </table> </body> </html>