<?php

require_once("../../loader.php");

$db = new Conexion;
$user = new User;
$core = new Core;
$userData = $user->cdp_getUserData();

$search = cdp_sanitize($_REQUEST['search']);
$status_courier = intval($_REQUEST['status_courier']);

$sWhere = "";

if ($userData->userlevel == 3) {

	$sWhere .= " and  a.driver_id = '" . $_SESSION['userid'] . "'";
} else if ($userData->userlevel == 1) {

	$sWhere .= " and  a.sender_id = '" . $_SESSION['userid'] . "'";
} else {
	$sWhere .= "";
}


if ($search != null) {

	$sWhere .= "and CONCAT(a.order_prefix,a.order_no) LIKE '%" . $search . "%'";
 
}

if ($status_courier > 0) {

	$sWhere .= " and  a.status_courier = '" . $status_courier . "'";
}



$filterby = intval($_REQUEST['filterby']);

if ($filterby > 0) {

	if ($filterby == 1) {
		$is_pickup_filter = 1;
	} else {
		$is_pickup_filter = 0;
	}

	$sWhere .= " and  a.is_pickup = '" . $is_pickup_filter . "'";
}

if ($filterby == 3) {

	$sWhere .= " and  a.is_consolidate = '1'";
}


// // pagination variables
$page = (isset($_REQUEST['page']) && !empty($_REQUEST['page'])) ? $_REQUEST['page'] : 1;
$per_page = 10; //how much records you want to show
$adjacents  = 4; //gap between pages after number of adjacents
$offset = ($page - 1) * $per_page;

$db->cdp_query("UPDATE cdb_add_order SET  status_invoice =3  WHERE due_date<now() and status_invoice !=1 and order_payment_method >1");


$db->cdp_execute();


$sql = "SELECT a.order_incomplete,  a.status_invoice,  a.is_consolidate, a.is_pickup,  a.total_order, a.order_id, a.order_prefix, a.order_no, a.order_date, a.sender_id, a.receiver_id, a.order_courier, c.order_item_quantity, c.order_item_description,
        a.order_pay_mode, a.status_courier, a.driver_id, a.order_service_options, a.total_weight,  b.mod_style, b.color, d.phone, d.fname, d.lname FROM
			 cdb_add_order as a
			 INNER JOIN cdb_styles as b ON a.status_courier = b.id
			 INNER JOIN cdb_add_order_item as c ON a.order_id = c.order_id
			 INNER JOIN cdb_users as d ON a.receiver_id = d.id
			 $sWhere
			  and a.status_courier!=22
			 order by order_id desc 
			 ";


$query_count = $db->cdp_query($sql);
$db->cdp_execute();
$numrows = $db->cdp_rowCount();

$db->cdp_query($sql . " limit $offset, $per_page");
$data = $db->cdp_registros();

$total_pages = ceil($numrows / $per_page);


if ($numrows > 0) { ?>
	<div class="table-responsive">


		<table id="zero_config" class="table table-condensed table-hover table-striped custom-table-checkbox">
			<thead>
				<tr>
					<?php
					if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>

						<th>
							<div class="custom-control custom-checkbox">
								<input type="checkbox" class="custom-control-input sl-all" id="cstall">
								<label class="custom-control-label" for="cstall"></label>
							</div>
						</th>
					<?php
					}
					?>
					<th><b><?php echo $lang['ltracking'] ?></b></th>
					<th class="text-center"><b><?php echo $lang['ddate'] ?></b></th>
					<?php
					if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
					<th class="text-center"><b>Sender</b></th>
					<?php } ?>
					<th class="text-center"><b>Receiver</b></th>
					<th class="text-center"><b>R.Phone</b></th>
					<th class="text-center"><b>Description</b></th>
					<th class="text-center"><b>Quantity</b></th>
					<th class="text-center"><b>Weight (Kgs.)</b></th>
					<?php
					if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
					<th class="text-center"><b><?php echo $lang['lorigin'] ?></b></th>
					<?php } ?>

					<th class="text-center"><b><?php echo $lang['ldestination'] ?></b></th>
					<!-- <th class="text-center"><b><?php echo $lang['lshipline'] ?></b></th> -->
					<th class="text-center"><b><?php echo $lang['lpayment'] ?></b></th>
					<th class="text-center"><b><?php echo $lang['lstatusshipment'] ?></b></th>
					<th class=""><b><?php echo $lang['ship-all5'] ?></b></th>
					<th class="text-center"></th>
					<th class="text-center"><b>Invoice Status</b></th>

					<th class="text-center"><b><?php
												?></b></th>
				</tr>
			</thead>
			<tbody id="projects-tbl">


				<?php if (!$data) { ?>
					<tr>
						<td colspan="6">
							<?php echo "
				<i align='center' class='display-3 text-warning d-block'><img src='assets/images/alert/ohh_shipment.png' width='150' /></i>								
				", false; ?>
						</td>
					</tr>
				<?php } else { ?>

					<?php

					$count = 0;
					foreach ($data as $row) {

						$db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->sender_id . "'");
						$sender_data = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->receiver_id . "'");
						$receiver_data = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_users where id= '" . $row->driver_id . "'");
						$driver_data = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_courier_com where id= '" . $row->order_courier . "'");
						$courier_com = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_met_payment where id= '" . $row->order_pay_mode . "'");
						$met_payment = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_shipping_mode where id= '" . $row->order_service_options . "'");
						$order_service_options = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_styles where id= '14'");
						$status_style_pickup = $db->cdp_registro();

						$db->cdp_query("SELECT * FROM cdb_styles where id= '13'");
						$status_style_consolidate = $db->cdp_registro();
						
						$db->cdp_query("SELECT currency FROM cdb_add_order WHERE order_id='" . $row->order_id . "'");
                        $curr = $db->cdp_registro();


						if ($row->status_invoice == 1) {

							$text_status = $lang['invoice_paid'];
							$label_class = "label-success";
						} else if ($row->status_invoice == 2) {

							$text_status = $lang['invoice_pending'];
							$label_class = "label-warning";
						} else if ($row->status_invoice == 3) {
							$text_status = $lang['verify_payment'];
							$label_class = "label-info";
						}



						$db->cdp_query("SELECT * FROM cdb_address_shipments where order_track='" . $row->order_prefix . $row->order_no . "'");
						$address_order = $db->cdp_registro();



					?>


						<tr class="card-hovera">
							<?php
							if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
								<td class="chb">
									<?php if ($row->status_courier != 8) { ?>
										<?php if ($row->status_courier != 21) { ?>

											<div class="custom-control custom-checkbox">
												<input type="checkbox" class="custom-control-input" value="<?php echo $row->order_no; ?>" name="checkbox[]" id="cst_<?php echo $count; ?>">
												<label class="custom-control-label" for="cst_<?php echo $count; ?>">&nbsp;</label>
											</div>

										<?php } ?>
									<?php } ?>

								</td>
							<?php } ?>
							<td><b><a href="courier_view.php?id=<?php echo $row->order_id; ?>"><?php echo $row->order_prefix . $row->order_no; ?></a></b></td>
							<td class="text-center">
								<?php echo $row->order_date; ?>
							</td>
							<?php
								if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
							<td class="text-center">
								<?php echo $sender_data->fname; ?> <?php echo $sender_data->lname; ?>
							</td>
							<?php } ?>
							<td class="text-center">
								<?php echo $receiver_data->fname; ?> <?php echo $receiver_data->lname; ?>
							</td>
							<td class="text-center">
								<?php echo $receiver_data->phone; ?>
							</td>
							
							<td class="text-center">
								<?php echo $row->order_item_description; ?>
							</td>
							<td class="text-center">
								<?php echo $row->order_item_quantity; ?>
							</td>
							<td class="text-center">
								<?php echo $row->total_weight; ?>
							</td>

							<?php
							if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
							<td class="text-center"><?php echo $address_order->sender_country; ?>-<?php echo $address_order->sender_city; ?></td>
							<?php } ?>
							<td class="text-center"><?php echo $address_order->recipient_country; ?>-<?php echo $address_order->recipient_city; ?></td>

							<td class="text-center"><?php echo $met_payment->name_pay; ?></td>

							<td class="">

								<span style="background: <?php echo $row->color; ?>;" class="label label-large"><?php echo $row->mod_style; ?></span>
								<br>

								<?php
								if ($row->is_pickup == true) { ?>

									<span style="background: <?php echo $status_style_pickup->color; ?>;" class="label label-large"><?php echo $status_style_pickup->mod_style; ?></span>
								<?php
								}
								?>

								<?php
								if ($row->is_consolidate == true) { ?>

									<span style="background: <?php echo $status_style_consolidate->color; ?>;" class="label label-large"><?php echo $status_style_consolidate->mod_style; ?></span>
								<?php
								}
								?>
							</td>

							<td class="text-center">
								<b><?php echo $curr->currency; ?></b> <?php echo $row->total_order; ?>
							</td>

							<td class="text-center">
								<?php if ($row->status_invoice == 2) { ?>
										<?php if ($userData->userlevel == 1) { ?>

										<a style="background: #34e89e;" class="label label" href="add_payment_gateways_courier.php?id_order=<?php echo $row->order_id; ?>">
                            			<i style="color:#343a40" class="fas fa-dollar-sign"></i>&nbsp;Add payment</a>
                            		<?php } ?>
                            	<?php } ?>	
							</td>

							<td>
								<span class="label label-large <?php echo $label_class; ?>"><?php echo $text_status; ?></span>

							</td>
							<td align='center'>
								<div class="btn-group">
									<button class="btn btn-info btn-sm dropdown-toggle" type="button" data-toggle="dropdown" data-flip="false">Actions
									</button>
									<div class="dropdown-menu scrollable-menu">
										<a class="dropdown-item" href="courier_view.php?id=<?php echo $row->order_id; ?>" title="<?php echo $lang['tooledit'] ?>"><i style="color:#343a40" class="fa fa-search"></i>&nbsp;Show details</a>


										<?php if ($row->status_invoice == 2) { ?>
											<?php if ($userData->userlevel == 1) { ?>



												<a class="dropdown-item" href="add_payment_gateways_courier.php?id_order=<?php echo $row->order_id; ?>">
													<i style="color:#343a40" class="fas fa-dollar-sign"></i>&nbsp;Add invoice payment</a>


											<?php } ?>

										<?php } ?>

										<?php if ($row->status_invoice == 3) { ?>
											<?php if ($userData->userlevel != 1) { ?>


												<a class="dropdown-item" data-toggle="modal" data-target="#detail_payment_packages" data-id="<?php echo $row->order_id; ?>" data-customer="<?php echo $row->sender_id; ?>"><i style="color:#343a40" class="fas fa-dollar-sign"></i>&nbsp; Verify payment</a>


											<?php } ?>

										<?php } ?>


										<?php if ($row->order_incomplete == 0) { ?>
											<?php if ($row->is_pickup == 0) { ?>
												<?php if ($userData->userlevel != 1 || $userData->userlevel != 3) { ?>


													<a class="dropdown-item" href="courier_accept.php?id=<?php echo $row->order_id; ?>" title="<?php echo $lang['tooledit'] ?>"><i style="color:#343a40" class="ti-pencil"></i>&nbsp; Complete shipment</a>


												<?php } ?>
												<a class="dropdown-item" href="print_label_ship.php?id=<?php echo $row->order_id; ?>" target="_blank"> <i style="color:#343a40" class="ti-printer"></i>&nbsp;<?php echo $lang['toollabel'] ?> </a>
											<?php } ?>
										<?php } ?>



										<?php if ($row->order_incomplete == 1) { ?>


											<?php if ($userData->userlevel != 1) { ?>

												<?php if ($row->is_consolidate == 0) { ?>
													<?php if ($userData->userlevel == 9) { ?>
														<?php if ($row->status_courier != 8) { ?>

															<a class="dropdown-item" href="courier_edit.php?id=<?php echo $row->order_id; ?>" title="<?php echo $lang['tooledit'] ?>"><i style="color:#343a40" class="ti-pencil"></i>&nbsp;<?php echo $lang['tooledit'] ?></a>
														<?php } ?>
													<?php } ?>
												<?php } ?>

											<?php } ?>


											<?php if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>

												<?php if ($row->status_courier != 21 || $row->status_courier != 12) { ?>

													<?php if ($row->status_invoice == 1) { ?>

														<a class="dropdown-item" data-toggle="modal" data-target="#charges_list" data-id="<?php echo $row->order_id; ?>"><i style="color:#343a40" class="fas fa-dollar-sign"></i>&nbsp;Receipt</a>
													<?php } ?>
												<?php } ?>
											<?php } ?>




											<?php if ($userData->userlevel == 9 || $userData->userlevel == 3 || $userData->userlevel == 2) { ?>

												<?php if ($row->status_courier != 8) { ?>
													<?php if ($row->status_courier != 21) { ?>
														<?php if ($row->status_courier != 12) { ?>

															<a class="dropdown-item" data-toggle="modal" data-target="#modalDriver" data-id_shipment="<?php echo $row->order_id; ?>"><i style="color:#ff0000" class="fas fa-car"></i>&nbsp; <?php echo $lang['left208'] ?></a>
														<?php } ?>
													<?php } ?>
												<?php } ?>
											<?php } ?>


											<?php if ($row->status_courier != 21) { ?>
												<?php if ($row->status_courier != 12) { ?>


													<a class="dropdown-item" target="blank" href="print_inv_ship.php?id=<?php echo $row->order_id; ?>"> <i style="color:#343a40" class="ti-printer"></i>&nbsp;<?php echo $lang['toolprint'] ?></a>

													<a class="dropdown-item" href="print_label_ship.php?id=<?php echo $row->order_id; ?>" target="_blank"> <i style="color:#343a40" class="ti-printer"></i>&nbsp;<?php echo $lang['toollabel'] ?> </a>

													<?php if ($userData->userlevel == 9 || $userData->userlevel == 3 || $userData->userlevel == 2) { ?>

														<?php if ($row->is_consolidate == 0) { ?>

															<?php if ($row->status_courier != 8) { ?>
																<?php if ($row->status_courier != 21) { ?>
																	<?php if ($row->status_courier != 12) { ?>


																		<a class="dropdown-item" href="courier_shipment_tracking.php?id=<?php echo $row->order_id; ?>" title="<?php echo $lang['toolupdate'] ?>"><i style="color:#20c997" class="ti-reload">&nbsp;</i><?php echo $lang['toolupdate'] ?></a>

																		<a class="dropdown-item" href="courier_deliver_shipment.php?id=<?php echo $row->order_id; ?>" title="<?php echo $lang['tooldeliver'] ?>"><i style="color:#2962FF" class="ti-package"></i>&nbsp;<?php echo $lang['tooldeliver'] ?></a>
																	<?php } ?>
																<?php } ?>
															<?php } ?>
														<?php } ?>
													<?php } ?>




													<?php if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
														<?php if ($row->is_consolidate == 0) { ?>
															<?php if ($row->status_courier != 8) { ?>
																<?php if ($row->status_courier != 21) { ?>
																	<?php if ($row->status_courier != 12) { ?>

																		<a class="dropdown-item" data-id="<?php echo $row->order_id; ?>" href="#" data-toggle="modal" data-target="#myModalCancel"> <i style="color:#f62d51" class="fas fa-times-circle"></i>&nbsp;Cancel</a>

																	<?php } ?>
																<?php } ?>
															<?php } ?>
														<?php } ?>
													<?php } ?>



													<?php if ($userData->userlevel == 9 || $userData->userlevel == 2) { ?>
														<?php if ($row->is_consolidate == 0) { ?>
															<?php if ($row->status_courier != 8) { ?>
																<?php if ($row->status_courier != 21) { ?>
																	<?php if ($row->status_courier != 12) { ?>


																		<a class="dropdown-item" data-id="<?php echo $row->order_id; ?>" href="#" data-toggle="modal" data-target="#myModalDeletes"> <i style="color:#f62d51" class="ti-trash"></i>&nbsp;Delete</a>

																	<?php } ?>
																<?php } ?>
															<?php } ?>
														<?php } ?>
													<?php } ?>




													<?php if ($userData->userlevel == 9 || $userData->userlevel == 2 || $userData->userlevel == 3) { ?>

														<a class="dropdown-item" href="#" data-toggle="modal" data-id="<?php echo $row->order_id; ?>" data-email="<?php echo $sender_data->email; ?>" data-order="<?php echo $row->order_prefix . $row->order_no; ?>" data-target="#myModal"><i class="fas fa-envelope"></i>&nbsp;Send email</a>

													<?php } ?>
												<?php } ?>

											<?php } ?>
										<?php } ?>
									</div>
								</div>
							</td>
						</tr>
					<?php $count++;
					} ?>

				<?php } ?>
			</tbody>
		</table>


		<div class="pull-right">
			<?php echo cdp_paginate($page, $total_pages, $adjacents);	?>
		</div>


		<script src="dataJs/courier_ajax.js"></script>


	</div>
<?php } ?>
