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: purchases.php

<?php  include "header.php";

$action=$_REQUEST['action'];
if($action=='save'){
    $p_bill=$_POST['p_bill'];
    $p_bdate=$_POST['p_bdate'];
    $p_prov_id=$_POST['p_prov_id'];
    $p_totton=$_POST['p_totamt'];
    $p_comp=$compid;
    $p_user=$_SESSION['matrix_id'];
    $p_frcharge=$_POST['p_frcharge'];
    $p_netamt=$_POST['p_totamt'];

//echo "INSERT INTO `tbl_Retail Storess` SET `prod_name`='$cname',`prod_catid`=0,`prod_mid`='$prod_mid',`prod_tid`='$prod_tid',`prod_date`='$prod_date',`prod_main`='$prod_main',`prod_sub`='$prod_sub',`prod_mquan`='$prod_mquan',`prod_squan`='$prod_squan',`prod_mscount`='$prod_mscount',`prod_comp`='$prod_comp',`prod_act`='$prod_act',`prod_user`='$prod_user'";

$res=mysqli_query($con,"INSERT INTO `tbl_purchase` SET `p_bill`='$p_bill',`p_bdate`='$p_bdate',`p_prov_id`='$p_prov_id',`p_totamt`='$p_totamt',`p_comp`='$p_comp',`p_desc`='',`p_user`='$p_user',`p_totton`='$p_totton',`p_frcharge`='$p_frcharge',`p_frate`='0',`p_netamt`='$p_netamt'");
$resq=f(q("SELECT MAX(p_id) as pid  FROM tbl_purchase"));

if($res){

$rowcnt=$_POST['rowcnt'];
    for($i=1;$i<=$rowcnt;$i++){

$prodname=$_POST['prodname'.$i];
            $getprodid=f(q("SELECT * FROM tbl_products WHERE prod_name='$prodname'"));
            $prod_mscount=$getprodid['prod_mscount'];

$unit=$_POST['quanunit'.$i];
           
            $getunit=f(q("SELECT * FROM tbl_unit WHERE u_name='$unit'"));
            $unitid=$getunit['u_id'];

$quanquan=$_POST['quanquan'.$i];
            $price=$_POST['price'.$i];
            $gst=$_POST['gst'.$i];
            $tax=$_POST['tax'.$i];
            $total=$_POST['total'.$i];

if($prod_mscount!='0'){

$prod_main=$getprodid['prod_main'];
                $prod_sub=$getprodid['prod_sub'];
               //echo "--->".$unitid." SUB : ".$prod_main;
                if($unitid==$prod_main){

$stockquan=floatval($quanquan)*floatval($prod_mscount);
                    
    
                }elseif($unitid==$prod_sub){
                    $prod_main=$getprodid['prod_main'];
                $prod_sub=$getprodid['prod_sub'];
                    $stockquan=floatval($quanquan);

}

}else{
              //  echo "--->".$$quanquan;
              $prod_main=$getprodid['prod_main'];
                $prod_sub=$getprodid['prod_sub'];
                $stockquan=floatval($quanquan);

}

if($quanquan>0){
                    $res1=mysqli_query($con,"INSERT INTO tbl_p_details SET pd_p_id='$resq[pid]',pd_prodid='$getprodid[prod_id]',pd_quan='$quanquan',pd_price='$price',pd_total='$total',pd_desc='Purchase Entry',pd_unit='$unitid',pd_gst='$gst',pd_gstval='$tax'");
                    if(!$res1){
                        echo mysql_error();
                        
                    }else{ 
                        
                    $stock=mysqli_query($con,"INSERT INTO tbl_stock SET stk_prod_id='$getprodid[prod_id]',stk_prod_name='$prodname',stk_quan='$stockquan',stk_munit='$prod_main',stk_sunit='$prod_sub',stk_trn_type='PURCHASE',stk_trn_date=CURDATE(),stk_trn_comp='$compid',stk_inv_id='$resq[pid]'")	;
                        
                        
                    }
            
             }

}

}elseif($action=='update'){
    $insid=$_REQUEST['id'];
    $ag_name=$_POST['ag_name'];
$ag_phone=$_POST['ag_phone'];
$ag_email=$_POST['ag_email'];
$ag_address=$_POST['ag_address'];
$ag_pan=$_POST['ag_pan'];
$ag_adhaar=$_POST['ag_adhaar'];
$ag_voter=$_POST['ag_voter'];
$ag_bankac=$_POST['ag_bankac'];
$ag_bankname=$_POST['ag_bankname'];
$ag_ifsc=$_POST['ag_ifsc'];
$ag_acname=$_POST['ag_acname'];
$ag_branch=$_POST['ag_branch'];
$ag_area=$_POST['ag_area'];
$ag_join=$_POST['ag_join'];
$ag_comp=$compid;
$ag_user=$_SESSION['matrix_id'];

$res=mysqli_query($con,"UPDATE `tbl_stores` SET `ag_name`='$ag_name',`ag_phone`='$ag_phone',`ag_email`='$ag_email',`ag_address`='$ag_address',`ag_pan`='$ag_address',`ag_adhaar`='$ag_adhaar',`ag_voter`='$ag_voter',`ag_bankac`='$ag_bankac',`ag_bankname`='$ag_bankname',`ag_ifsc`='$ag_ifsc',`ag_acname`='$ag_acname',`ag_branch`='$ag_branch',`ag_area`='$ag_area',`ag_join`='$ag_join',`ag_comp`='$ag_comp',`ag_user`='$ag_user' WHERE ag_id='$insid'");

}elseif($action=='edit'){
    $insid=$_REQUEST['cid'];
    $edit=f(q("SELECT * FROM tbl_purchase WHERE p_id='$insid'"));

}elseif($action=='delete'){
    
    $insid=$_REQUEST['cid'];
    $res=mysqli_query($con,"DELETE FROM tbl_purchase  WHERE p_id='$insid'");
$detq=mysqli_query($con," DELETE FROM tbl_p_details WHERE pd_p_id='$insid'");
$stq=mysqli_query($con,"DELETE FROM tbl_stock WHERE stk_inv_id='$insid'  AND stk_trn_type='PURCHASE'");
}

?>

        
        
        <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">Add Purchse Entry</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">Retail Stores</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            
            
            
            
            
            
            <div class="container-fluid">
                
                
                
                <style>
                    th{
                        width:16%;
                        text-align:center;
                    }
                    table{
                        width:100%;
                    }
                    tr{
                        width:100%;
                        background-color:white;
                    }
                    td{
                        text-align:center;
                    }
                    .tdclass{

width:19%;
                    }

</style>
                <script>
                    function addtablerow(){
                        var table = document.getElementById("purtable");
                        var prodid=document.getElementById('prodid').value;
                        var quan=document.getElementById('quan').value;
                        var price=document.getElementById('price').value;
                        var gst=document.getElementById('gst').value;
                        var tax=document.getElementById('tax').value;
                        var total=document.getElementById('total').value;
                        var cnt=document.getElementById('rowcnt').value;
                        var produnnit=document.getElementById('produnnit').value;
                        if(cnt==0){
                            cnt=parseFloat(cnt)+1;
                        }else{
                            cnt=parseFloat(cnt)+1;
                        }
                        document.getElementById('rowcnt').value=cnt;

var tr = document.createElement("tr");
                            var tdprodid = document.createElement("td");
                            var tdquan = document.createElement("td");
                            var tdprice = document.createElement("td");
                            var tdgst = document.createElement("td");
                            var tdtax = document.createElement("td");
                            var tdtotal = document.createElement("td");
                            var tddelete = document.createElement("td");
                           
                            var txtprodid =document.createElement('input'); 
                            txtprodid.setAttribute('type','text'); // set attributes ...
                            txtprodid.setAttribute('name','prodname'+cnt);
                            txtprodid.setAttribute('value',prodid);  //document.createTextNode(prodid);

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

var txtquanunit = document.createElement('input'); 
                            txtquanunit.setAttribute('type','hidden'); // set attributes ...
                            txtquanunit.setAttribute('name','quanunit'+cnt);
                            txtquanunit.setAttribute('value',produnnit);  //document.createTextNode(quan);

var txtquanquan = document.createElement('input'); 
                            txtquanquan.setAttribute('type','hidden'); // set attributes ...
                            txtquanquan.setAttribute('name','quanquan'+cnt);
                            txtquanquan.setAttribute('value',quan);  //document.createTextNode(quan);

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

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

var txttax = document.createElement('input'); 
                            txttax.setAttribute('type','text'); // set attributes ...
                            txttax.setAttribute('name','tax'+cnt);
                            txttax.setAttribute('id','tax'+cnt);
                            txttax.setAttribute('value',tax);  //document.createTextNode(tax);

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

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);
								  
								}

tdprodid.appendChild(txtprodid);
                            tdquan.appendChild(txtquan);
                            tdquan.appendChild(txtquanunit);
                            tdquan.appendChild(txtquanquan);
                            tdprice.appendChild(txtprice);
                            tdgst.appendChild(txtgst);
                            tdtax.appendChild(txttax);
                            tdtotal.appendChild(txttotal);
                            tddelete.appendChild(butt);

tr.appendChild(tdprodid);
                            tr.appendChild(tdquan);
                            tr.appendChild(tdprice);
                            tr.appendChild(tdgst);
                            tr.appendChild(tdtax);
                            tr.appendChild(tdtotal);
                            tr.appendChild(tddelete);

table.appendChild(tr);

var gtot=0;
                                var txtoto=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;
                                    document.getElementById('taxtot').value=txtoto;
                                   /// calculateRowtot('purtable');
                                   document.getElementById("prodid").focus();

}
                    function deleteRow(btn) {
                        var row = btn.parentNode.parentNode;
                        row.parentNode.removeChild(row);
                        var cnt=document.getElementById('rowcnt').value;
                        //cnt=parseFloat(cnt)-1;    
                        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;
                                    document.getElementById('taxtot').value=txtoto;
                        }
                    function CalculateRow() {
                        var gst=document.getElementById('gst').value;
                        var quan=document.getElementById('quan').value;
                        var price=document.getElementById('price').value;
                       var netamt=parseFloat(quan)*parseFloat(price);
                      // alert(netamt);
                       var gstamt=parseFloat(netamt)*(parseFloat(gst)/100);
                       document.getElementById('tax').value=Math.round(gstamt,2);
                       var totamt=parseFloat(netamt)+parseFloat(gstamt);
                       document.getElementById('total').value=totamt;
                        }

<?php } ?>                 
                                            </select>
                                        </div>
                                        <div class="col-sm-1">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">Quan</label>
                                            <input type="text" class="form-control" id="quan" name="quan" placeholder="" value="">

</div>
                                        <div class="col-sm-2">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">Unit</label>
                                            <select class="select2 form-control custom-select" name="products" style="font-size:10px;" id="produnnit">
                                                <?php
                                                    $getprod=mysqli_query($con,"SELECT * FROM tbl_unit");
                                                        while($arrprod=mysqli_fetch_array($getprod)){
                                                
                                                ?>
                                                            <option value="<?php echo $arrprod['u_name']?>"><?php echo $arrprod['u_name']?></option>

<?php } ?>                 
                                            </select>

</div>
                                        <div class="col-sm-1">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">Price</label>
                                            <input type="text" class="form-control" id="price" style="font-size:10px;" name="price" placeholder="" onChange="CalculateRow()" value="">
                                        </div>
                                        <div class="col-sm-1">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">GST</label>
                                            <select name="gst" id="gst" class="select2 form-control custom-select" style="font-size:10px;" onChange="CalculateRow()">
                                                <option value="5">5 %</option>
                                                <option value="12">12 %</option>
                                                <option value="18">18 %</option>
                                                <option value="28">28 %</option>

</select>
                                        </div>
                                        <div class="col-sm-2">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">Tax Amount</label>
                                            <input type="text" class="form-control" id="tax" name="tax" placeholder="" value="">
                                        </div>
                                        <div class="col-sm-2">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label">Total Amount</label>
                                            <input type="text" class="form-control" id="total" name="total" placeholder="" value="">
                                        </div>
                                        <div class="col-sm-1">
                                        <label for="fname" class="col-sm-12 text-right control-label col-form-label"></label>
                                            <button type="button" class="btn btn-primary" onClick="addtablerow()"><i class="fas fa-plus"></i></button>

</div>
                                    </div>
                                    <div class="form-group row">
                                        <hr>

</div>
                                    
                                    <div class="form-group row" style="background-color:#e6efef;">
                                    <table id="purtable">
                                        <tr>
                                        <th><label for="fname" class="col-sm-12 control-label col-form-label">Product Name</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">Price/ Quan</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 Amount</label></th>
                                        <th>  <label for="fname" class="col-sm-12 control-label col-form-label"><i class="fa fa-minus"></i></label></th>
                                        </tr>
                                        <?php if($action=='edit'){ 
                                                $i=1;
                                                $getprodet=mysqli_query($con,"SELECT * FROM tbl_p_details WHERE pd_p_id='$insid'");
                                                while($arrdets=mysqli_fetch_array($getprodet)){
                                                    $getprodname=f(q("SELECT * FROM tbl_products WHERE prod_id='$arrdets[pd_p_id]' "));
                                                    $getunit=f(q("SELECT * FROM tbl_units WHERE u_id='$arrdets[pd_unit]'"));
                                                     $unitname=$getunit['u_name'];
                                            ?>
                                            <tr>
                                                <td><input type="text" name="pd_p_id<?php echo $i?>" value="<?php echo $getprodname['prod_name']?>"></td>
                                                <td><input type="text" name="quan<?php echo $i?>" value="<?php echo $arrdets['pd_quan']?> <?php echo $unitname?>">
                                                <input type="hidden" name="quanunit<?php echo $i?>" value="<?php echo $arrdets['pd_unit']?>">
                                                <input type="hidden" name="quanquan<?php echo $i?>" value="<?php echo $arrdets['pd_quan']?>">
                                            
                                            </td>
                                                <td><input type="text" name="price<?php echo $i?>" value="<?php echo $arrdets['pd_price']?>"></td>
                                                <td><input type="text" name="gst<?php echo $i?>" value="<?php echo $arrdets['pd_gst']?>"></td>
                                                <td><input type="text" name="tax<?php echo $i?>" value="<?php echo $arrdets['prod_name']?>"></td>
                                                <td><input type="text" name="total<?php echo $i?>" value="<?php echo $arrdets['pd_total']?>"></td>
                                                <td><input type="button" name="javaSubmit" value="remove"></td>
                                                <td><input type="text" name="pd_p_id<?php echo $i?>" value="<?php echo $getprodname['prod_name']?>" onClick="deleteRow(this)"></td>

</tr>   
                                                <?php $i=$i+1; } ?> 
                                        <?php } ?>

</table>
                                    <table>
                                        <tr>
                                            <td class="tdclass"></td>
                                            <td  class="tdclass"></td>
                                            <td  class="tdclass"><b>TOTAL : </b></td>
                                            
                                            <td  class="tdclass"><input type="text" name="p_totamt" id="grandtot" ></td>
                                            <td></td>
                                        </tr>

</table>
                                        
                                        
                                    </div>
                                    
                                   
                                   
                                    
                                </div>
                                <div class="border-top">
                                    <div class="card-body">
                                        <button type="submit" 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: purchases.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation