Edit file File name : quickllygo-sales-report.php Content :<?php include("../include/config.php"); include("../include/functions.php"); validate_admin(); ?> <!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" /> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <?php include("header.php") ?> <link rel="stylesheet" href="../colorbox/colorbox.css" /> <script src="../colorbox/jquery.colorbox.js"></script> <link rel="stylesheet" href="calender/css/jquery-ui.css"> <script src="calender/js/jquery-ui.js"></script> <script> $(function() { $( "#search_from_date" ).datepicker({ changeMonth: true, changeYear: true, dateFormat:'yy-mm-dd' , yearRange:'2014:<?php echo date('Y'); ?>', onClose: function( selectedDate ) { $( "#search_to_date" ).val(selectedDate); $( "#search_to_date" ).datepicker( "option", "minDate", selectedDate ); } }); $( "#search_to_date" ).datepicker({ changeMonth: true, changeYear: true, numberOfMonths: 2, dateFormat:'yy-mm-dd' , yearRange:'2014:<?php echo date('Y'); ?>', }) $( "#search_from_date" ).datepicker({ changeMonth: true, changeYear: true, dateFormat:'yy-mm-dd' , yearRange:'2014:<?php echo date('Y'); ?>', onClose: function( selectedDate ) { $( "#visit_date_to" ).val(selectedDate); $( "#visit_date_to" ).datepicker( "option", "minDate", selectedDate ); } }); $( "#search_to_date" ).datepicker({ changeMonth: true, changeYear: true, numberOfMonths: 2, dateFormat:'yy-mm-dd' , yearRange:'2014:<?php echo date('Y'); ?>', }) }); </script> <tr> <td align="right" class="paddRtLt70" valign="top"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <!------------ Search Section -----------------> <tr> <td align="left" valign="middle" class="bodr" style="padding-bottom:20px;"> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td class="headingbg bodr text14" style="padding-left:20px;">Search<span style="float:right; padding-right:10px;"></span></td> </tr> <tr><td height="10"></td></tr> <tr> <td> <form name="searchForm" method="post" action=""> <table width="100%" border="0" cellspacing="4" cellpadding="4"> <tr> <td width="11%" align="right" ><strong>Order ID:</strong></td> <td width="18%"><input type="text" name="search_order_id" value="<?php echo $_REQUEST['search_order_id']; ?>"/></td> <td width="12%" align="right" ><strong>Stores:</strong></td> <td width="15%"><select name="search_storename" style="width:150px;" > <option value="">All</option> <?php $storenum = $obj->query("select storeid,storename from stores where tab_store = 1 order by storename"); while ($storenumrec = $obj->fetchNextObject($storenum)) { ?> <option value="<?php echo $storenumrec->storeid; ?>" <?php if ($storenumrec->storeid == $_REQUEST['search_storename']) { ?>selected<?php } ?>><?php echo ucwords($storenumrec->storename); ?></option> <?php } ?> </select> <td width="6%" rowspan="2"><input type="submit" name="search" value="Search" /></td> <td width="16%" rowspan="2"><a href="tax-report.php">View All</a></td> </tr> <tr> <td width="12%" align="right" ><strong>Order Status:</strong></td> <td width="15%"><select name="order_status" style="width:150px;"> <option value="">-Select-</option> <?php $orderArr=$obj->query("select * from $tbl_order_status where status=1 order by id"); while($resultOrder=$obj->fetchNextObject($orderArr)){?> <option value="<?php echo stripslashes($resultOrder->id); ?>" <?php if($_REQUEST['order_status']==$resultOrder->id){?>selected<?php } ?> ><?php echo stripslashes($resultOrder->order_status); ?></option> <?php } ?> </select></td> <td width="11%" align="right" ><strong>Payment Status</strong></td> <td width="18%"><select name="payment_status" style="width:150px;"> <option value="">-Select-</option> <option value="1" <?php if($_REQUEST['payment_status']=='1'){ ?>selected<?php } ?>> Successful</option> <option value="0" <?php if($_REQUEST['payment_status']=='0'){ ?>selected<?php } ?>> Unsuccessful</option> </select></td> </tr> <tr> <td width="12%" align="right" ><strong>From Date:</strong></td> <td width="15%"><input type="text" name="search_from_date" id="search_from_date" value="<?php echo $_REQUEST['search_from_date']; ?>"/></td> <td width="8%" align="right" ><strong>To Date:</strong></td> <td width="14%"><input type="text" name="search_to_date" id="search_to_date" value="<?php echo $_REQUEST['search_to_date']; ?>"/></td> </tr> </table> </form> </td> </tr> </table> </td> </tr> <tr><td height="10"></td></tr> <!----- Search End ---------> <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: View Amount Breakup Report <span style="color:#FF3333"> Note: Reporting will be supported after March 2021</span> <span style="float:right;"> <form name="exportfrm" action="quickllygo-export-sales-report.php"> <input type="hidden" name="exportExcel" value="yes" /> <input type="hidden" name="search_order_id" value="<?php echo $_REQUEST['search_order_id'];?>" /> <input type="hidden" name="search_storename" value="<?php echo $_REQUEST['search_storename'];?>" /> <input type="hidden" name="payment_status" value="<?php echo $_REQUEST['payment_status'];?>" /> <input type="hidden" name="search_user_id" value="<?php echo $_REQUEST['search_user_id'];?>" /> <input type="hidden" name="order_status" value="<?php echo $_REQUEST['order_status'];?>" /> <input type="hidden" name="search_from_date" value="<?php echo $_REQUEST['search_from_date'];?>" /> <input type="hidden" name="search_to_date" value="<?php echo $_REQUEST['search_to_date'];?>" /> <input type="submit" name="export" class="button" value="Export To Excel" /> </form> </span> </td> </tr> <form name="frm" method="post" action="quickllygo-order-del.php" enctype="multipart/form-data"> <tr> <td height="100" align="left" valign="top" bgcolor="#FFFFFF" class="bodr"> <table width="100%" cellpadding="0" cellspacing="0"> <?php if($_SESSION['sess_msg']){ ?> <tr><td align="center"><font color="#FF0000"><strong><?php echo $_SESSION['sess_msg'];$_SESSION['sess_msg']='';?></strong></font></td></tr> <?php }?> <tr> <td align="left"> <?php $where=''; if($_REQUEST['search_order_id']!=''){ $name=$_REQUEST['search_order_id']; $where.=" and ot.order_id='".$name."'"; } if($_REQUEST['search_user_id']!=''){ $name=$_REQUEST['search_user_id']; $where.=" and o.user_id='".$name."'"; } if($_REQUEST['search_storename']!=''){ $name=$_REQUEST['search_storename'] ; $where.=" and ot.storeid = '$name'"; } if($_REQUEST['order_status']!=''){ $name=$_REQUEST['order_status'] ; $where.=" and o.order_status='".$name."'"; } if($_REQUEST['search_from_date']!='' && $_REQUEST['search_to_date']!=''){ $where.=" and o.order_date>='".$_REQUEST['search_from_date']."' and o.order_date<='".$_REQUEST['search_to_date']."' "; } if($_REQUEST['payment_status']!=''){ $name=$_REQUEST['payment_status']; $where.=" and o.payment_status='".$name."'"; } $start=0; if(isset($_GET['start'])) $start=$_GET['start']; $pagesize=100; if (isset($_GET['pagesize'])) $pagesize = $_GET['pagesize']; if($_REQUEST['search_storename']==''){ echo "<div align='center'><h2>Please select store!</h2></div>"; }else{ //echo "select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty)*8)/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty)*8)/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from tbl_order o left join tbl_order_itmes ot on o.id=ot.order_id where $where o.order_date>='2021-03-01' and o.order_date<='2021-03-31' group by o.id order by o.id"; //$storesql=$obj->query("select storename,tbl_store_zip.commission from stores left join tbl_store_zip on stores.storeid=tbl_store_zip.storeid where stores.storeid='".$_REQUEST['search_storename']."'"); //$resultstore=$obj->fetchNextObject($storesql); $storesql=$obj->query("select storename from stores where stores.storeid='".$_REQUEST['search_storename']."'"); $resultstore=$obj->fetchNextObject($storesql); $sql=$obj->Query("select o.id, sum(ot.wh_price*qty) as cartamt, sum(ot.wh_price*qty)-((sum(ot.wh_price*qty))/100)-(((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100) as paistoStore, (sum(ot.wh_price*qty))/100 as comm, sum(ot.wh_tax_value*qty) as totaltax,((sum(ot.wh_price*qty)+sum(ot.wh_tax_value*qty))*3)/100 as ccfee, o.delivery_type,o.order_date from go_order o left join go_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id"); $sql2=$obj->Query("select o.id from go_order o left join go_order_itmes ot on o.id=ot.order_id where o.order_date>'2020-04-01' $where group by o.id order by o.id"); $reccnt=$obj->numRows($sql2); if($reccnt==0) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center" valign="middle"><font face="Arial, Helvetica, sans-serif" color="#FF0000" size="+1">No Record</font></td> </tr> </table> <?php } else { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center" valign="middle"><strong><?php echo $reccnt; ?> Records Found.</strong></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="3%" align="left" class="padd5" bgcolor="#f3f4f6"><strong>S No.</strong></td> <td width="4%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Order ID</strong></td> <td width="5%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Cart Amount</strong></td> <!--<td width="5%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Amount Paid to <?php echo ucwords($resultstore->storename); ?></strong></td>--> <td width="9%" align="left" bgcolor="#f3f4f6" class="padd5"><strong> Refund Processed (due to items unavailability) </strong></td> <td width="7%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Quicklly Commission</strong></td> <td width="4%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Total Sales Tax</strong></td> <td width="5%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>CC Fees</strong></td> <td width="17%" align="left" bgcolor="#f3f4f6" class="padd5"><strong>Order Date & Time</strong></td> </tr> <?php $i=0; while($line=$obj->fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?> <tr bgcolor="<?php echo $bgcolor;?>"> <td class="padd5"><strong><?php echo $i+$start; ?>.</strong></td> <td class="padd5"> <?php echo stripslashes($line->id); ?> </td> <td class="padd5"> <?php echo number_format($line->cartamt,2); ?> </td> <!--<td class="padd5"> <?php echo number_format($line->paistoStore,2); ?> </td>--> <td class="padd5"> </td> <td class="padd5"> <?php echo number_format($line->comm,2); ?> </td> <td class="padd5"> <?php echo number_format($line->totaltax,2); ?> </td> <td class="padd5"> <?php echo number_format($line->ccfee,2); ?> <td class="padd5"> <?php echo date('d M Y H:i',strtotime($line->order_date)); ?> </td> </tr> <?php } ?> <tr> <td valign="top" colspan="14" align="right"> </td> </tr> <tr> <td valign="top" colspan="14" align="right" class="dark_red" style="padding-right:150px;"> </td> </tr> <tr> <td valign="top" colspan="14" align="right" class="dark_red" style="padding-right:150px;"><?php include("../include/paging.inc.php"); ?> </td> </tr> <tr> <td valign="top" colspan="14" align="right" class="dark_red" style="padding-right:150px;"> </td> </tr> <tr><td align="right" style="padding-right:80px;" colspan="14"> <input type="hidden" name="what" value="what" /> <!-- <input type="submit" name="Submit" value="Delete" class="button" onclick="return del_prompt(this.form,this.value)" /> --></td></tr> </table><?php } } ?> </td> </tr> </table> </td> </tr> </form> </table> </td> </tr> </table> </td> </tr> <tr><td height="100"></td></tr> <?php include('footer.php'); ?> </table> </body> </html> Save