1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : view-purchase-order-copy.php
back
<?php      
   ob_start();
   session_start();
   include 'config.php'; 
   $login = $_SESSION['login_email'];
   
   if($login == ''){ 
      echo   '<script>location.replace("index.php")</script>';
   }
   $id = $_GET['id'];
   
   if(isset($_SESSION["source_id"])){
      $source_id = $_SESSION['source_id'];
   }
   
   
   
   $companyd = mysqli_query($conn,"SELECT * FROM `company_details`");
   $companyrow = mysqli_fetch_assoc($companyd);
   
   $contact_person = $companyrow['contact_person'];
   $company_name = $companyrow['company_name'];
   $company_logo = $companyrow['company_logo'];
   $GSTIN = $companyrow['GSTIN'];
   $phone = $companyrow['phone'];
   $eb_email = $companyrow['email'];
   $address = $companyrow['address'];
   $city = $companyrow['city'];
   $state = $companyrow['state'];
   $country = $companyrow['country'];
   $account_name = $companyrow['account_name'];
   $account_no = $companyrow['account_no'];
   $bank_name = $companyrow['bank_name'];
   $ifsc = $companyrow['ifsc'];
   $shift = $companyrow['shift'];
   $branch = $companyrow['branch'];
   $company_color = $companyrow['company_color'];
   $currency = $companyrow['currency'];
   $invoice_prifix = $companyrow['invoice_prifix'];
   $default_invoice = $companyrow['default_invoice'];
   $signature = $companyrow['signature'];
   $invoice_note = $companyrow['invoice_note']; 
   
   ?>
<!DOCTYPE html>
<html>

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Invoice Management | Invoice</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
    <meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
    <meta content="Coderthemes" name="author" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <!-- Font Awsome -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <!-- App favicon -->
    <link rel="shortcut icon" href="assets/images/favicon.png">
    <!-- Pie Chart Css -->
    <!--<link href="assets/pie charts/style.css" rel="stylesheet" type="text/css" />-->
    <!-- App css -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
    <link href="assets/css/icons.css" rel="stylesheet" type="text/css" />
    <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css" />
    <link href="assets/css/style.css" rel="stylesheet" type="text/css" />
    <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/css/select2.min.css'>
    <script src="assets/js/modernizr.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
    <script type="text/javascript" src="script.js"></script>
    <link href="plugins/sweet-alert2/sweetalert2.min.css" rel="stylesheet" type="text/css">
    <link href="plugins/jquery-toastr/jquery.toast.min.css" rel="stylesheet" />
    <style>
        .table td,
        .table th {
            padding: .75rem;
            vertical-align: top;
            border-top: 0px solid #dee2e6;
            border-bottom: 1px solid #dee2e6;
        }

    </style>
</head>

<body>
    <!-- Begin page -->
    <div id="wrapper">
        <!-- Top Bar Start -->
        <?php include 'top-header.php'; ?>
        <!-- Top Bar End -->
        <!-- ========== Left Sidebar Start ========== -->
        <?php include 'left-sidebar.php'; ?>
        <!-- Left Sidebar End -->
        <!-- ============================================================== -->
        <!-- Start right Content here -->
        <!-- ============================================================== -->
        <div class="content-page">
            <!-- Start content -->
            <div class="content">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-12">
                            <div class="page-title-box">
                                <h4 class="page-title float-left">View Purchase order</h4>
                                <ol class="breadcrumb float-right">
                                    <li class="breadcrumb-item"><a href="#">Sales</a></li>
                                    <li class="breadcrumb-item ">All Purchase order</li>
                                    <li class="breadcrumb-item active">View Purchase order</li>
                                </ol>
                                <div class="clearfix"></div>
                            </div>
                        </div>
                    </div>
                    <!-- end row -->
                    <?php 
                     $companyId ="";
                     $sql = " SELECT * FROM purchase_order where id = '$id'"; 
                     $result = mysqli_query($conn,$sql);
                     while( $row = mysqli_fetch_array($result)){ 
                         
                         $manufacturer_id = $row['manufacturer'];
                         $po_id = $row['po_id'];
                         $order_date = $row['order_date'];
                         $proforma_id = $row['proforma_id'];
                         $receive_info = $row['receive_info'];
                         $delivery_address = $row['delivery_address'];
                         $delivery_type = $row['delivery_type'];
                         $delivery_terms = $row['delivery_terms']; 
                         $type = $row['type'];
                         $payment_terms = $row['payment_terms'];
                         $comment = $row['comment'];
                         $subtotal_price = $row['subtotal_price'];
                         $bank_charges = $row['bank_charges'];
                         $amount_paind = $row['amount_paind'];
                         $date_creation = $row['date_creation'];
                         
                     ?>
                    <div class="card-box">
                        <div class="col-md-12">
                            <div class="row">
                                <div class="col-md-12 mt-3 mb-3">
                                    <h3 class="text-center" style="color:<?php echo $row['company_color'] ?>;"><b>Purchase order</b></h3>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-md-8">
                                    <h3 class="mb-0"><?php echo $company_name ?></h3>
                                    <p class="mb-0"><?php echo $address.','.$city.','.$state.','.$country; ?></p>
                                    <p class="mb-0">Contact Person : <?php echo $contact_person ?></p>
                                    <p class="mb-0">Contact Number : <?php echo $phone ?></p>
                                    <p class="mb-0">Email : <?php echo $eb_email ?></p>
                                </div>
                                <div class="col-md-4 text-right">
                                    <p class="mb-0"><b>Purchase Order : <?php echo $po_id ?></b></p>
                                    <p class="mb-0">Proforma No. : <?php echo $proforma_id ?>
                                    <p>
                                    <p class="mb-0">Order Date : <?php echo $order_date ?></p>
                                </div>
                            </div>
                            <hr>
                            <?php 
                           $contactsql = mysqli_query($conn,"SELECT * FROM `manufacturer` where id='$manufacturer_id'");
                           $contactrow = mysqli_fetch_assoc($contactsql);
                           
                           $customer_type = $contactrow['customer_type'];
                           $manufacturer_display_name = $contactrow['manufacturer_display_name'];
                           $contact_person_name = $contactrow['contact_person_name']; 
                           $manu_phone = $contactrow['phone']; 
                           $manu_email = $contactrow['email']; 
                           $currency = $contactrow['currency'];
                           
                           
                           $address_get = $contactrow['address'] .', '. $contactrow['city'] .', '. $contactrow['state'] .', '. $contactrow['country'];
                            
                           ?>
                            <div class="row">
                                <div class="col-md-8">
                                    <p><b>Manufacturer :</b></p>
                                    <p class="mb-0"> <b><?php echo $manufacturer_display_name ?></b> </p>
                                    <p class="mb-0"> <?php echo $address_get ?></p>
                                    <p class="mb-0">Contact Person: <?php echo $contact_person_name ?></p>
                                    <p class="mb-0">Contact No.: <?php echo $manu_phone ?></p>
                                    <p class="mb-0">Contact Email.: <?php echo $manu_email ?></p>
                                </div>
                                <div class="col-md-4 text-right">
                                    <p class="mb-0">Delivery Terms :<?php echo $delivery_terms ?></p>
                                    <p class="mb-0">Delivery Type : <?php echo $delivery_type ?></p>
                                    <p class="mb-0">Payment Terms : <?php echo $payment_terms ?></p>
                                </div>
                            </div>
                            <hr>
                            <br>
                        </div>
                        <div class="row">
                            <table class="table table-responsive">
                                <thead>
                                    <tr style="width:100%">
                                        <th>Item Code</th>
                                        <th>Image</th>
                                        <th>Item Name</th>
                                        <th>Size</th>
                                        <th>Color</th>
                                        <th>Qty.</th>
                                        <th>Unit</th>
                                        <th>Price (<?php echo $currency ?>)</th>
                                        <th>Total (<?php echo $currency ?>)</th>
                                    </tr>
                                </thead>
                                <tbody id="itemsadd">
                                    <?php 
                                 $getitemsql = mysqli_query($conn,"SELECT * FROM po_item a left join inventory b on a.item_id = b.id where a.purchase_order_id = '$id'");
                                 while($item_row = mysqli_fetch_assoc($getitemsql)){
                                 $item_image =  $item_row['item_image'];
                                
                                 ?>
                                    <tr style="width:100%">
                                        <td style="width:10%"><?php echo $item_row['item_code'] ?></td>
                                        <td style="width:5%"><img src="inventory/<?php echo $item_image ?>" width="50"></td>
                                        <td style="width:15%"><?php echo $item_row['name'] ?> / <?php echo $item_row['item_name_ch'] ?></td>
                                        <td style="width:10%"><?php echo $item_row['size'] ?></td>
                                        <td style="width:10%"><?php echo $item_row['color'] ?> / <?php echo $item_row['item_color_ch'] ?></td>
                                        <td style="width:5%"><?php echo $item_row['qty'] ?></td>
                                        <td style="width:5%"><?php echo $item_row['unit_of_measure'] ?></td>
                                        <td style="width:10%"><?php echo $item_row['price'] ?></td>
                                        <td style="width:10%"><?php echo $item_row['row_total'] ?></td>
                                    </tr>
                                    <?php  }?>
                                </tbody>
                            </table>
                        </div>
                        <div class="row">
                            <div class="col-md-8">
                                <div class="form-group">
                                    <p><b>Comment : </b> <?php echo $comment ?></p>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="form-group row">
                                    <p class="col-9 mb-0 ">Sub Total </p>
                                    <div class="col-3">
                                        <p class="mb-0 "><?php echo $currency ?> <?php echo $subtotal_price?> </p>
                                    </div>
                                </div>
                                <div class="form-group row">
                                    <p class="col-9  mb-0 "> Amount Paid </p>
                                    <div class="col-3">
                                        <p class="mb-0 "><?php echo $currency ?> <?php echo $amount_paind?> </p>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-8">
                            </div>
                            <?php 
                           $sql_proforma = "SELECT SUM(qty) AS item_qty FROM proforma_item WHERE proforma_id = '$proforma_id'";
                           $sql_proforma_item = mysqli_query($conn,$sql_proforma);
                           $sql_proforma_r = mysqli_fetch_assoc($sql_proforma_item);
                           
                           $total_proforma_qty = $sql_proforma_r['item_qty'];
                           
                           
                           ?>
                            <?php 
                           $sql_c = "SELECT SUM(qty) AS item_qty FROM invoice_item WHERE proforma_id = '$proforma_id'";
                           $sql_c_i = mysqli_query($conn,$sql_c);
                           $sql_c_r = mysqli_fetch_assoc($sql_c_i);
                           
                           $total_invoice_qty = $sql_c_r['item_qty'];
                           
                           
                           ?>
                            <div class="col-md-12">
                                <a href="edit-purchase.php?id=<?php echo $id ?>" class="btn w-md waves-effect waves-light btn-info" data-toggle="tooltip" data-placement="top" title="" data-original-title="Edit"><i class="fa fa-pencil"></i> Edit</a>
                                <button type="button" class="btn w-md waves-effect waves-light btn-danger" value="<?php echo $id ?>" data-toggle="tooltip" data-placement="top" title="" data-original-title="Delete" id="btnDelete" onclick="deletePurchase(this)"><i class="fa fa-trash-o"></i> Delete</button>

                                <a href="print-purchase.php?id=<?php echo $id ?>" target="blank" class="btn w-md waves-effect waves-light btn-success" data-toggle="tooltip" data-placement="top" title="" data-original-title="Print"><i class="fa fa-print"></i> Print</a>
                                <button type="button" class="btn w-md waves-effect waves-light btn-warning" data-po-id="<?php echo $po_id;?>" data-po-row-id="<?php echo $id ?>" data-toggle="tooltip" data-placement="top" title="" data-original-title="Upload Supporting Documents" id="uploadSupportingDocuments"><i class="fa fa-upload"></i> Upload Supporting Documents</button>
                            </div>
                        </div>
                    </div>
                    <?php } ?>
                </div>
            </div>
            <!-- container -->
        </div>
        <!-- content -->
        <?php include 'copyrignt.php' ?>
    </div>
    <!-- ============================================================== -->
    <!-- End Right content here -->
    <!-- ============================================================== -->

    <!-- END wrapper -->
    <!-- /.modal -->
    
    <div class="modal fade" id="myModalPoFilesDisplay" style="z-index: +99999;">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <!-- Modal Header -->
                <div class="modal-header">
                    <h4 class="modal-title">Upload Supporting Documents for PO <b><span class="text-success po_idz"></span></b> </h4>
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                <!-- Modal body -->
                <div class="modal-body">
                    <iframe id="poFilesDisplay" title="webviewer" frameborder="0" style="width:100%;min-height:450px;"></iframe>
                    <!--<img src="" style="width:100%" id="poFileDisplay">-->
                </div>
                <!-- Modal footer -->
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>
    <div class="modal fade" id="myModalPoFiles">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <!-- Modal Header -->
                <div class="modal-header">
                    <h4 class="modal-title">Upload Supporting Documents for PO <b><span id="po_ids" class="text-success"></span></b> </h4>
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                </div>
                <!-- Modal body -->
                <div class="modal-body">
                    <form id="po_fileupload_form" method="post" role="form" enctype="multipart/form-data">
                        <div class="card-box">
                            <div class="row">
                                <div class="col-md-12">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1">Choose Files</label>
                                        <input type="file" class="form-control" name="files[]" multiple>
                                        <input type="hidden" name="po_row_id" id="po_row_id">
                                        <button type="submit" id="po_fileupload_btn" class="btn btn-purple waves-effect waves-light w-100">Upload File</button>
                                    </div>
                                </div>
                                <div class="col-md-12">
                                    <div class="showTitle"></div>
                                    <div id="showPoUploadedFiles" style="text-align: center;"></div>
                                </div>
                            </div>
                        </div>

                    </form>
                </div>
                <!-- Modal footer -->
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>
    
    <script src="assets/js/jquery.min.js"></script>
    <script src="assets/js/popper.min.js"></script><!-- Popper for Bootstrap -->
    <script src="assets/js/bootstrap.min.js"></script>
    <script src="assets/js/metisMenu.min.js"></script>
    <!--<script src="assets/js/waves.js"></script>-->
    <script src="assets/js/jquery.slimscroll.js"></script>
    <!-- Dashboard init -->
    <!-- <script src="assets/pages/jquery.dashboard.js"></script> -->
    <!-- App js -->
    <script src="assets/js/jquery.core.js"></script>
    <script src="assets/js/jquery.app.js"></script>
    <!-- Chart Js -->
    <!-- <script src="assets/pie charts/script.js"></script>-->
    <!-- <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js'></script> -->
    <!-- <script src='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.5/js/select2.min.js'></script> -->
    <script src="plugins/sweet-alert2/sweetalert2.min.js"></script>
    <script src="plugins/jquery-toastr/jquery.toast.min.js" type="text/javascript"></script>

    <script src="assets/js/jquery.validate.min.js"></script>
    <script src="assets/js/additional-methods.min.js"></script>
    <script>
        $('#uploadSupportingDocuments').on('click', function(e) {
            e.preventDefault();
            var po_ids = $(this).attr('data-po-id');
            var data_po_row_id = $(this).attr('data-po-row-id');

            // alert(data_po_row_id);
            if (data_po_row_id != "") {
                
                $.ajax({
                    url: 'ajax/show-po-uploaded-files.php',
                    type: "post",
                    data: {
                        data_po_row_id: data_po_row_id
                    },
                    success: function (response) {
                        //alert(response);
                        if ($.trim(response) == null || $.trim(response) == undefined || $.trim(response) == ''){ 
                            
                            $('#po_ids').html("( " + po_ids + " )");
                            $('#po_row_id').val(data_po_row_id);
                            $('#myModalPoFiles').modal('show');
                            $('#myModalPoFiles').modal({
                                backdrop: 'static',
                                keyboard: false
                            });
                        }else{
                        
                            $('#showPoUploadedFiles').html(response);
                            $('.showTitle').html("<hr><h5 class='text-center'>Show All Uploaded file. Click to show File</h5><hr>");
                            $('#po_ids').html("( " + po_ids + " )");
                            $('#po_row_id').val(data_po_row_id);
                            $('#myModalPoFiles').modal('show');
                            $('#myModalPoFiles').modal({
                                backdrop: 'static',
                                keyboard: false
                            });
                            
                        }
                    }
                });
                } else {
                alert("Somthing wrong in uploading file");
            }
        });
        $(function() {
            // param = size (en bytes) 
            $.validator.addMethod('filesize', function(value, element, param) {
                return this.optional(element) || (element.files[0].size <= param) 
            });
            $('#po_fileupload_form').validate({
                rules: {
                    "files[]": {
                        required: true,
                        extension: "jpg|jpeg|png|PNG|JPG|JPEG|pdf|PDF",
                        filesize: 1048576,  
                    }
                },
                messages: { "files[]": "File must be JPG, JPEG or PDF, less than 1MB" },
                submitHandler: function(form) {
                    var formData = new FormData(form);
                    $.ajax({
                        data: formData,
                        type: 'POST',
                        url: 'ajax/upload-po-supporting-files.php',
                        contentType: false,
                        cache: false,
                        processData: false,
                        enctype: 'multipart/form-data',
                        //                type: 'post',
                        //                url: base_url + 'ajax/user-registration.php',
                        //                data: $(form).serialize(),
                        beforeSend: function() {
                            $("#po_fileupload_btn").prop('disabled', true); // disable button
                            $("#po_fileupload_btn").text('Please Wait...'); // disable button
                        },
                        success: function(response) {
                            //console.log(response);
                            //alert(response);
                            var data = JSON.parse(response);
                            if (data.status == "true") {
                                alert(data.msg);
                                window.location.reload();
                                //                            window.location.href = base_url_sign_in;
                            } else {
                                //  $(dddd).css("top", "-15px !important");
                                alert(data.msg);
                            }
                        },
                        complete: function() {
                            $("#po_fileupload_btn").prop('disabled', false); // disable button
                            $("#po_fileupload_btn").text('Upload File'); // disable button
                        }
                    });
                    return false;
                }
            });
        });

        function deletePurchase(button) {
            var itemId = $(button).val();
            swal({
                title: 'Are you sure?',
                text: "Do you really want to restore this Item??",
                type: 'warning',
                showCancelButton: true,
                confirmButtonColor: '#4fa7f3',
                cancelButtonColor: '#d57171',
                confirmButtonText: "Yes, I'm Sure!"
            }).then(function() {
                $.ajax({
                    url: "PHP/response.php",
                    data: "action=deletePurchase&purchaseId=" + itemId,
                    method: "POST",
                    async: false,
                    success: function(response) {
                        if (response == "DELETED") {
                            localStorage.setItem("deletePurchase", "true");
                            location.replace('purchase-order.php');
                        } else {
                            errorMessage("Item could not be deleted.");
                        }
                    },
                    error: function(error) {
                        errorMessage("Item could not be deleted.");
                    }
                });
            });
        }
        
        $("#myModalPoFiles").on("click",".showSupportingDocFile",function(e){
                e.preventDefault();
                var data_file_name = $(this).attr("data-file-name");
                var data_po_id = $(this).attr("data-po-id");
                //alert(data_file_name);
                if(data_file_name){
                    // alert(data_po_id);
                    $('.po_idz').html("( " + data_po_id + " )");
                    // $('#poFileDisplay').attr('src', data_file_name);
                    // $('#poFileDisplay').attr('src', "https://docs.google.com/viewer?url=https://urbane.createerp.com/"+data_file_name+"&embedded=true");
                    $('#poFilesDisplay').attr('src', "https://urbane.createerp.com/"+data_file_name);
                    $('#myModalPoFilesDisplay').modal('show');
                    $('#myModalPoFilesDisplay').modal({
                        backdrop: 'static',
                        keyboard: false
                    });
                   
                }
            });

    </script>
</body>

</html>