MAINHACK

Viewing / Editing File: order_by_delivery.php

<?php include'header.php';?>

<?php
if(isset($_POST['sub'])){
    $count=1;

$date1=date("Y-m-d",strtotime($_POST['date1']))." 00:00:00";
$date2=date("Y-m-d",strtotime($_POST['date2']))." 23:59:59";

$sq="select * from place_order where date between '$date1' and '$date2' and agent_id='".$_REQUEST['did']."' order by id desc ";
//$sq="select * from place_order where agent_id='".$_REQUEST['did']."' order by id desc ";
$r=$con->prepare($sq);
$r->execute();
while($row = $r->fetch(PDO::FETCH_ASSOC)){
	//$status=$row['status'];
$pro_id=$row['order_id'];
$paym=$row['pay_status'];
$txid=empty($row['txid'])?"---":$row['txid'];

$sq1=$show->readwithdata('food_maker','maker_id',$row['maker_id']);
while($row1=$sq1->fetch(PDO::FETCH_ASSOC)){
$com_name=$row1['title'];
$maker_name=$row1['name'];
$mphone=$row1['phone'];
$locality=$row1['locality'];
	    
	}
	        $delivery_type=$row['delivery_type'];

if($delivery_type=='pickup'){
        $del_amt="-".$row['self_pickup'];
        $del_label='Self-pickup';
    }else{
    $del_amt=$row['delivery_charge'];
         $del_label='Home-Delivery';

}
    //<a href='repeat_order.php?uid=".base64_encode($row['user_id'])."&bid=".base64_encode($pro_id)."' class='btn btn-info btn-xs' >Repeat Order</a>
echo "	<tr>
								  <td>$count</td>
								  <td>".$row['order_id']." </td>
								  <td>".$row['client_name']."<br>".$row['email']."<br>".$row['phon']."</td>
								  <td>".$com_name."<br>".$maker_name."<br>".$mphone."</td>
								  <td>Bill Total:".$row['total']."<br>
								    $del_label:".$del_amt."<br>
								    Tax:".$row['gst']."<br>
								    </td>
								  <td>".date('d-m-Y h:i A',strtotime($row['date']))."</td>
								    <td>".$paym."</td>
								    <td>".$txid."</td>
									<td>".$row['status']."</td>
									<td>".$locality."</td>
								   <td><a href='bill_final.php?uid=".base64_encode($row['user_id'])."&bid=".base64_encode($pro_id)."' target='_blank'class='btn btn-secondary btn-xs'>Show Bill</a>
								  <a href='#' class='btn btn-danger btn-xs' onclick='return send();'>Delete</a>
								 </td>
								</tr>";

++$count;
								}

}else{
$count=1;

$date1=date("Y-m-d")." 00:00:00";
$date2=date("Y-m-d")." 23:59:59";

//$sq="select * from place_order where date between '$date1' and '$date2' and status!='paid'  group by order_id order by id desc ";
$sq="select * from place_order where agent_id='".$_REQUEST['did']."' order by id desc ";
$r=$con->prepare($sq);
$r->execute();
while($row = $r->fetch(PDO::FETCH_ASSOC)){
	//$status=$row['status'];
$pro_id=$row['order_id'];
$paym=$row['pay_status'];
$txid=empty($row['txid'])?"---":$row['txid'];

if($delivery_type=='pickup'){
        $del_amt="-".$row['self_pickup'];
        $del_label='Self-pickup';
    }else{
    $del_amt=$row['delivery_charge'];
         $del_label='Home-Delivery';

++$count;
								}

}
?>			
</tbody></table>								
									
									</div>
				
									</div>
								</div>
							</div>
						</div>

</div>
				</div>
			</div>
			
		</div>

$('#multi-filter-select').DataTable( {
				"pageLength": 5,
				initComplete: function () {
					this.api().columns().every( function () {
						var column = this;
						var select = $('<select class="form-control"><option value=""></option></select>')
						.appendTo( $(column.footer()).empty() )
						.on( 'change', function () {
							var val = $.fn.dataTable.util.escapeRegex(
								$(this).val()
								);

column
							.search( val ? '^'+val+'$' : '', true, false )
							.draw();
						} );

column.data().unique().sort().each( function ( d, j ) {
							select.append( '<option value="'+d+'">'+d+'</option>' )
						} );
					} );
				}
			});

// Add Row
			$('#add-row').DataTable({
				"pageLength": 5,
			});

var action = '<td> <div class="form-button-action"> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task"> <i class="la la-edit"></i> </button> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <i class="la la-times"></i> </button> </div> </td>';

$('#addRowButton').click(function() {
				$('#add-row').dataTable().fnAddData([
					$("#addName").val(),
					$("#addPosition").val(),
					$("#addOffice").val(),
					action
					]);
				$('#addRowModal').modal('hide');

});
		});
	</script>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: order_by_delivery.php

Server Info

System Features

User Info