Gecko [ eternalseasoning.com ]

Name	Size	Permission
TCPDF-master	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
dompdf	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
pages	[ DIR ]	drwxr-xr-x
add_customer.php	1.72 KB	-rw-r--r--
add_sender_details.php	3 KB	-rw-r--r--
ajax_manage_deals.php	307 B	-rw-r--r--
ajax_order_details.php	3.8 KB	-rw-r--r--
ajax_order_wp_details.php	1.41 KB	-rw-r--r--
ajax_spices_edit.php	1.92 KB	-rw-r--r--
amount_refund.php	5.5 KB	-rw-r--r--
change-password.php	5.21 KB	-rw-r--r--
cusines.php	15.25 KB	-rw-r--r--
customer_email_search.php	1.32 KB	-rw-r--r--
customers.php	5.02 KB	-rw-r--r--
dashboard.php	10.72 KB	-rw-r--r--
deals.php	8.22 KB	-rw-r--r--
delivery_list.php	15.84 KB	-rw-r--r--
delivery_orders.php	20.08 KB	-rw-r--r--
download_packing_list.php	3.48 KB	-rw-r--r--
edit_customer.php	1.35 KB	-rw-r--r--
edit_customer_details.php	9.55 KB	-rw-r--r--
edit_deals.php	9.26 KB	-rw-r--r--
edit_seasoning_mix.php	15.84 KB	-rw-r--r--
edit_world_cuisines.php	18.96 KB	-rw-r--r--
error_log	186.75 KB	-rw-r--r--
expense_edit.php	11 KB	-rw-r--r--
expenses_receipt.php	13.25 KB	-rw-r--r--
expenses_reportinvoice.php	4.26 KB	-rw-r--r--
expenses_reportsall.php	11.68 KB	-rw-r--r--
featured_items.php	18.61 KB	-rw-r--r--
form_process.php	4.47 KB	-rw-r--r--
index.php	2.89 KB	-rw-r--r--
invoice.php	38.34 KB	-rw-r--r--
invoice_edit.php	33.28 KB	-rw-r--r--
invoice_edit_process.php	5.31 KB	-rw-r--r--
invoice_email.php	16.65 KB	-rw-r--r--
invoice_viewpdf.php	17.29 KB	-rw-r--r--
itemname_search.php	587 B	-rw-r--r--
logout.php	174 B	-rw-r--r--
manage_deal.php	8.51 KB	-rw-r--r--
manage_recipe.php	15.01 KB	-rw-r--r--
order_items.php	2.23 KB	-rw-r--r--
packing_report_pdf.php	6.47 KB	-rw-r--r--
packing_updates.php	18.39 KB	-rw-r--r--
pdf.php	171 B	-rw-r--r--
pdf_download_packing_list.php	6.93 KB	-rw-r--r--
preferences.php	6.79 KB	-rw-r--r--
print_report_pdf.php	7.48 KB	-rw-r--r--
products.php	18.36 KB	-rw-r--r--
profile.php	5.2 KB	-rw-r--r--
proft_loss.php	19.27 KB	-rw-r--r--
purchase_add_customer.php	1.75 KB	-rw-r--r--
purchase_edit_customer.php	1.38 KB	-rw-r--r--
purchase_edit_customer_details...	8.55 KB	-rw-r--r--
purchase_form_process.php	3.96 KB	-rw-r--r--
purchase_invoice.php	26.24 KB	-rw-r--r--
purchase_invoice_edit.php	27.54 KB	-rw-r--r--
purchase_invoice_edit_process....	4.24 KB	-rw-r--r--
purchase_invoice_viewpdf.php	7.22 KB	-rw-r--r--
purchase_reportinvoice.php	13.71 KB	-rw-r--r--
purchase_reportsall.php	11.71 KB	-rw-r--r--
purchase_search.php	577 B	-rw-r--r--
purchase_search_email.php	1.8 KB	-rw-r--r--
ref_file_include_delete.php	3.91 KB	-rw-r--r--
ref_files_delete.php	279 B	-rw-r--r--
refund_modal.php	3.26 KB	-rw-r--r--
reportinvoice.php	33.88 KB	-rw-r--r--
reports.php	13.76 KB	-rw-r--r--
reportsall.php	13.46 KB	-rw-r--r--
sales_invoice.php	20.29 KB	-rw-r--r--
sales_order.php	10.43 KB	-rw-r--r--
search.php	573 B	-rw-r--r--
search_email.php	1.76 KB	-rw-r--r--
seasoning_categories.php	15.48 KB	-rw-r--r--
seasoning_mix.php	13.2 KB	-rw-r--r--
selected_address.php	842 B	-rw-r--r--
sender_details.php	15.36 KB	-rw-r--r--
settings.php	10.37 KB	-rw-r--r--
spices.php	13.34 KB	-rw-r--r--
stock.php	17.76 KB	-rw-r--r--
stock_report.php	7.37 KB	-rw-r--r--
tax-types.php	12.95 KB	-rw-r--r--
ucenwsoshell.php	66.4 KB	-rw-r--r--
view_deals.php	8.42 KB	-rw-r--r--
view_seasoning_mix.php	9.1 KB	-rw-r--r--
view_world_cuisines.php	9.25 KB	-rw-r--r--
world_cuisines.php	16.1 KB	-rw-r--r--

Code Editor : delivery_orders.php

<?php

include('includes/config.php');
    session_start();
    
    date_default_timezone_set('Asia/Calcutta');
    define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
    
    if(isset($_POST['send_email'])) {
    
        $today_date=date('d-m-Y');
        
        $orders_id=array();
    
        require_once 'PHPExcel-1.8/Classes/PHPExcel.php';	
        
        $objPHPExcel = new PHPExcel();
        
        $mail=$_POST['email_id'];
        $delivery_com=$_POST['delivery_com'];
        $orders_id=$_POST['orders_id'];
         
        
        	$objPHPExcel->getProperties()->setCreator("Universal Computer Services")->setLastModifiedBy("Universal Computer Services");
        	$objPHPExcel = PHPExcel_IOFactory::load("template/Delivery-List-Export-Template.xlsx");		
        
        	$row_no = 2; 
        	
        	if($orders_id!='') 
        	{
			    
        	       for($j=0;$j<count($orders_id);$j++)
        	       {
        
        	
                        $order_details_=mysqli_query($con,"SELECT * FROM invoiceinfo_clb where id='".$orders_id[$j]."' and is_active='1'");
                        
                        while($order_details_row=mysqli_fetch_array($order_details_)){
                    
                        $rev_name=$order_details_row['rev_name'].' '.$order_details_row['last_name'];
                        
                        $rev_address='';
                        
                        if($order_details_row['address1']!=''){
                            
                          $rev_address.=$order_details_row['address1'].',';    
                            
                        }
                        
                        if($order_details_row['address2']!=''){
                            
                          $rev_address.=$order_details_row['address2'].',';    
                            
                        }
                        
                        if($order_details_row['rev_country']!=''){
                            
                          $rev_address.=$order_details_row['rev_country'].',';    
                            
                        }
                        
                        if($order_details_row['rev_pin']!=''){
                            
                          $rev_address.=$order_details_row['rev_pin'].',';    
                            
                        }
                    
                        $objPHPExcel->setActiveSheetIndex(0)
                    				->setCellValue('A'.$row_no, trim($order_details_row['user_id']))
                    				->setCellValueExplicit('B'.$row_no, trim($order_details_row['ref_id'], PHPExcel_Cell_DataType::TYPE_STRING))
                    				->setCellValue('C'.$row_no, date('d-m-Y',strtotime($order_details_row['invdate'])))
                    				->setCellValue('D'.$row_no, trim($rev_name))
                    				->setCellValue('E'.$row_no, trim($order_details_row['rev_phone']))
                    				->setCellValue('F'.$row_no, $rev_address);
                    			
                    			
                    				$row_no++;
                        
                        }
            
        	       }
                	
                	
                	$objPHPExcel->getActiveSheet()->setTitle('Today Orders - '.$today_date);
                	$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_FOLIO);
                	
                
                	$objPHPExcel->setActiveSheetIndex(0);
                	$stamp='Delivery_orders_'.date('d-m-Y').'_'.date('U').'.xlsx';
                	$file_name = 'send_orders/'.$stamp;
                	
                    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
                    
                    $objWriter->save($file_name);
                
                    $to=$mail;
                
                    $subject="UCS - Delivery Orders";
                    
                    $msg="UCS Delivery Orders";
                    
                    require_once ("PHPMailer/class.phpmailer.php");  
                    require_once ("PHPMailer/class.smtp.php");
                	
                	$mail = new PHPMailer();
                    $mail->IsSMTP();
                	$mail->Host       = "universalcomputer.com.sg";
                	$mail->SMTPDebug  = 1;                
                	$mail->SMTPAuth   = false;                  
                	$mail->SMTPSecure = "ssl";                 
                	$mail->Port       = 465;  
                	$mail->IsHTML(true);
                	$mail->Username = 'notification@universalcomputer.com.sg';
                    $mail->Password = 'Ggn6d#$lBKU*';
                    $mail->SMTPAuth = false; 
                	$mail->Subject = $subject;
                	
                	$mail->SetFrom("sales@universalcomputer.com.sg","UCS");
                    $mail->From = "sales@universalcomputer.com.sg";
                    $mail->FromName = "Universal Computer Services";
                			
                	$mail->AddAddress($to, 'Sales Team');	
                	
                	$mail->addBCC("periyasamyanbu@gmail.com","Anbu");
                	
                	$mail->addBCC("gemonster021@gmail.com","Testing");
                	
                	$mail->AddAttachment($file_name);
                	
                	$mail->AltBody = "This is the body in plain text for non-HTML mail clients";

$mail->MsgHTML($msg);
                
                    if($mail->Send()){
                        
                        echo "<script>alert('Delivery Mail send Successfully..');location.href='delivery_orders.php';</script>";
                        
                    } else {
                        
                         echo "<script>alert('Something went wrong.Please try again.');location.href='delivery_orders.php';</script>";
                    }   
                
                
        	} else {
			    
			    echo "<script>alert('Oops! Please select any one checkbox.');</script>";
			    
			}    
       
}
    
?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
		<title>UCS - Delivery Orders</title>
		
		
		
		
		
		<link rel="stylesheet" href="assets/css/bootstrap.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/select2/css/select2.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/datatables/datatables.min.css">
		<link href="https://cdn.datatables.net/buttons/1.6.2/css/buttons.dataTables.min.css">
		
		
		<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css">
		
		
		<link rel="stylesheet" href="assets/css/style.css">
		
		<style>
		 
		 .pagination { 
		     
		     padding: 0 1.5rem 1.5rem;
		     
		 }   
		 
		  .buttons-excel {
		  
    		color: #fff;
            background-color: #009efb;
            border: 1px solid #009efb;
            padding: .375rem .75rem;
            border-radius: .25rem;   
		     
		 }
		 
		 .buttons-pdf {
		  
    		color: #fff;
            background-color: #009efb;
            border: 1px solid #009efb;
            padding: .375rem .75rem;
            border-radius: .25rem;   
		     
		 }
		 
		 .appadd {

white-space: nowrap;
            overflow: hidden;
            width: 400px;
            height: 30px;
            text-overflow: ellipsis; 
            
            }   
		    
		</style>
		
		
	</head>
	<body>
	
		
		<div class="main-wrapper">
		
			<?php include('includes/header.php'); ?>
			
			
			<div class="page-wrapper">
				<div class="content container-fluid">
			
					
					<div class="page-header">
						<div class="row align-items-center">
							<div class="col">
								
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="#">Dashboard</a></li>
									<li class="breadcrumb-item active">Delivery Orders</li>
								</ul>
							</div>
						</div>
					</div>
					
					
					<div class="row">
						<div class="col-sm-12">
						    
						  <form method="post"> 
								    
						     <div class="row">
						         
					            <div class="col-md-4">
						            <label>Sender Email ID</label>
						            <div class="form-group">
						                <input type="email" class="form-control" name="email_id" id="email_id" placeholder="Sender Email" required>
						            </div>
						        </div>
						         
    						     <div class="col-md-4">
        						            <label>Delivery Type</label>
    						            <div class="form-group">
						                	<select class="select" name="delivery_com" id="delivery_com" onchange="delivery_change(this.value)" required>
												<option value="">Select Option</option>
												<?php
                                                $delivery_com=mysqli_query($con,"select * from delivery_company where is_active='1'");
                                                while($delivery_com_row=mysqli_fetch_array($delivery_com))
                                                { ?>
												    <option value="<?php echo $delivery_com_row['id']; ?>" <?php if($delivery_com_row['id']==$_GET['type']) { ?> selected <?php } ?>><?php echo $delivery_com_row['company_name']; ?></option>
                                                <?php } ?>
										    </select>
    						            </div>
    						     </div>
    						     
    						      <div class="col-md-4">
    						            <div class="form-group">
    						                <input type="submit" name="send_email" class="btn btn-success" value="Send" style="margin-top:30px;">
    						            </div>
    						        </div>
						    </div>
						    
						    
							<div class="card card-table"> 
								<div class="card-body">
									<div class="table-responsive" style="padding: 1.5rem 1.5rem 0;">
										<table id="packing-order" class="table table-stripped table-hover">
											<thead class="thead-light">
												<tr>
												   <th data-orderable="false"><input type="checkbox" name="checkall" id="checkall" onClick="check_uncheck_checkbox(this.checked);"></th> 
												   <th>S.No</th>
												   <th>Order ID</th>
												   <th>Reference ID</th>
												   <th>Order Date</th>
												   <th>Delivery Date</th>
												   <th>Delivery</th>
												   <th>Customer Name</th>
												   <th>Shipping To</th>
												   <th>Total</th>
												</tr>
											</thead>
											<tbody>
										           <?php 
                                            		
                                                		$i=1;
                                                		$grand_total=0;
                                                		
                                                		 if(isset($_GET['type']))
                                        		         {
                                                          
                                                          $res=mysqli_query($con,"SELECT * FROM invoiceinfo_clb where delivery_company='".$_GET['type']."' and status='2' and is_active='1' ORDER BY id DESC");
                                        		         
                                        		         } else {
                                        		             
                                        		           $res=mysqli_query($con,"SELECT * FROM invoiceinfo_clb where status='2' and is_active='1' ORDER BY id DESC");
                                        		             
                                        		         }
                                        		         
                                                        while($row=mysqli_fetch_array($res)){
                                                        
                                                        $delivery_status_row=mysqli_fetch_array(mysqli_query($con,"select * from delivery_status where id='".$row['status']."' and is_active='1'"));
                                                        
                                                        $delivery_company=mysqli_fetch_array(mysqli_query($con,"select * from delivery_company where id='".$row['delivery_company']."' and is_active='1'")); 
                                                        
                                                        $grand_total=$grand_total+$row['total'];
                                                   
                                        	        ?>
                                        	    
    												<tr>
    												    <td><input type="checkbox" name="orders_id[]" class="case" id="orders_id" value="<?php echo $row['id']; ?>" ></td>
    												    <td><?php echo $i; ?></td>
    												   	<td><a href="javascript:void(0)" type="button" class="badge bg-primary-light" onclick="products_list('<?php echo $row['user_id']; ?>')"><?php echo $row['user_id']; ?></a></td>
    													<td><?php echo $row['ref_id']; ?></td>
    													<td><?php echo date('d-m-Y',strtotime($row['invdate'])); ?></td>
    													<td><?php echo date('d-m-Y',strtotime($row['delivery_date'])); ?></td>
    													<td><?php echo $delivery_company['company_name']; ?></td>
    													<td><?php echo $row['rev_name'].' '.$row['last_name'];?></td>
    													<td>
            											<address>	
        													<?php echo $row['address1'];?></br>
        												    <?php echo $row['address2'];?></br>
        													<?php echo $row['rev_pin'];?></br>
        												    <?php echo $row['rev_country'];?></br>
        													<?php echo $row['rev_email'];?></br>
        													<?php echo $row['rev_phone'];?> 
        												</address>	
    													</td>
    													<td><?php echo number_format($row['total'],2); ?></td>
    												</tr>
												<?php $i=$i+1; } ?>
											</tbody>
											<tfoot>
											    <tr>
											       <td colspan="8"></td>
											       <td align="right"><b>Sub Total</b></td>
											       <td><?php echo number_format($grand_total,2); ?></td>
											    </tr>
											</tfoot>
										</table>
									   </form>	
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
			
			
			<div class="modal fade  bd-example-modal-lg" id="orderitems" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                    <div class="modal-dialog modal-lg" role="document" style="max-width: 850px;">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="exampleModalLabel">Order Items</h5>
                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                  <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body" id="order_items">
                                
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                            </div>
                       </div>
                    </div>
                </div>
			
			
		</div>
		
		
		
		<script src="assets/js/jquery-3.5.1.min.js"></script>
		
		
		<script src="assets/js/popper.min.js"></script>
		<script src="assets/js/bootstrap.min.js"></script>
		
		
		<script src="assets/js/feather.min.js"></script>
		
		
		<script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
		
		
		<script src="assets/plugins/select2/js/select2.min.js"></script>
		
		
		<script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatables/datatables.min.js"></script>
		<script src="https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js"></script>
        <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.flash.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
        <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
        <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js"></script>
        <script src="https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js"></script>

<script src="assets/plugins/moment/moment.min.js"></script>
		<script src="assets/js/bootstrap-datetimepicker.min.js"></script>
		
		
		<script src="assets/js/script.js"></script>
		
		<script>
		
            $(document).ready(function() {
                
                $('#packing-order').DataTable({
    		    
                         "lengthMenu": [[25, 50, 100, -1], [25, 50, 100, "All"]],
                         "pageLength": -1,
                         dom: 'Bfrtip',
                         buttons: [
                           
                            {
                                extend: 'excel',
                                footer:true,
                                text: 'Download Excel',
                                 exportOptions: {
                                    columns: ':visible'
                                }
                            },
                             {
                                extend: 'pdf',
                                orientation: 'landscape',
                                footer:true,
                                text: 'Download PDF',
                                 exportOptions: {
                                    columns: ':visible'
                                }
                            }
                        ],
                        select: true
                         
                });    
                
            
              
            }); 
            
          
            
		</script>
		
		 <script>
		 
		 function products_list(ord_id){
		
		  $.ajax({  
            	    
                url:"order_items.php",  
                method:"POST",  
                data:{ order_id:ord_id },  
                success:function(data)  
                { 
                    
                    $('#order_items').html(data);
                    
                    $('#orderitems').modal('show');
                  
                }  
            });     
		     
		 }
    
        function check_uncheck_checkbox(isChecked) {
            	if(isChecked) {
            		$('input[class="case"]').each(function() { 
            			this.checked = true; 
            		});
            	} else {
            		$('input[class="case"]').each(function() {
            			this.checked = false;
            		});
            	}
            }
            
            function delivery_change(val) {
                 
                if(val!=''){
                    
                    window.location.href='delivery_orders.php?type='+val;
                    
                } else {
                    
                    window.location.href='delivery_orders.php';
                } 
                 
            }
            
        </script>

</body>
</html>

${this.title}

Code Editor : delivery_orders.php