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

<?php  include "header.php"; 
    // if($compid==''){

// header("Location:company.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['bigapple'];
    $p_frcharge=$_POST['p_frcharge'];
    $p_netamt=$_POST['p_totamt'];
    $itype=$_SESSION['cavinmilkshake'];

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

$prodid=$_POST['prodid'.$i];
            $getprodid=f(q("SELECT * FROM db_items WHERE id='$getprodid'"));
            $prodname=$_POST['prodname'.$i];

$unit=$_POST['quanunit'.$i];
           
            $getunit=f(q("SELECT * FROM db_unit WHERE unitname='$unit'"));
            $unitid=$getunit['id'];

$quanquan=$_POST['quanquan'.$i];

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 stock_dt SET item_code='$prodid',item_name='$prodname',item_type='$itype',quantity='$quanquan',rate='0',amount='0',date1='$p_bdate',opening='0',remarks='STOCK IN',status='$p_user',purchase_id='0',item_id='$prodid',unit_type='$unit',bill_no='$p_bill',dispatch_id='0',returned_id='0',ab_loss_id='0',notax=0");
                        
                        
                   // }
            
             }

}

//}

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

?>
<script type="text/javascript" src="ajax.js"></script>

        
        
        <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 Stock IN 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:14.24%;
                    }
                    .input{

width: 100%;
                    }

input[type="text"]:focus { 
    
    border: 2px solid red;   
    }
    
    select:focus{

border: 2px solid red;  
    }
    .select2-selection:focus{
        border: 1px solid red;

}

</style>
                <script>
                    function addtablerow(){
                        var table = document.getElementById("purtable");
                        var prodid=document.getElementById('prodid').value;
                         var prodname=document.getElementById('itemname').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','hidden'); // set attributes ...
                            txtprodid.setAttribute('name','prodid'+cnt);
                            txtprodid.setAttribute('value',prodid);  //document.createTextNode(prodid);

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

var txtquan = document.createElement('input'); 
                            txtquan.setAttribute('type','text'); // set attributes ...
                            txtprodname.setAttribute('class','input');
                            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','hidden'); // set attributes ...
                            txtprice.setAttribute('name','price'+cnt);
                            txtprice.setAttribute('value',price);  //document.createTextNode(price);

var txttotal = document.createElement('input'); 
                            txttotal.setAttribute('type','hidden'); // 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);
                            tdprodid.appendChild(txtprodname);
                            tdquan.appendChild(txtquan);
                            tdquan.appendChild(txtquanunit);
                            tdquan.appendChild(txtquanquan);
                            tdquan.appendChild(txtprice);
                            // tdgst.appendChild(txtgst);
                            // tdtax.appendChild(txttax);
                            tdquan.appendChild(txttotal);
                            tddelete.appendChild(butt);

tr.appendChild(tdprodid);
                            tr.appendChild(tdquan);
                           
                            tr.appendChild(tddelete);

table.appendChild(tr);

document.getElementById('prodid').focus();
                                  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');

}
                    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=gstamt;
                       var totamt=parseFloat(netamt);//+parseFloat(gstamt);
                       document.getElementById('total').value=totamt;
                        }

<?php } ?>                 
                                            </select>
                                            <input type="hidden" id="itemid" value="">
                                            <input type="hidden" id="itemname" value="">
                                        </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="form-control" name="products" style="font-size:10px;" id="produnnit">
                                                <?php
                                                    $getprod=mysqli_query($con,"SELECT * FROM db_unit");
                                                        while($arrprod=mysqli_fetch_array($getprod)){
                                                
                                                ?>
                                                            <option value="<?php echo $arrprod['unitname']?>" <?php  if($arrprod['unitname']=='PCS'){?> selected<?php  }?>><?php echo $arrprod['unitname']?></option>

<?php } ?>                 
                                            </select>

</div>
                                        <div class="col-sm-1">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label"></label>
                                            <input type="hidden" class="form-control" id="price" style="font-size:10px;" name="price" placeholder="" onChange="CalculateRow()" value="0">
                                        </div>
                                        
                                        <div class="col-sm-1">
                                            <label for="fname" class="col-sm-12 text-right control-label col-form-label"></label>
                                            <input type="hidden" class="form-control" id="total" name="total" placeholder="" value="0">
                                        </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"><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="hidden" name="price<?php echo $i?>" value="<?php echo $arrdets['pd_price']?>"><input type="hidden" name="total<?php echo $i?>" value="<?php echo $arrdets['pd_total']?>"><input type="button" name="javaSubmit" value="remove"><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>
                                        
                                        
                                    </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: stockin.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation