FM / admin

/home/u775757334/domains/civicwelllife.com/public_html/management/admin/

/home/u775757334/domains/civicwelllife.com/public_html/management/admin

Name	Size	Mode	Actions
api/	-	0755	rm
dataQuery/	-	0755	rm
dist/	-	0755	rm
fonts/	-	0755	rm
function/	-	0755	rm
icons/	-	0755	rm
images/	-	0755	rm
include/	-	0755	rm
js/	-	0755	rm
loginQuery/	-	0755	rm
scripts/	-	0755	rm
styles/	-	0755	rm
vendor/	-	0755	rm
add-product.php	18141	0644	edit dl rm
apply-fresh.php	26904	0644	edit dl rm
banner-list.php	15940	0644	edit dl rm
banner.php	15867	0644	edit dl rm
blog-list.php	15943	0644	edit dl rm
blog.php	17027	0644	edit dl rm
brand-list.php	15920	0644	edit dl rm
brand-logo-list.php	15299	0644	edit dl rm
brand-logo.php	16979	0644	edit dl rm
brand.php	16209	0644	edit dl rm
brocher-list.php	15713	0644	edit dl rm
career-enquiry-list.php	16537	0644	edit dl rm
categories-list.php	17202	0644	edit dl rm
categories.php	17416	0644	edit dl rm
change-password.php	11770	0644	edit dl rm
city-list.php	16215	0644	edit dl rm
city.php	16082	0644	edit dl rm
company-list.php	15504	0644	edit dl rm
company-office-list.php	15811	0644	edit dl rm
company-office.php	16131	0644	edit dl rm
company-profile.php	19643	0644	edit dl rm
company-stock.php	16999	0644	edit dl rm
company.php	21073	0644	edit dl rm
course-list.php	16177	0644	edit dl rm
course.php	19406	0644	edit dl rm
customer-list.php	18027	0644	edit dl rm
customer-order-list.php	20938	0644	edit dl rm
customer.php	18812	0644	edit dl rm
day.php	13822	0644	edit dl rm
dbc.php	6617	0644	edit dl rm
delivered-parcel-list.php	26169	0644	edit dl rm
distributor-list.php	17837	0644	edit dl rm
distributor-order-details.php	17018	0644	edit dl rm
distributor-order-list.php	22259	0644	edit dl rm
distributor.php	19110	0644	edit dl rm
enquiry-list.php	16660	0644	edit dl rm
export-data.php	16892	0644	edit dl rm
favicon.ico	1150	0644	edit dl rm
forgot-password.php	4019	0644	edit dl rm
gallery-list.php	15893	0644	edit dl rm
gallery.php	16793	0644	edit dl rm
genrate-customer-order.php	25330	0644	edit dl rm
genrate-lead-list.php	19566	0644	edit dl rm
genrate-lead.php	24067	0644	edit dl rm
genrate-order.php	22370	0644	edit dl rm
home.php	16384	0644	edit dl rm
import-deliver-report.php	18563	0644	edit dl rm
import-manager-user.php	20714	0644	edit dl rm
import-mis-report.php	21161	0644	edit dl rm
index.php	4739	0644	edit dl rm
inward-report-list.php	21518	0644	edit dl rm
lead-category-list.php	15237	0644	edit dl rm
lead-category.php	18615	0644	edit dl rm
lead-list.php	15963	0644	edit dl rm
lead-status-list.php	15374	0644	edit dl rm
lead-status.php	18394	0644	edit dl rm
lead.php	23475	0644	edit dl rm
manager-list.php	16921	0644	edit dl rm
manager-user-list.php	27810	0644	edit dl rm
media-list.php	17533	0644	edit dl rm
media.php	14839	0644	edit dl rm
menu-category-list.php	15739	0644	edit dl rm
menu-category.php	16257	0644	edit dl rm
menu-list.php	15953	0644	edit dl rm
menu.php	16723	0644	edit dl rm
message.php	3033	0644	edit dl rm
mis-report-list.php	17045	0644	edit dl rm
mis-sample.csv	483	0644	edit dl rm
my-order-list.php	21040	0644	edit dl rm
my-product-stock.php	17959	0644	edit dl rm
my-retailer-order-list.php	20688	0644	edit dl rm
news-list.php	17941	0644	edit dl rm
news.php	17396	0644	edit dl rm
online-product-list.php	19468	0644	edit dl rm
online-product.php	17214	0644	edit dl rm
order-details.php	20698	0644	edit dl rm
order-list.php	23106	0644	edit dl rm
order-list2.php	22470	0644	edit dl rm
parcel-details-list.php	27146	0644	edit dl rm
parcel-request-list.php	27666	0644	edit dl rm
partners-list.php	15975	0644	edit dl rm
partners.php	17715	0644	edit dl rm
pdf-category-list.php	17954	0644	edit dl rm
pdf-category.php	16234	0644	edit dl rm
pdf-list.php	18100	0644	edit dl rm
pdf.php	18717	0644	edit dl rm
poster-list.php	15925	0644	edit dl rm
poster.php	16129	0644	edit dl rm
print-bill.php	25616	0644	edit dl rm
print-customer-bill.php	25378	0644	edit dl rm
product-list.php	18289	0644	edit dl rm
product.php	22375	0644	edit dl rm
project-category.php	19504	0644	edit dl rm
project-image-list.php	17805	0644	edit dl rm
project-image.php	17612	0644	edit dl rm
project-list.php	18233	0644	edit dl rm
project-product-list.php	17820	0644	edit dl rm
project-product.php	18483	0644	edit dl rm
project.php	19003	0644	edit dl rm
receive-product-list.php	17978	0644	edit dl rm
receive-product.php	19682	0644	edit dl rm
retail-print-bill.php	26362	0644	edit dl rm
retailer-genrate-order.php	22367	0644	edit dl rm
retailer-list.php	17825	0644	edit dl rm
retailer-order-details.php	17213	0644	edit dl rm
retailer-order-list.php	21049	0644	edit dl rm
retailer.php	19086	0644	edit dl rm
rm-order-list.php	22360	0644	edit dl rm
rm-user-list.php	17766	0644	edit dl rm
rm-user.php	19056	0644	edit dl rm
service-list.php	17589	0644	edit dl rm
service.php	15818	0644	edit dl rm
setting.php	19923	0644	edit dl rm
show-student-list.php	20558	0644	edit dl rm
size-list.php	16053	0644	edit dl rm
size.php	15517	0644	edit dl rm
source-list.php	15217	0644	edit dl rm
source.php	18382	0644	edit dl rm
staff-list.php	15906	0644	edit dl rm
staff.php	17700	0644	edit dl rm
state-list.php	15944	0644	edit dl rm
state.php	15242	0644	edit dl rm
stock-transaction.php	17998	0644	edit dl rm
stock.php	16317	0644	edit dl rm
team-list.php	16019	0644	edit dl rm
team.php	16318	0644	edit dl rm
testimonial-list.php	15969	0644	edit dl rm
testimonial.php	16399	0644	edit dl rm
university-list.php	17911	0644	edit dl rm
university.php	18601	0644	edit dl rm
upload-brocher.php	18118	0644	edit dl rm
user-list.php	16591	0644	edit dl rm
user.php	21410	0644	edit dl rm
view-lead.php	23641	0644	edit dl rm
view-product.php	18105	0644	edit dl rm
website-setting.php	12534	0644	edit dl rm

Edit: /home/u775757334/domains/civicwelllife.com/public_html/management/admin/order-details.php (20698B)

<?php include'loginQuery/session_start.php';
include'dbc.php';?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
                <meta content="IE=edge" http-equiv="X-UA-Compatible">
                    
                    <title>
                        Order
                    </title>
                    
                    
                    
                    <?php include'include/header-file.php';?>
                                        
                    <link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" />
                    <link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" />
                    <link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" />
                    <link rel="stylesheet" href="vendor/datatables.net-bs/css/dataTables.bootstrap.min.css" />

</meta>
            </meta>
        </meta>
    </head>
    
    <body class="hide-sidebar">
        
        
        <?php include'include/header.php';?>

<?php include'include/side-menu.php';?>
        
        
        
        <div id="wrapper">

<div class="content ">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="hpanel">
                            
                           
                        <div class="panel-body">
      
<?php
$orderID= $_GET['orderid'];

$sql =mysqli_query($conn,"select * from $tblOrder  where order_id='$orderID'") or die(mysqli_error());
    $row = mysqli_fetch_assoc($sql);
    extract($row);
    $sqlMA =mysqli_query($conn,"select * from    tbl_product") or die(mysqli_error());
    while($rowMA=mysqli_fetch_assoc($sqlMA))
    {
        $key                    =   $rowMA['id'];
        $productNameAry[$key]   =   $rowMA['name'];
    }
?>
<?php
    /*$sqlMA =mysqli_query($conn,"select * from    tbl_courier_services") or die(mysqli_error());
    while($rowMA=mysqli_fetch_assoc($sqlMA))
    {
        $key                    =   $rowMA['id'];
        $courierNameAry[$key]   =   $rowMA['name'];
        
    }*/
?>
<style>

@media print {
            #printtable {
            width:100%;
            visibility: visible;
            }
            body{
            visibility:hidden;
            } 
            #header{
            display:none;
            }
            #menu{
            display:none;
            }
        }
</style>
<div class="clearfix"></div>    
                           
                <?php 
                    if(isset($_GET['mode'])){
                        $sqls =mysqli_query($conn,"select name from $tblAdmin where id='$distributor_id'") or die(mysqli_error());
                        $rows = mysqli_fetch_assoc($sqls);
                        ?>
                        <table id="printtable"  class="table table-striped table-bordered table-hover" >
                            <thead>
                                <tr style=" border:0;">
                                    <th colspan="8" style=" border:0;text-align:center;">
                                        <h3><strong>Purchase Order</strong></h3>
                                    </th>
                                </tr>   
                                <tr>
                                    <th colspan="8" >
                                        <p >
                                    Distributor Name  : <span style="font-weight:normal"><?php echo $rows['name']; ?></span><br>        
                                    Order ID  : <span style="font-weight:normal"><?php echo $_GET['orderid']; ?></span><br>
                                    Order Date :  <span style="font-weight:normal"><?php echo $order_date; ?></span><br>
                                    
                                    Payment Status &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:  <span style="font-weight:normal"><?php echo $orderStatusAry[$order_status]; ?></span><br>
                                    </p>
                                    </th>
                                </tr>
                                <tr>
                                    <th>S.No</th>
                                    <th colspan="2">Product</th>
                                    <th >HSN Code</th>

<th >Quantity</th>
                                    <th>Unit Price</th>
                                    <th>Commission</th>
                                    <th>Total</th>
                                </tr>
                            </thead>

<tbody>
                           <?php  
                           $oid=$_GET['orderid'];
                           $i=1;
                           $total=0;
                           $shiptotal=0;
                           $temp_total=0;
                           $temp_shiptotal=0;
                           $gstAmount=0;
                           $totalAmount =0;
                           $sql=mysqli_query($conn,"select * from  $tblOrderDetails  where  order_id='$oid'")or die(mysqli_error());
                            while($row=mysqli_fetch_assoc($sql))
                            {
                                $gstAmount+=$row['rm_commision_price'];
                                $totalAmount+=($row['rm_price']*$row['quantity']);
                            ?>
                            <tr>
                                <td><?php echo $i++;?></td>
                                <td colspan="2"><?= $productNameAry[$row['product_id']]?></td>
                                <td><?= $row['hsn_code'];?></td>
                                <td><?= $row['quantity'];?></td>
                                
                                <td><i class="fa fa-inr"></i> <?= $row['rm_price'];?></td>
                                <td><i class="fa fa-inr"></i> <?= $row['rm_commision_price'];?></td>
                                <td><i class="fa fa-inr"></i> <?= $row['rm_price']*$row['quantity'];?></td>
                            </tr>
                            
                            <?php }?>
                             <tr style="background-color:#f1f1f1">
                                
                                <td colspan="7" align="right"><strong>Total Amount</strong></td>
                                <td><i class="fa fa-inr"></i> <?php echo $totalAmount;?></td>
                            </tr>
                            <tr style="background-color:#f1f1f1">
                                
                                <td colspan="7" align="right"><strong>Total Comm.</strong></td>
                                <td><i class="fa fa-inr"></i> <?php echo $gstAmount;
                                ?></td>
                            </tr>
                            
                            
                            </tbody>
                        </table>
                    <?php }else{?>
                        <table id="printtable"  class="table table-striped table-bordered table-hover" >
                    <thead>
                        <tr style=" border:0;">
                            <th 
                            colspan="9" style=" border:0;text-align:center;">
                                <h3><strong>Purchase Order</strong></h3>
                            </th>
                        </tr>   
                        <tr>
                            <th colspan="9" >
                                <p >
                            Order ID  : <span style="font-weight:normal"><?php echo $_GET['orderid']; ?></span><br>
                            Order Date :  <span style="font-weight:normal"><?php echo $order_date; ?></span><br>
                            
                            Payment Status &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:  <span style="font-weight:normal"><?php echo $orderStatusAry[$order_status]; ?></span><br>

</p>
                            </th>
                        </tr>
                        <tr>
                            <th rowspan="2">S.No</th>
                            <th rowspan="2" colspan="2">Product</th>
                            <th rowspan="2" >HSN/SAC</th>
                            <th rowspan="2" >Qty</th>
                            <th rowspan="2">Price</th>
                            <th colspan="2">GST</th>
                            <th rowspan="2">Total</th>
                        </tr>
                        <tr>
                            <th>%</th>
                            <th>Amt.</th>
                        </tr>
                    </thead>

<tbody>
                   <?php  
                   $oid=$_GET['orderid'];
                   $i=1;
                   $total=0;
                   $shiptotal=0;
                   $temp_total=0;
                   $temp_shiptotal=0;
                   $gstAmount=0;
                   $sql=mysqli_query($conn,"select * from  $tblOrderDetails  where  order_id='$oid'")or die(mysqli_error());
                    while($row=mysqli_fetch_assoc($sql))
                    {
                        $gstAmount+=$row['gst_amount'];
                    ?>
                    <tr>
                        <td><?php echo $i++;?></td>
                        <td colspan="2"><?= $productNameAry[$row['product_id']]?></td>
                        <td ><?= $row['hsn_code']?></td>
                        
                        <td><?= $row['quantity'];?></td>
                        
                        <td><i class="fa fa-inr"></i> <?= $row['price'];?></td>
                        <td><?= $row['gst_rate'];?></td>
                        <td><i class="fa fa-inr"></i> <?= $row['gst_amount'];?></td>
                        <td><i class="fa fa-inr"></i> <?= $row['total'];?></td>
                        
                        
                    </tr>
                    
                    <?php }?>
                     <tr style="background-color:#f1f1f1">
                        
                        <td colspan="8" align="right"><strong>Total Amount</strong></td>
                        <td><i class="fa fa-inr"></i> <?php echo $total_amount;?></td>
                    </tr>
                    <tr style="background-color:#f1f1f1">
                        
                        <td colspan="8" align="right"><strong>GST</strong></td>
                        <td><i class="fa fa-inr"></i> <?php $gstAmount;
                        echo $gstAmount;
                        ?></td>
                    </tr>
                    <tr style="background-color:#f1f1f1">
                        
                        <td colspan="8" align="right"><strong>Payble Amount</strong></td>
                        <td><i class="fa fa-inr"></i> <?php echo round($gstAmount+$total_amount,2);
                        
                        ?></td>
                    </tr>
                    
                    </tbody>
                </table>
                   <?php  }
                ?>

</div>
                                <button style="margin:0 auto; display:block; margin-top:5px;" 
                                onClick="myFunction()" class="btn btn-success"><i class="fa fa-print"></i> Print Report</button>
                                <div id="showrecord">     
                                </div>
                    </div>
                </div>
            </div>

<?php include'include/footer-file.php';?>

<script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/select2-3.5.2/select2.min.js"></script>

</body>
</html>

//======================= add name end ==================================*/
$(document).on('click','.page-link',function(){
    var pageID=$(this).attr("pageid");
    var status=$(this).attr("pageid2");
    var getbackurl=$("#getbackurl").val();
    
    $("#showrecord").html('<center><i  class="fa fa-spinner fa-spin" aria-hidden="true"></i></center>');
    var cid= $("#applicationid").val();
    var getquerystring= $("#getquerystring").val();

$.ajax({
            type: "POST",
            url: "function/getOrderPageList.php",
            data: "pageID="+ pageID+"&getquerystring="+getquerystring,
            success: function(html){

$("#showrecord").html(html);
        }
    });
    return false;
});
</script>

$(document).ready(function(){
$('.pagination').pagination({
        items: <?php echo $total_records;?>,
        itemsOnPage: <?php echo $limit;?>,
        cssStyle: 'light-theme',
        currentPage : <?php echo $page;?>,
        hrefTextPrefix : 'brands-list.php?page='
    });
    });
</script>

<script src="vendor/datatables/media/js/jquery.dataTables.min.js"></script>
<script src="vendor/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>

$(function () {

// Initialize Example 1
        $('#example1').dataTable( {
            "ajax": 'api/datatables.json',
            dom: "<'row'<'col-sm-4'l><'col-sm-4 text-center'B><'col-sm-4'f>>tp",
            "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ],
            buttons: [
                {extend: 'copy',className: 'btn-sm'},
                {extend: 'csv',title: 'ExampleFile', className: 'btn-sm'},
                {extend: 'pdf', title: 'ExampleFile', className: 'btn-sm'},
                {extend: 'print',className: 'btn-sm'}
            ]
        });

// Initialize Example 2
        $('#example2').dataTable();

});

</script>

$(function(){

$("#form_2").validate({
            rules: {
                name: {
                    required: true,
                    minlength: 3
                },
                username: {
                    required: true,
                    minlength: 5
                },
                url: {
                    required: true,
                    url: true
                },
                number: {
                    required: true,
                    number: true
                },
                last_name: {
                    required: true,
                    minlength: 6
                }
            },
            messages: {
                number: {
                    required: "(Please enter your phone number)",
                    number: "(Please enter valid phone number)"
                },
                last_name: {
                    required: "This is custom message for required",
                    minlength: "This is custom message for min length"
                }
            },
            submitHandler: function(form) {
                form.submit();
            },
            errorPlacement: function(error, element) {
                $( element )
                        .closest( "form" )
                        .find( "label[for='" + element.attr( "id" ) + "']" )
                        .append( error );
            },
            errorElement: "span",
        });

});
</script>
 <script>

$(function(){

$('#datepicker').datepicker();
            $("#datepicker").on("changeDate", function(event) {
                $("#my_hidden_input").val(
                        $("#datepicker").datepicker('getFormattedDate')
                )
            });

$('#datapicker2').datepicker();
            $('.input-group.date').datepicker({ });
            $('.input-daterange').datepicker({ });

$("#demo1").TouchSpin({
                min: 0,
                max: 100,
                step: 0.1,
                decimals: 2,
                boostat: 5,
                maxboostedstep: 10,
            });

$("#demo2").TouchSpin({
                verticalbuttons: true
            });

$("#demo3").TouchSpin({
                postfix: '%'
            });

$("#demo4").TouchSpin({
                postfix: "a button",
                postfix_extraclass: "btn btn-default"
            });

$(".js-source-states").select2();
            $(".js-source-states-2").select2();

//turn to inline mode
            $.fn.editable.defaults.mode = 'inline';

//defaults
            $.fn.editable.defaults.url = '#';

//editables
            $('#username').editable({
                url: '#',
                type: 'text',
                pk: 1,
                name: 'username',
                title: 'Enter username'
            });

$('#firstname').editable({
                validate: function(value) {
                    if($.trim(value) == '') return 'This field is required';
                }
            });

$('#sex').editable({
                prepend: "not selected",
                source: [
                    {value: 1, text: 'Male'},
                    {value: 2, text: 'Female'}
                ],
                display: function(value, sourceData) {
                    var colors = {"": "gray", 1: "green", 2: "blue"},
                            elem = $.grep(sourceData, function(o){return o.value == value;});

if(elem.length) {
                        $(this).text(elem[0].text).css("color", colors[value]);
                    } else {
                        $(this).empty();
                    }
                }
            });

$('#dob').editable();

$('#event').editable({
                placement: 'right',
                combodate: {
                    firstItem: 'name'
                }
            });

$('#comments').editable({
                showbuttons: 'bottom'
            });

$('#fruits').editable({
                pk: 1,
                limit: 3,
                source: [
                    {value: 1, text: 'banana'},
                    {value: 2, text: 'peach'},
                    {value: 3, text: 'apple'},
                    {value: 4, text: 'watermelon'},
                    {value: 5, text: 'orange'}
                ]
            });

$('#user .editable').on('hidden', function(e, reason){
                if(reason === 'save' || reason === 'nochange') {
                    var $next = $(this).closest('tr').next().find('.editable');
                    if($('#autoopen').is(':checked')) {
                        setTimeout(function() {
                            $next.editable('show');
                        }, 300);
                    } else {
                        $next.focus();
                    }
                }
            });

// ClockPicker
            $('.clockpicker').clockpicker({autoclose: true});

// DateTimePicker
            $('#datetimepicker1').datetimepicker();

});

</script>
    
    
<script>
function myFunction() {
    window.print();
}
</script>

Order

Purchase Order
Distributor Name : Order ID : Order Date : Payment Status :
S.No	Product	HSN Code	Quantity	Unit Price	Commission	Total

Total Amount
Total Comm.

Purchase Order
Order ID : Order Date : Payment Status :
S.No	Product	HSN/SAC	Qty	Price	GST		Total
S.No	Product	HSN/SAC	Qty	Price	%	Amt.	Total

Total Amount
GST
Payble Amount