Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/crm/backup

Free Space:

9.3 TB

🔧 Quick Actions

✏️ Editing: sale_olds.php

<?php  include "header.php";

$action=$_REQUEST['action'];

if($action=='save'){

$billno=$_POST['billno'];
        $billdate=$_POST['billdate'];
        $cidnew=$_POST['typeahead'];
        $mobno=$_POST['mobno'];
        $custnm=$_POST['custnm'];
        $cpt=$_POST['cpt'];
        $addr=$_POST['addr'];
        $prod=$_POST['prod'];
        $serial=$_POST['serial'];
        $model=$_POST['model'];
        $imei=$_POST['imei'];
        $jst=$_POST['jst'];
        $gstn=$_POST['gstn'];
        $gstnavail=$_POST['gstnavail'];
        $jbst=$_POST['jbst'];
        $osc=$_POST['osc'];
        $wotax=$_POST['wotax'];
        $upstock=$_POST['upstock'];
        $rowcnt=$_POST['rowcnt'];
        $partstot=$_POST['p_totamt'];
        $iscustnew=$_POST['iscustnew'];
        $totbillamt=$_POST['totbillamt'];
        $totbillpaid=$_POST['totbillpaid'];
        $totbilldue=$_POST['totbilldue'];
        $paymode=$_POST['paymode'];

$cpname=$_POST['cpname'];
        $coup_disc=$_POST['coup_disc'];
        $txtnet=$_POST['txtnet'];
        $pay_det=$_POST['pay_det'];
        $totadvance=$_POST['totadvance'];
        $txtcoupon=$_POST['txtcoupon'];
        $jobsheet=$_POST['browser'];
        $totdueamt=$_POST['totdueamt'];
        $jst=$_POST['jst'];

$srowcnt=$_POST['srowcnt'];

$getcomp=f(q("SELECT * FROM db_store WHERE id=1"));
        $getprod=f(q("SELECT * FROM db_product WHERE p_id='$prod'"));
        $prodnme=$getprod['p_name'];

$uid=$_SESSION['bigapple'];
        if($iscustnew=='1'){
            $cname=$_POST['typeahead'];

$checkcust=f(q("select * from db_customer where mob_no='$mobno'"));
            if($checkcust['cust_name']==''){
                $inscust=mysqli_query($con,"INSERT INTO db_customer SET cust_name='$cname',address='$addr',mob_no='$mobno',GSTN='$gstn'");
                    if($inscust){

$getc=f(q("SELECT MAX(id) as maxid from db_customer"));
                        $cid=$getc['maxid'];

}

}else{

$cid=$checkcust['id'];

}

}else{

$cid=$_POST['cid'];
            $getcust=f(q("SELECT * FROM db_customer WHERE id='$cid'"));
            $cname=$getcust['cust_name'];
        }

$qq=f(q("SELECT max(billsrl) as maxsrl FROM db_sales"));
         $mxsrl=$qq['maxsrl'];

$billsrl=floatval($mxsrl)+1;

$inssale=mysqli_query($con,"INSERT INTO db_sales SET bill_no='$billno',bill_date='$billdate',customer_name='$cname',mobile_no='$mobno',address='$addr',total='$totbillamt',amt_paid='$totbillpaid',paid_by='$paymode',due='$totbilldue',stkupdate=0,company_id='$getcomp[id]',tax_rate='',grand_total='$totbillamt',prescribed_by='$uid',tax_id=0,com_name='$getcomp[store_name]',com_phone='$getcomp[phone]',com_email='$getcomp[email]',com_addr='$getcomp[address]',com_holding='$getcomp[holding_no]',com_dl='$getcomp[dl_no]',com_tax='$getcomp[tax_no]',com_notes='$getcomp[note]',com_terms='$getcomp[terms]',bill_time='',com_heading='$getcomp[j_note]',com_footers='$getcomp[footer_note]',added_by='$uid',doc_reg='NA',notax=1,gstavailable=0,cust_type='$cpt',job_id='',cust_gst='$gstn',p_flag='0',billsrl='$billsrl',prod_id='$prod',prod_name='$prodnme',prod_model='$model',prod_serial='$serial',prod_bp='$imei',prod_so='$jst',coup_name='$cpname',coup_disc='$coup_disc',bill_net='$txtnet',pay_det='$pay_det',coupval='$txtcoupon',advpaym='$totadvance',jobsheet='$jst',amtpayb='$totdueamt'");

if($inssale){
        $getmaxsale=f(q("SELECT MAX(id) as maxid FROM db_sales"));
        $maxsaleid=$getmaxsale['maxid'];

if($jobsheet!=''){

$upjob=mysqli_query($con,"UPDATE db_jobsheet SET stat='Completed' WHERE j_no='$jobsheet'");

}

for($i=1;$i<=$rowcnt;$i++){

$barcode=$_POST['barcode'.$i];
            $partid=$_POST['partnm'.$i];
            $pname=$_POST['pname'.$i];
            $catnm=$_POST['catnm'.$i];
            $catname=$_POST['catname'.$i];
            $hsn=$_POST['hsn'.$i];
            $desc=$_POST['desc'.$i];
            $warr=$_POST['warr'.$i];
            $batch=$_POST['batch'.$i];
            $avail=$_POST['avail'.$i];
            $qunt=$_POST['qunt'.$i];
            $unit=$_POST['unit'.$i];
            $price=$_POST['price'.$i];
            $stotal=$_POST['stotal'.$i];
            $disc=$_POST['disc'.$i];
            $discamt=$_POST['discamt'.$i];
            $gst=$_POST['gst'.$i];
            $taxamt=$_POST['taxamt'.$i];
            $total=$_POST['total'.$i];
            //$barcode=$_POST['barcode'.$i];

$cgst=floatval($gst)/2;
            $cgstamt=floatval($taxamt)/2;

if($osc==1){

$igst=$gst;
                $igstamt=$taxamt;
            }else{

$igst=0;
                $igstamt=0;
            }

$insJob=mysqli_query($con,"INSERT INTO db_saleitems SET sale_id='$maxsaleid',med_name='$pname',gen_name='$catname',batch_no='$batch',available='$avail',exp_date=CURDATE(),quan='$qunt',unit='$unit',price='$price',totalv='$total',cgst='$cgst',cgst_amt='$cgstamt',sub_total='$stotal',prescribed='$uid',med_id='$partid',disc_type='',sgst='$cgst',sgst_amt='$cgstamt',disc_amt='$discamt',taxable='$taxamt',disc_val='$discamt',barcode='$barcode',igst='$igst',igst_amt='$igstamt',gstrate='$gst',hsn='$hsn',descrip='$desc',warr='$warr'");

if($insjob){
                    $getmaxid=f(q("SELECT MAX(id) as maxid FROM db_saleitems"));

$insstk=mysqli_query($con,"INSERT INTO `stock_dt` SET `item_code`='$partid', `item_name`='$pname',`item_type`='$catname',`quantity`='$qunt', `rate`='$price', `amount`='$stotal', `date1`='$billdate', `opening`='0',`remarks`='Sales Entry', `status`='Completed', `purchase_id`='$maxsaleid', `item_id`='$partid',`unit_type`='$unit',`bill_no`='$billno',`dispatch_id`='0',`returned_id`='0',`ab_loss_id`='0', `notax`='$istax'");

// echo "INSERT INTO `stock_dt` SET `item_code`='$partid', `item_name`='$pname',`item_type`='$catname',`quantity`='$qunt', `rate`='$price', `amount`='$stotal', `date1`='$billdate', `opening`='0',`remarks`='Sales Entry', `status`='Completed', `purchase_id`='$maxsaleid', `item_id`='$partid',`unit_type`='$unit',`bill_no`='$billno',`dispatch_id`='0',`returned_id`='0',`ab_loss_id`='0', `notax`='$istax'";

if(!$insstk){

echo mysql_error();
                    }

}

for($k=1;$k<=$srowcnt;$k++){

$servnm=$_POST['servnm'.$k];
            $srvnames=$_POST['srvnames'.$k];
            $pname=$_POST['pname'.$k];
            $code=$_POST['code'.$k];
            $prc=$_POST['prc'.$k];
            $discount=$_POST['discount'.$k];
            $subtot=$_POST['subtot'.$k];
            $srgst=$_POST['srgst'.$k];
            $srtaxamt=$_POST['srtaxamt'.$k];
            $srtotall=$_POST['srtotall'.$k];
            $scgst=floatval($srgst)/2;
            $srgstval=floatval($srtaxamt)/2;

if($osc==1){

$sigst=$srgst;
                $sigstval=$srgstval;
            }else{

$sigst=0;
                $sigstval=0;
            }

$insserv=mysqli_query($con,"INSERT INTO db_servicebills SET sale_id='$maxsaleid',se_name='$srvnames',se_pid='$servnm',se_sac='$code',se_price='$prc',se_sub='$subtot',se_cgst='$scgst',se_sgst='$scgst',se_cgstamt='$srgstval',se_sgstamt='$srgstval',se_taxamt='$srtaxamt',se_disc='$discount',se_total='$srtotall',se_igst='$sigst',se_igstamt='$sigstval',se_gstrate='$srgst',se_billno='$billno',se_billdate='$billdate',se_buyername='$cname',se_contact='$mobno',se_bgstno='$gstn',se_pmode='$paymode',p_mode=0");

}

function sendMessage($mobile,$msgs){

$getc=f(q("SELECT * FROM db_customer WHERE mob_no='$mobile'"));
        $devid=$getc['devid'];

$content = array(
            "en" => $msgs
            );
        
        $fields = array(
            'app_id' => "e28ea04a-6f0d-4246-a91c-0ab790badc61",
            'include_player_ids' => array($getc['devid']),
            'data' => array("foo" => "bar"),
            'contents' => $content
            
        );
        //$fields['large_icon'] = 'http://billing.a2zsolutionkolkata.com/custapp/img/az2_applogo.png' ;'large_icon' =>"http://billing.a2zsolutionkolkata.com/custapp/img/icon.png"
        
        $fields = json_encode($fields);
       // print("\nJSON sent:\n");
        //print($fields);
        
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, "https://onesignal.com/api/v1/notifications");
        curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json; charset=utf-8'));
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
        curl_setopt($ch, CURLOPT_HEADER, FALSE);
        curl_setopt($ch, CURLOPT_POST, TRUE);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $fields);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

$response = curl_exec($ch);
        curl_close($ch);
        
        return $response;
    }

if($mobno!=''){
    //echo "Hello Beta";
    $otpmsg="DEAR USER YOUR INVOICE NUMBER IS ".$billno." AND INVOICE AMOUNT IS RS. ".$totbillamt;
    $url = 'http://103.233.79.246//submitsms.jsp';
     $fields = array(
    'user' => urlencode('CablePS'),
    'key' => urlencode('625925a5a4XX'),
    'mobile' => urlencode($mobno),
    'message' => urlencode($otpmsg),
    'senderid' => urlencode('AZSOLU'),
    'accusage' => urlencode('1')
    );

//url-ify the data for the POST
 foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
 rtrim($fields_string, '&');

//open connection
 $ch = curl_init();

// //set the url, number of POST vars, POST data
 curl_setopt($ch,CURLOPT_URL, $url);
 curl_setopt($ch,CURLOPT_POST, count($fields));
 curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string);

// //execute post
 $result = curl_exec($ch);

// //close connection
 curl_close($ch);

$response = sendMessage($mobno,$otpmsg);
    $return["allresponses"] = $response;
    $return = json_encode( $return);
}

echo "<script>

window.onload = function(){
         window.open('sales-print.php?saleid=$maxsaleid', '_blank'); // will open new tab on window.onload
    }
</script>";

}else{

echo mysql_error();
    }

}
if($action!='edit'){

$qq=f(q("SELECT max(billsrl) as maxsrl FROM db_sales"));
    $mxsrl=$qq['maxsrl'];

if ( date('m') > 4 ) {
    $year = date('Y') + 1;
        }
        else {
            $year = date('Y');
        }

$year=substr($year, 2);

$yrr=substr(date('Y'),2).'-'.$year;
        $mnth=date('M');

$billno=floatval($mxsrl)+1;
    $billno="A2Z/".$yrr.'/'.$mnth.'/'.$billno;

}

display: block;
    width: 100%;
    padding: 0.175rem 0.45rem;
    font-size: 0.675rem;
    line-height: 1;
    color: #4F5467;
    background-color: #fff;
    background-clip: padding-box;
    border: 1px solid #e9ecef;
    border-radius: 2px;
    -webkit-transition: border-color 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out;
    transition: border-color 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out;
    -o-transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;
    transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out;
    transition: border-color 0.15s ease-in-out, box-shadow 0.15s ease-in-out, -webkit-box-shadow 0.15s ease-in-out;
    }
    label{
        color:white;
        font-size: 11px;
    }
    input[type="text"]:focus { 
    
    border: 2px solid red;   
    }
    select:focus{

border: 2px solid red;  
    }
    textarea:focus{
        border: 2px solid red; 
    }

input[type="checkbox"]:focus { 
    
    border: 1px solid red;   
    }
    .select2-selection:focus{
        border: 1px solid red;

}
    td, input[type="text"]{

font-size: 12px;
    }
    .icl{

font-size: 12px;
        line-height: 12px;
    }
</style>
<style>
                    th{
                        width:10%;
                        text-align:center;
                        font-size: 10px;
                    }
                    table{
                        width:100%;
                    }
                    tr{
                        width:100%;
                        background-color:white;
                    }
                    td{
                        text-align:center;
                    }
                    .tdclass{

width:19%;
                    }
                    .datalist {
    overflow-y: auto !important; 
}

</style>
                <script>
                    function addtablerow(){
                        var table = document.getElementById("purtable");
                        var barcode=document.getElementById('barcode').value;
                        var partnm=document.getElementById('pidh').value;
                        var pname=document.getElementById('pname').value;
                        var catnm=document.getElementById('catnm').value;
                        var catname=document.getElementById('catname').value;
                        var hsn=document.getElementById('hsn').value;
                        var desc=document.getElementById('desc').value;
                        var warr=document.getElementById('warr').value;
                        var batch=document.getElementById('batch').value;
                        var avail=document.getElementById('avail').value;
                        var qunt=document.getElementById('pqunt').value;
                        var unit=document.getElementById('unit').value;
                        var price=document.getElementById('pprice').value;
                        var stotal=document.getElementById('pstotal').value;
                        var disc=document.getElementById('disc').value;
                        var disctype=document.getElementById('disctype').value;
                        var discamt=document.getElementById('discamt').value;
                        var gst=document.getElementById('gst').value;
                        var taxamt=document.getElementById('taxamt').value;
                        var total=document.getElementById('total').value;
                        var cnt=document.getElementById('rowcnt').value
                        if(cnt==0){
                            cnt=parseFloat(cnt)+1;
                        }else{
                            cnt=parseFloat(cnt)+1;
                        }
                        document.getElementById('rowcnt').value=cnt;

var tr = document.createElement("tr");

var tdbarcode = document.createElement("td");
                            var tdpartnm = document.createElement("td");
                            var tdcatnm = document.createElement("td");
                            var tdhsn = document.createElement("td");
                            var tddesc = document.createElement("td");
                             var tdwarr = document.createElement("td");
                            var tdbatch = document.createElement("td");
                            var tdavail=document.createElement("td");
                            var tdqunt = document.createElement("td");
                            var tdunit = document.createElement("td");
                            var tdprice = document.createElement("td");
                            var tdstotal = document.createElement("td");
                            var tddisc = document.createElement("td");
                            var tddisctype = document.createElement("td");
                            var tdgst = document.createElement("td");
                            var tdtaxamt = document.createElement("td");
                            var tdtotal = document.createElement("td");
                            var tddelete = document.createElement("td");

var txtbarcode =document.createElement('input'); 
                            txtbarcode.setAttribute('type','text'); 
                            txtbarcode.setAttribute('class','icl');// set attributes ...
                            txtbarcode.setAttribute('name','barcode'+cnt);
                            txtbarcode.setAttribute('value',barcode);  //document.createTextNode(prodid);

var txtpartnm = document.createElement('input'); 
                            txtpartnm.setAttribute('type','hidden'); 
                            txtpartnm.setAttribute('class','icl');// set attributes ...
                            txtpartnm.setAttribute('name','partnm'+cnt);
                            txtpartnm.setAttribute('value',partnm);  //document.createTextNode(quan);

var txtpname = document.createElement('input'); 
                            txtpname.setAttribute('type','text'); 
                            txtpname.setAttribute('class','icl');// set attributes ...
                            txtpname.setAttribute('name','pname'+cnt);
                            txtpname.setAttribute('value',pname);  //document.createTextNode(quan);

var txtcatnm = document.createElement('input'); 
                            txtcatnm.setAttribute('type','hidden'); 
                            txtcatnm.setAttribute('class','icl');// set attributes ...
                            txtcatnm.setAttribute('name','catnm'+cnt);
                            txtcatnm.setAttribute('value',catnm);  //document.createTextNode(quan);

var txtcatname = document.createElement('input'); 
                            txtcatname.setAttribute('type','text'); 
                            txtcatname.setAttribute('class','icl');// set attributes ...
                            txtcatname.setAttribute('name','catname'+cnt);
                            txtcatname.setAttribute('value',catname);  //document.createTextNode(quan);

var txthsn = document.createElement('input'); 
                            txthsn.setAttribute('type','text'); 
                            txthsn.setAttribute('class','icl');// set attributes ...
                            txthsn.setAttribute('name','hsn'+cnt);
                            txthsn.setAttribute('value',hsn);  //document.createTextNode(price);

var txtdesc = document.createElement('input'); 
                            txtdesc.setAttribute('type','text'); 
                            txtdesc.setAttribute('class','icl');// set attributes ...
                            txtdesc.setAttribute('name','desc'+cnt);
                            txtdesc.setAttribute('value',desc);  //document.createTextNode(gst);

var txtwarr = document.createElement('input'); 
                            txtwarr.setAttribute('type','text'); 
                            txtwarr.setAttribute('class','icl');// set attributes ...
                            txtwarr.setAttribute('name','warr'+cnt);
                            txtwarr.setAttribute('value',warr);  //document.createTextNode(gst);

var txtbatch = document.createElement('input'); 
                            txtbatch.setAttribute('type','text'); 
                            txtbatch.setAttribute('class','icl');// set attributes ...
                            txtbatch.setAttribute('name','batch'+cnt);
                            txtbatch.setAttribute('value',batch);  //document.createTextNode(price);

var txtavail = document.createElement('input'); 
                            txtavail.setAttribute('type','text'); 
                            txtavail.setAttribute('class','icl');// set attributes ...
                            txtavail.setAttribute('name','avail'+cnt);
                            txtavail.setAttribute('value',avail);  //document.createTextNode(price);

var txtqunt = document.createElement('input'); 
                            txtqunt.setAttribute('type','text'); 
                            txtqunt.setAttribute('class','icl');// set attributes ...
                            txtqunt.setAttribute('name','qunt'+cnt);
                            txtqunt.setAttribute('value',qunt);  //document.createTextNode(price);

var txtunit = document.createElement('input'); 
                            txtunit.setAttribute('type','text'); 
                            txtunit.setAttribute('class','icl');// set attributes ...
                            txtunit.setAttribute('name','unit'+cnt);
                            txtunit.setAttribute('value',unit);  //document.createTextNode(price);

var txtprice= document.createElement('input'); 
                            txtprice.setAttribute('type','text'); 
                            txtprice.setAttribute('class','icl');// set attributes ...
                            txtprice.setAttribute('name','price'+cnt);
                            txtprice.setAttribute('value',price);  //document.createTextNode(quan);

var txtstotal = document.createElement('input'); 
                            txtstotal.setAttribute('type','text'); 
                            txtstotal.setAttribute('class','icl');// set attributes ...
                            txtstotal.setAttribute('name','stotal'+cnt);
                            txtstotal.setAttribute('value',stotal);  //document.createTextNode(price);

var txtdisc = document.createElement('input'); 
                            txtdisc.setAttribute('type','text'); 
                            txtdisc.setAttribute('class','icl');// set attributes ...
                            txtdisc.setAttribute('name','disc'+cnt);
                            txtdisc.setAttribute('value',disc+' '+disctype);  //document.createTextNode(gst);

var txtdisctype = document.createElement('input'); 
                            txtdisctype.setAttribute('type','hidden'); 
                            txtdisctype.setAttribute('class','icl');// set attributes ...
                            txtdisctype.setAttribute('name','disctype'+cnt);
                            txtdisctype.setAttribute('value',disctype);  //document.createTextNode(price);

var txtdiscamt = document.createElement('input'); 
                            txtdiscamt.setAttribute('type','text');
                            txtdiscamt.setAttribute('class','icl'); // set attributes ...
                            txtdiscamt.setAttribute('name','discamt'+cnt);
                            txtdiscamt.setAttribute('value',discamt);  //document.createTextNode(price);

var txtgst = document.createElement('input'); 
                            txtgst.setAttribute('type','text');
                            txtgst.setAttribute('class','icl'); // set attributes ...
                            txtgst.setAttribute('name','gst'+cnt);
                            txtgst.setAttribute('value',gst);  //document.createTextNode(price);

var txttaxamt = document.createElement('input'); 
                            txttaxamt.setAttribute('type','text'); 
                            txttaxamt.setAttribute('class','icl');// set attributes ...
                            txttaxamt.setAttribute('name','taxamt'+cnt);
                            txttaxamt.setAttribute('value',taxamt);  //document.createTextNode(price);

var txttotal= document.createElement('input'); 
                            txttotal.setAttribute('type','text'); 
                            txttotal.setAttribute('class','icl');// set attributes ...
                            txttotal.setAttribute('name','total'+cnt);
                            txttotal.setAttribute('id','total'+cnt);
                            txttotal.setAttribute('value',total);  //document.createTextNode(quan);

var butt = document.createElement('input'); // create a button
                                butt.setAttribute('type','button'); // set attributes ...
                                butt.setAttribute('name','javaSubmit');
                                butt.setAttribute('value','remove');
                                
                                butt.onclick = function() { // set onclick handler
                                  deleteRowpur(this);
                                  
                                }

tdbarcode.appendChild(txtbarcode);
                            tdpartnm.appendChild(txtpartnm);
                             tdpartnm.appendChild(txtpname);

tdcatnm.appendChild(txtcatnm);
                            tdcatnm.appendChild(txtcatname);

tdhsn.appendChild(txthsn);
                            tddesc.appendChild(txtdesc);
                            tdwarr.appendChild(txtwarr);
                            tdbatch.appendChild(txtbatch);
                            tdavail.appendChild(txtavail);
                            tdqunt.appendChild(txtqunt);
                            tdunit.appendChild(txtunit);
                            tdprice.appendChild(txtprice);
                            tdstotal.appendChild(txtstotal);
                            tddisc.appendChild(txtdisc);
                            tddisctype.appendChild(txtdiscamt);
                            tdgst.appendChild(txtgst);
                            tdtaxamt.appendChild(txttaxamt);
                            tdtotal.appendChild(txttotal);
                            tddelete.appendChild(butt);

tr.appendChild(tdbarcode);
                            tr.appendChild(tdpartnm);
                            tr.appendChild(tdcatnm);
                            tr.appendChild(tdhsn);
                            tr.appendChild(tddesc);
                            tr.appendChild(tdwarr);
                            tr.appendChild(tdbatch);
                            tr.appendChild(tdavail);
                            tr.appendChild(tdqunt);
                            tr.appendChild(tdunit);
                            tr.appendChild(tdprice);
                            tr.appendChild(tdstotal);
                            tr.appendChild(tddisc);
                            tr.appendChild(tddisctype);
                            tr.appendChild(tdgst);
                            tr.appendChild(tdtaxamt);
                            tr.appendChild(tdtotal);
                            tr.appendChild(tddelete);

table.appendChild(tr);
                            var gtot=0;

for(a=1;a<=cnt;a++){
                                        try{
                                            var tots=document.getElementById('total'+a).value;
                                        //var taxtots=document.getElementById('tax'+a).value;
                                        //alert(tots);
                                        gtot=parseFloat(gtot)+parseFloat(tots);
                                        //txtoto=parseFloat(txtoto) + parseFloat(taxtots);

}catch(e) {

}

}
                                    document.getElementById('grandtot').value=gtot;
                                    gentotal();

}

function checkclick(nme,src){

if(document.getElementById(src).checked == true){

document.getElementById(nme).value=1;
                        }else{

document.getElementById(nme).value=0;
                        }

}

function checknew(nme,src){

if(document.getElementById(src).checked == true){

document.getElementById(nme).value=1;
                            document.getElementById('oldcust').style.visibility='hidden';
                            document.getElementById('newcust').style.visibility='visible';
                        }else{

document.getElementById(nme).value=0;
                            document.getElementById('oldcust').style.visibility='visible';
                            document.getElementById('oldcust').setAttribute("margin-top", "-30px");
                            
                            document.getElementById('newcust').style.visibility='hidden';
                        }

}

function deleteRowpur(btn) {
                        var row = btn.parentNode.parentNode;
                        row.parentNode.removeChild(row);
                        var cnt=document.getElementById('rowcnt').value;
                        cnt=parseFloat(cnt)-1;
                        document.getElementById('rowcnt').value=cnt;

var gtot=0;

}catch(e) {
                                                        
                                                    }

}
                                    //alert(gtot);
                                    document.getElementById('grandtot').value=gtot;
                                    gentotal();
                        
                        }

/*2nd Service Part*/

function addsertablerow(){
                        var table = document.getElementById("sertable");
                        var servnm=document.getElementById('srvname').value;
                        var srvnames=document.getElementById('srvnames').value;
                        var code=document.getElementById('code').value;
                        var prc=document.getElementById('prc').value;
                        var discount=document.getElementById('sdiscount').value;
                        var subtot=document.getElementById('subtot').value;
                        var srgst=document.getElementById('srgst').value;
                        var srtaxamt=document.getElementById('srtaxamt').value;
                        var srtotal=document.getElementById('srtotal').value;
                        var cnt=document.getElementById('srowcnt').value
                        if(cnt==0){
                            cnt=parseFloat(cnt)+1;
                        }else{
                            cnt=parseFloat(cnt)+1;
                        }
                        document.getElementById('srowcnt').value=cnt;

var tr = document.createElement("tr");

var tdservnm = document.createElement("td");
                            var tdcode = document.createElement("td");
                            var tdprc = document.createElement("td");
                            var tddiscount = document.createElement("td");
                            var tdsubtot = document.createElement("td");
                            var tdsrgst = document.createElement("td");
                            var tdsrtaxamt=document.createElement("td");
                            var tdsrtotal = document.createElement("td");
                            var tddelete = document.createElement("td");

var txtservnm =document.createElement('input'); 
                            txtservnm.setAttribute('type','hidden'); // set attributes ...
                            txtservnm.setAttribute('name','servnm'+cnt);
                            txtservnm.setAttribute('value',servnm);  //document.createTextNode(prodid);

var txtsrvnames =document.createElement('input'); 
                            txtsrvnames.setAttribute('type','text'); // set attributes ...
                            txtsrvnames.setAttribute('name','srvnames'+cnt);
                            txtsrvnames.setAttribute('value',srvnames);  //document.createTextNode(prodid);

var txtcode = document.createElement('input'); 
                            txtcode.setAttribute('type','text'); // set attributes ...
                            txtcode.setAttribute('name','code'+cnt);
                            txtcode.setAttribute('value',code);  //document.createTextNode(quan);

var txtprc = document.createElement('input'); 
                            txtprc.setAttribute('type','text'); // set attributes ...
                            txtprc.setAttribute('name','prc'+cnt);
                            txtprc.setAttribute('value',prc);  //document.createTextNode(quan);

var txtdisc = document.createElement('input'); 
                            txtdisc.setAttribute('type','text'); // set attributes ...
                            txtdisc.setAttribute('name','discount'+cnt);
                            txtdisc.setAttribute('value',discount);  //document.createTextNode(price);

var txtsubtot = document.createElement('input'); 
                            txtsubtot.setAttribute('type','text'); // set attributes ...
                            txtsubtot.setAttribute('name','subtot'+cnt);
                            txtsubtot.setAttribute('value',subtot);  //document.createTextNode(gst);

var txtsrgst = document.createElement('input'); 
                            txtsrgst.setAttribute('type','text'); // set attributes ...
                            txtsrgst.setAttribute('name','srgst'+cnt);
                            txtsrgst.setAttribute('value',srgst);  //document.createTextNode(price);

var txtsrtaxamt = document.createElement('input'); 
                            txtsrtaxamt.setAttribute('type','text'); // set attributes ...
                            txtsrtaxamt.setAttribute('name','srtaxamt'+cnt);
                            txtsrtaxamt.setAttribute('value',srtaxamt);  //document.createTextNode(price);

var txtsrtotal = document.createElement('input'); 
                            txtsrtotal.setAttribute('type','text'); // set attributes ...
                            txtsrtotal.setAttribute('name','srtotall'+cnt);
                            txtsrtotal.setAttribute('id','srtotall'+cnt);
                            txtsrtotal.setAttribute('value',srtotal);  //document.createTextNode(price);

var butt = document.createElement('input'); // create a button
                                butt.setAttribute('type','button'); // set attributes ...
                                butt.setAttribute('name','javaSubmit');
                                butt.setAttribute('value','remove');
                                
                                butt.onclick = function() { // set onclick handler
                                  deleteRow(this);
                                  
                                }

tdservnm.appendChild(txtservnm);
                            tdservnm.appendChild(txtsrvnames);
                            tdcode.appendChild(txtcode);
                            tdprc.appendChild(txtprc);
                            tddiscount.appendChild(txtdisc);
                            tdsubtot.appendChild(txtsubtot);
                            tdsrgst.appendChild(txtsrgst);
                            tdsrtaxamt.appendChild(txtsrtaxamt);
                            tdsrtotal.appendChild(txtsrtotal);
                            tddelete.appendChild(butt);

tr.appendChild(tdservnm);
                            tr.appendChild(tdcode);
                            tr.appendChild(tdprc);
                            tr.appendChild(tddiscount);
                            tr.appendChild(tdsubtot);
                            tr.appendChild(tdsrgst);
                            tr.appendChild(tdsrtaxamt);
                            tr.appendChild(tdsrtotal);
                            tr.appendChild(tddelete);

table.appendChild(tr);

var gtot=0;

for(a=1;a<=cnt;a++){
                                        try{
                                            var tots=document.getElementById('srtotall'+a).value;
                                        //var taxtots=document.getElementById('tax'+a).value;
                                        //alert(tots);
                                        gtot=parseFloat(gtot)+parseFloat(tots);
                                        //txtoto=parseFloat(txtoto) + parseFloat(taxtots);

}catch(e) {
                                                        
                                                    }

}
                                    document.getElementById('sgrandtot').value=gtot;

gentotal();

}

function checkclick(nme,src){

if(document.getElementById(src).checked == true){

document.getElementById(nme).value=1;
                        }else{

document.getElementById(nme).value=0;
                        }

}

function checknew(nme,src){

if(document.getElementById(src).checked == true){

document.getElementById(nme).value=0;
                            document.getElementById('oldcust').style.visibility='visible';
                            document.getElementById('newcust').style.visibility='hidden';
                            document.getElementById('newcust').style.margintop="-20px";
                        }

}

function deleteRow(btn) {
                        var row = btn.parentNode.parentNode;
                        row.parentNode.removeChild(row);
                        var cnt=document.getElementById('srowcnt').value;
                        cnt=parseFloat(cnt)-1;
                        document.getElementById('srowcnt').value=cnt;

var gtot=0;

}catch(e) {
                                                        
                                                    }

}
                                    document.getElementById('sgrandtot').value=gtot;

gentotal();

}

function calsub(){

var price=document.getElementById('pprice').value;
                            var quant=document.getElementById('pqunt').value;
                            var subt=parseFloat(price)*parseFloat(quant);
                            document.getElementById('pstotal').value=subt;

}
                        function caldiscp(){

var subt=document.getElementById('pstotal').value;
                                var disc=document.getElementById('disc').value;
                                var disctype=document.getElementById('disctype').value;
                                var discamt=0;
                                if(disctype=='%'){
                                    discamt=parseFloat(subt)*(parseFloat(disc)/100);

}else{

discamt=disc;

}

document.getElementById('discamt').value=discamt;
                                document.getElementById('total').value=parseFloat(subt)-parseFloat(discamt);

}
                        function calgstp(){

var subt=document.getElementById('pstotal').value;
                                var discamt=document.getElementById('discamt').value;
                                var gst=document.getElementById('gst').value;
                                
                                var taxval=parseFloat(subt)-parseFloat(discamt);

var gstval=parseFloat(taxval)*(parseFloat(gst)/100);

document.getElementById('taxamt').value=gstval;
                                document.getElementById('total').value=parseFloat(taxval)+parseFloat(gstval);

}
                        function srvdisc(){

var prc=document.getElementById('prc').value;
                            var disc=document.getElementById('sdiscount').value;

var subt=parseFloat(prc)-parseFloat(disc);
                            document.getElementById('subtot').value=subt;

}
                        function calgsts(){

var subt=document.getElementById('subtot').value;
                                var discamt=document.getElementById('sdiscount').value;
                                var gst=document.getElementById('srgst').value;
                                
                                var taxval=parseFloat(subt)-parseFloat(discamt);

var gstval=parseFloat(taxval)*(parseFloat(gst)/100);

document.getElementById('srtaxamt').value=gstval;
                                document.getElementById('srtotal').value=parseFloat(subt)+parseFloat(gstval);

}

//          function checkdrp(nme,src){

// document.getElementById(nme).value=document.getElementById(src).value;

//      }

function gentotal(){

var partstot=document.getElementById('grandtot').value;
                    var servtot=document.getElementById('sgrandtot').value;
                    var billtot=parseFloat(partstot)+parseFloat(servtot);
                    var cpvals=document.getElementById('cpvals').value;
                    var cptype=document.getElementById('cptype').value;
                    var advance=document.getElementById('totadvance').value;
                    var dueamt=document.getElementById('totdueamt').value;
                    var netamount=0;
                    var coupdisc=0;

if(parseFloat(cpvals)>0){

if(cptype=='percentage'){

coupdisc=parseFloat(billtot)*(parseFloat(cpvals)/100);
                            netamount=parseFloat(billtot)-parseFloat(coupdisc);

}else{

netamount=parseFloat(billtot)-parseFloat(cpvals);
                              coupdisc=cpvals;

}

}else{

netamount=parseFloat(billtot);

}

document.getElementById('coup_disc').value=coupdisc;
                    document.getElementById('totbillamt').value=Math.round(billtot);
                    document.getElementById('txtnet').value=Math.round(netamount);
                    var dedue=parseFloat(netamount)-parseFloat(advance);
                    document.getElementById('totdueamt').value=Math.round(dedue);
                    document.getElementById('totbillpaid').value=Math.round(dedue);
                    document.getElementById('totbilldue').value=0;

}

function calcoupon(){

if(parseFloat(cpvals)>0){

if(cptype=='percentage'){

coupdisc=parseFloat(billtot)*(parseFloat(cpvals)/100);
                            netamount=parseFloat(billtot)-parseFloat(coupdisc);

}else{

netamount=parseFloat(billtot)-parseFloat(cpvals);  
                              coupdisc=cpvals;

}

document.getElementById('coup_disc').value=coupdisc;
                    document.getElementById('totbillamt').value=Math.round(billtot);
                    document.getElementById('txtnet').value=Math.round(netamount);
                    document.getElementById('totbillpaid').value=Math.round(netamount);
                    document.getElementById('totbilldue').value=0;

}

function actsubmit(){

document.getElementById('submitbtn').disabled=false;

}

</script>
<script type="text/javascript">
window.addEventListener('keydown',function(e){if(e.keyIdentifier=='U+000A'||e.keyIdentifier=='Enter'||e.keyCode==13){if(e.target.nodeName=='INPUT'&&e.target.type=='text'){e.preventDefault();return false;}}},true);
</script>
                <?php  include "ajax.php"; ?>

<div class="page-wrapper">
            
            
            
            <div class="page-breadcrumb">
                <div class="row">
                    <div class="col-12 d-flex no-block align-items-center">
                        <h4 class="page-title">Sales</h4>
                        <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Sales</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            
            
            
            
            
            
           <script>
function showResult(str) {
  if (str.length==0) { 
    document.getElementById("livesearch").innerHTML="";
    document.getElementById("livesearch").style.border="0px";
    return;
  }
  if (window.XMLHttpRequest) {
    // code for IE7+, Firefox, Chrome, Opera, Safari
    xmlhttp=new XMLHttpRequest();
  } else {  // code for IE6, IE5
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
  xmlhttp.onreadystatechange=function() {
    if (this.readyState==4 && this.status==200) {
      document.getElementById("livesearch").innerHTML=this.responseText;
      document.getElementById("livesearch").style.border="1px solid #A5ACB2";
    }
  }
  xmlhttp.open("GET","search.php?q="+str,true);
  xmlhttp.send();
}
</script>

<div class="container-fluid">
                
                
                
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
<form class="form-horizontal" id="noenter" action="sale.php?<?php if($action=='edit'){?>action=update&id=<?php echo $insid?><?}else{ ?>action=save<?php } ?>" method="POST">
                                <input type="hidden" name="rowcnt" id="rowcnt" value="0">
                                <input type="hidden" name="srowcnt" id="srowcnt" value="0">
                                <div class="card-body">
                                <div class="form-group row">
                                <div class="col-lg-8">       
                                    <div class="form-group row">
                                        <div class="col-sm-3">
                                            <label>Bill No</label>
                                            <input type="text" class="newfrm" autocomplete="false" autosave="false" name="billno" id="billno" placeholder="Bill No" value="<?php if($action!='edit'){ echo $billno; }else{ echo $edit['bill_no']; }?>">
                                           
                                        </div>
                                        <div class="col-sm-3">
                                            <label>Bill Date</label>
                                            <input type="date" class="newfrm" name="billdate" id="billdate" placeholder="Bill Date" value="<?php if($action!='edit'){ echo date("Y-m-d"); }else{ echo $edit['bill_date']; }?>">
                                           
                                        </div>
                                        
                                        
                                        <div class="col-sm-3">
                                            <input type="hidden" id="iscustnew" name="iscustnew" value="1">
                                            <label>Customer Name   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" id="chknewc" <?php if($action=='edit'){?> checked="false"<?}else{ ?>checked="true" <?php } ?> onclick="checknew('iscustnew','chknewc')"> New </label>
                                            <div id="newcust" <?php if($action=='edit'){ ?>style="visibility: hidden;"<?}else{ ?>   style="visibility: visible;"<? } ?>>
                                                <input type="text" class="newfrm" name="typeahead" autocomplete="off" >

</div>
                                            <div id="oldcust"  style="<?php if($action=='edit'){ ?>visibility: visible;<?}else{ ?>visibility: hidden;<? } ?> margin-top: -23px;">
                                            <select class="newfrm" id="cid" name="cid" onchange="getsalecustomerdetails(this.value)">
                                                <?$cq=mysqli_query($con,"SELECT * FROM db_customer order by cust_name");
                                                while($arrc=mysqli_fetch_array($cq)){?>
                                                <option value="<?php echo $arrc['id']?>" id="<?php echo $arrc['id']?>" <?phpif ($edit['cid']==$arrc['id']) {?> selected <?}?>><?php echo $arrc['cust_name']?></option>
                                                <?}?>
                                            </select>
                                            </div>
                                           
                                        </div>
                                        <div class="col-sm-3">
                                            <label>Mobile No.</label>
                                            <input type="text" class="newfrm" name="mobno" id="mobno" placeholder="Mobile No.">
                                           
                                        </div>
                                        
                                        <div class="col-sm-8">
                                            <label>Address</label>
                                            <textarea class="newfrm" name="addr" id="addr" rows="5" placeholder="Address"></textarea>
                                           
                                        </div>
                                        <div class="col-sm-3">
                                            <label>Customer Payment Terms</label>
                                            <select class="newfrm" name="cpt" id="cpt" placeholder="Job Sheet">
                                                   <option value="spot">Spot</option>
                                                   <option value="spot">Weekly</option>
                                                   <option value="spot">Monthly</option>
                                                   
                                                  
                                                
                                            </select>

<label>Alt No</label>
                                            <input type="text" class="newfrm" name="altno" id="altno" placeholder="Alternate No" value="<?php echo $edit['altno']?>">
                                           
                                        </div>
                                        <div class="col-sm-2" style="color:white;font-size: 12px;padding-top: 10px;">
                                             <input type="hidden" id="gstnavil">
                                            <input type="checkbox" name="gstnavail" id="gstnavail_chk" onclick="checkclick('gstnavil','gstnavail_chk')"> GSTN AVAILABLE?
                                        </div>
                                      
                                        <div class="col-sm-3">
                                            
                                            <label>GSTN</label>
                                            <input type="text" class="newfrm" name="gstn" id="gstn"
                                            placeholder="GSTN">
                                           
                                        </div>
                                        
                                        <div class="col-sm-3">
                                            <label>Job Sheet</label>
                                            <input list="jbst" name="browser" class="newfrm" onblur="getjobsheet(this.value)">
                                            <datalist class="datalist" name="jbst" id="jbst" >

<?php
                                                    $jq=mysqli_query($con,"SELECT * FROM db_jobsheet ORDER BY j_id DESC");
                                                    while($arrc=mysqli_fetch_array($jq)){

?>
                                                    <option value="<?php echo $arrc['j_no']?>"><?php echo $arrc['j_no']?></option>

<?php } ?>

</datalist>
                                            <small style="color:white;"><span id="jobdata"></span></small>
                                            <!-- <select class="newfrm" name="jbst" id="jbst" placeholder="Job Sheet" onchange="getjobsheet(this.value)">
                                                   <option>Choose job Sheet</option>
                                                   <?php
                                                    $jq=mysqli_query($con,"SELECT * FROM db_jobsheet ORDER BY j_id DESC");
                                                    while($arrc=mysqli_fetch_array($jq)){

?>
                                                    <option value="<?php echo $arrc['j_no']?>"><?php echo $arrc['j_no']?></option>

<?php } ?>
                                                
                                            </select> -->
                                           
                                        </div>
                                         <div class="col-sm-3" style="color: white;font-size: 11px; padding-top: 30px; text-align: left;">
                                                        
                                            <input type="hidden" id="osc" value="0">
                                            <input type="checkbox" name="osc" id="osc_chk" onclick="checkclick('osc','osc_chk')"> Other State Customer<br>
                                             <input type="hidden" id="wotax" value="1">
                                            <input type="checkbox" name="wotax" id="wotax_chk" checked="true" onclick="checkclick('wotax','wotax_chk')"> With/Without Tax<br>
                                            <input type="hidden" id="upstock" value="0">
                                            <input type="checkbox" name="upstock" id="upstock_chk" onclick="checkclick('upstock','upstock_chk')"> Update Stock
                                           
                                           
                                        </div>
                                         
                                         <div class="col-sm-3" style="padding-top: 20px;">
                                            
                                         </div>

</div>
                                </div>  
                                  <div class="col-lg-4">
                                    <div class="col-sm-12">
                                            <label>Product</label>
                                            <select class="newfrm" name="prod" id="prod" >
                                                <?php
                                                    $makeq=mysqli_query($con,"SELECT * FROM db_product ORDER BY p_name");
                                                    while($arrmake=mysqli_fetch_array($makeq)){
                                                ?>
                                                    <option value="<?php echo $arrmake['p_id']?>"><?php echo $arrmake['p_name']?></option>

<?php } ?>
                                            </select>
                                           
                                        </div>
                                        <div class="col-sm-12">
                                            <label>Serial / IMEI</label>
                                            <input type="text" class="newfrm" name="imei" id="imei" placeholder="Serial / IMEI">
                                           
                                        </div>
                                        <div class="col-sm-12">
                                            <label>Model</label>
                                            <input type="text" class="newfrm" name="model" id="model" placeholder="Model">
                                           
                                        </div>

<div class="col-sm-12">
                                            <label>JOBSHEET</label>
                                            <input type="text" class="newfrm" name="jst" id="jst" placeholder="JOBSHEET">
                                           
                                        </div>

</div>
                                  <hr>
                                <div class="form-group row">
                                  <div class="col-lg-12 border-top">
                                            <div class="form-group row">
                                                <div class="col-sm-2">
                                                    <label>Barcode</label>
                                                    <input type="text" name="barcode" id="barcode" class="newfrm" placeholder="Barcode">
                                                       
                                                </div>
                                                <div class="col-sm-2">
                                                    <label>Parts Name</label>
                                                    <!-- <select class="newfrm select2" name="partnm" id="partnm"  onchange="getsaleproddetails(this.value)">
                                                           <option>Choose Parts</option>
                                                    <?php
                                                        $makeq=mysqli_query($con,"SELECT * FROM db_items ORDER BY p_name");
                                                        while($arrmake=mysqli_fetch_array($makeq)){
                                                    ?>
                                                        <option value="<?php echo $arrmake['id']?>"><?php echo $arrmake['p_name']?></option>

<?php } ?>
                                                    </select> -->
                                                    <input type="text" class="newfrm" name="partnm" id="partnm" list="partslist" onblur="getsaleproddetails(this.value)">

<datalist id="partslist">
                                                              <option value="Choose Parts">Choose Parts</option>
                                                              <?php
                                                        $makeq=mysqli_query($con,"SELECT * FROM db_items ORDER BY p_name");
                                                        while($arrmake=mysqli_fetch_array($makeq)){
                                                    ?>
                                                        <option value="<?php echo $arrmake['p_name']?>"></option>

<?php } ?>
                                                     </datalist>

<input type="hidden" id="pname" value="">
                                                    <input type="hidden" id="pidh" value="">
                                                       
                                                </div>
                                                <div class="col-sm-2">
                                                    <label>Category Name</label>
                                                    <select class="newfrm" name="catnm" id="catnm" onchange="getcatname(this.value)">
                                                        <option>Choose Category</option>
                                                        <option value="copy">COPY</option>
                                                        <option value="og">OG</option>
                                                        <!-- <?php
                                                            $makeq=mysqli_query($con,"SELECT * FROM db_types ORDER BY type_name");
                                                            while($arrmake=mysqli_fetch_array($makeq)){
                                                        ?>
                                                            <option value="<?php echo $arrmake['id']?>"><?php echo $arrmake['type_name']?></option>

<?php } ?> -->
                                                        
                                                    </select>

<div class="col-sm-4">
                                                    <label>Description</label>
                                                    <textarea class="newfrm" name="desc" id="desc" placeholder="Description">SN:-</textarea>
                                                       
                                                </div>
                                                <div class="col-sm-4">
                                                    <label>Warranty</label>
                                                    <textarea class="newfrm" name="warr" id="warr" placeholder="Warranty Details"></textarea>
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Batch No.</label>
                                                        <div id="batchdiv">
                                                        <select class="newfrm" name="batch" id="batch">
                                                            <option></option>
                                                        </select>
                                                        </div>
                                                       
                                                </div>

<div class="col-sm-2">
                                                    <label>Available</label>
                                                    <input type="text" class="newfrm" name="avail" id="avail">
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Quantity</label>
                                                        <input type="text" class="newfrm" name="pqunt" id="pqunt" placeholder="Quantity">
                                                       
                                                </div>

<div class="col-sm-2">
                                                    <label>Unit</label>
                                                    <select class="newfrm" name="unit" id="unit">
                                                        <?php
                                                            $makeq=mysqli_query($con,"SELECT * FROM db_unit ORDER BY unitname");
                                                            while($arrmake=mysqli_fetch_array($makeq)){
                                                        ?>
                                                            <option value="<?php echo $arrmake['id']?>" <?php if($arrmake['unitname']=='PCS'){?> selected <?php } ?>><?php echo $arrmake['unitname']?></option>

<?php } ?>
                                                </select>
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Price</label>
                                                        <input type="text" class="newfrm" name="pprice" id="pprice" placeholder="Price" onblur="calsub()">
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Sub Total</label>
                                                        <input type="text" class="newfrm" name="pstotal" id="pstotal" placeholder="Sub Total">
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Discount</label>
                                                        <input type="text" class="newfrm" name="disc" id="disc" placeholder="Discount" value="0">

</div>

<div class="col-sm-2">
                                                        <label>Discount Type</label>
                                                        <select class="newfrm" name="disctype" id="disctype" onblur="caldiscp()">
                                                            <option value="%">%</option>
                                                            <option value="Rs">Rs.</option>
                                                        </select>
                                                       <input type="hidden" id="discamt" name="discamt" value="0">
                                                </div>

</div>

<div class="col-sm-2">
                                                        <label>Tax Amount</label>
                                                        <input type="text" class="newfrm" name="taxamt" id="taxamt" placeholder="Tax Amount">
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Total</label>
                                                        <input type="text" class="newfrm" name="total" id="total" placeholder="Total">
                                                       
                                                </div>

</div>

</div>
                              </div>
                                  <!-- <div class="col-lg-12">
                                        <div class="form-group row">
                                            <div class="col-lg-11" style="color: white;"></div>
                                            <div class="col-1" style="padding-top: 4%;">
                                                <a href="javascript:void" class="btn btn-danger" onClick="addtablerow()"><i class="fa fa-plus"></i></a>

</div>

</div> -->

</div>
                              <div class="form-group row" style="background-color:#e6efef;overflow-y:  scroll;overflow-x: scroll;min-height: 100px;">
                                    <table id="purtable">
                                        <tr>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Barcode</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Parts Name</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Category Name</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">HSN</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Description</label></th> 
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Warranty</label></th> 
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Batch No.</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Available</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Quantity</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Unit</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Price</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Sub Total</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Discount</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Discount Amount</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">GST</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Tax Amount</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Total</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label"><i class="fa fa-minus"></i></label></th>
                                        </tr>

</table>
                                    
                                        
                                        
                                    </div>
                                    <table>
                                        <tr>
                                            <td class="tdclass"></td>
                                            <td  class="tdclass"></td>
                                            <td  class="tdclass"></td>
                                            <td  class="tdclass"></td>
                                            <td  class="tdclass" style="text-align: right;font-size: 10px;"><b>PARTS TOTAL : </b></td>
                                            
                                            <td  class="tdclass" style="font-size: 10px;"><input type="text" name="p_totamt" id="grandtot" value="0" style="text-align: right;"></td>
                                            <td></td>
                                        </tr>

</table>
                                    <hr>
                                  <div class="col-lg-12 border-top">
                                            <div class="form-group row">
                                        
                                                <div class="col-sm-3">
                                                       <label>Service Name</label>
                                                    <select class="newfrm" name="srvname" id="srvname"  onchange="getsaleservdetails(this.value)">
                                                           <option>Choose Service</option>
                                                    <?php
                                                        $makeq=mysqli_query($con,"SELECT * FROM db_service ORDER BY s_name");
                                                        while($arrmake=mysqli_fetch_array($makeq)){
                                                    ?>
                                                        <option value="<?php echo $arrmake['s_id']?>"><?php echo $arrmake['s_name']?></option>

<?php } ?>
                                                    </select>
                                                    <input type="hidden" id="srvnames" value="">
                                                       
                                                </div>
                                        
                                                <div class="col-sm-1">
                                                        <label>Code</label>
                                                        <input type="text" class="newfrm" name="code" id="code" placeholder="Code">
                                                       
                                                </div>

<div class="col-sm-1">
                                                        <label>Price</label>
                                                        <input type="text" class="newfrm" name="prc" id="prc" placeholder="Price">
                                                       
                                                </div>

<div class="col-sm-1">
                                                        <label>Discount</label>
                                                        <input type="text" class="newfrm" name="sdiscount" id="sdiscount" placeholder="Discount" value="0" onblur="srvdisc()">
                                                       
                                                </div>

<div class="col-sm-1">
                                                        <label>Sub Total</label>
                                                        <input type="text" class="newfrm" name="subtot" id="subtot" placeholder="Sub Total">
                                                       
                                                </div>

<div class="col-sm-2">
                                                        <label>Total</label>
                                                        <input type="text" class="newfrm" name="srtotal" id="srtotal" placeholder="Total">
                                                       
                                                </div>

</div>

</div>
                                  <div class="form-group row" style="background-color:#e6efef;overflow-y:  scroll;overflow-x: scroll;min-height: 100px;">
                                    <table id="sertable">
                                        <tr>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Service Name</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Code</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Price</label></th>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Discount</label></th>
                                        <th> <label for="fname" class="col-sm-12 control-label col-form-label">Sub Total</label></th> 
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label">GST</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label">Tax Amount</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label">Total</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label"><i class="fa fa-minus"></i></label></th>
                                        </tr>

</table>
                                    
                                        
                                        
                                    </div>
                                    <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>SERVICE TOTAL : </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="s_totamt" id="sgrandtot" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                    <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>GRAND TOTAL : </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="totbillamt" id="totbillamt" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"> <select id="choosecoupon" name="choosecoupon" onchange="getcoupdet(this.value)" onblur="getcoupdet(this.value)" style="width: 55%;">
                                                    <option>Choose Coupon</option>
                                                    <?php
                                                        $cpsql=mysqli_query($con,"SELECT * FROM db_coupon");
                                                        while($arrcp=mysqli_fetch_array($cpsql)){
                                                    ?>
                                                        <option value="<?php echo $arrcp['id']?>" id="cp<?php echo $arrcp['id']?>"><?php echo $arrcp['name']?></option>

<?php } ?>
                                                </select>
                                                
                                            </td>
                                            
                                        </tr>

</table>
                                    <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>COUPON:(<span id="ccode"></span>)<input type="hidden" id="cptype" name="cptype" value="0"> </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="txtcoupon" id="txtcoupon" value="0" style="text-align: right;">
                                                <input type="hidden" id="cpname" name="cpname" value="0">
                                            <input type="hidden" id="cpvals" name="cpvals" value="0">
                                            <input type="hidden" id="coup_disc" name="coup_disc" value="0">
                                            </td>
                                            
                                        </tr>

</table>
                                    <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>NET AMOUNT:</b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="txtnet" id="txtnet" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                     <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>ADVANCE PAID : </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="totadvance" id="totadvance" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                     <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>AMOUNT PAYABLE : </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="totdueamt" id="totdueamt" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                     <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>AMOUNT PAID : </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="totbillpaid" id="totbillpaid" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                    <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>PAYMENT MODE : </b></td>
                                            
                                            <td style="width: 25%;">
                                                    <select name="paymode" style="width: 45%;font-size: 10px;">
                                                         <option value="cash">CASH</option>
                                                        <option value="card">CARD</option>
                                                       
                                                        <option value="paytm">PAYTM</option>
                                                        <option value="upi">UPI</option>

</select>

</td>
                                            
                                        </tr>

</table>
                                      <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>#MEMO: </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="pay_det" id="pay_det" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                      <table style="width: 100%;">
                                        <tr style="width: 100%;">
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;"></td>
                                            <td style="width: 25%;font-size: 10px;text-align: right;"><b>AMOUNT DUE: </b></td>
                                            
                                            <td style="width: 25%;font-size: 10px;"><input type="text" name="totbilldue" id="totbilldue" value="0" style="text-align: right;"></td>
                                            
                                        </tr>

</table>
                                </div>
                                <div class="border-top">
                                    <div class="card-body">
                                        <button type="submit" id="submitbtn" class="btn btn-primary">Submit</button>
                                    </div>
                                </div>
                            </form>
                        </div>

</div>
                    
                   
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

<?php  include "footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sale_olds.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation