
<?php 
echo '
<script src="'.base_url().'new/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="'.base_url().'new/jquery.dataTables.min.css">

<link href="'.base_url().'new/select2.min.css" rel="stylesheet">
<script src="'.base_url().'new/select2.min.js"></script>';

$rs=$this->db->where('id',89)->get('scm_settings')->result();
foreach($rs as $row) { $title=$row->caption;} $var='var '.$fld[0].'=$("#'.$fld[0].'").val();';
$post=$fld[0].':'.$fld[0];for($a=1;$a<count($fld);$a++) {$var.='var '.$fld[$a].'=$("#'.$fld[$a].'").val();';$post.=','.$fld[$a].':'.$fld[$a];}

$uid=$_SESSION['user_id'];
$ur=$this->db->where('userid',$uid)->get('scm_user')->row('User_rights');
$loc=$this->db->where('userid',$uid)->get('scm_user')->row('Branch');
$bopt=$wopt='<option value=0 selected>Select all</option>';
$wopt.='<option value=1 >Manila</option>';
$wopt.='<option value=2 >Sauyo</option>';

if($ur==5) { $xloc=array(1=>'Manila',2=>'Sauyo');$wopt='<option value='.$loc.' selected>'.$xloc[$loc].'</option>';}

$sopt='';  $xx=explode(',','For Edit, Sample Approval, Waiting Completion,WIP, Finished, Partial');    
for($b=0;$b<count($xx);$b++) { $sel='';if($b==3){$sel='selected';} $sopt.='<option value='.$b.' '.$sel.'>'.strtoupper($xx[$b]).'</option>'; }

$cap=explode(',','
Type
,Branch
,Supplier/Subcon
,Payee
,Address
,Phone
,Date
,Ref#
,Cash Disbursement
,Print Voucher Angel
,Print Check
,Print Voucher
,Close
,Remarks/Explanation
,Prepared By
,Void Transaction
,Disbursement Summary
,Total Disbursement
,Total Applied
,Total Adjustment
,Un-Applied.Advance Payment
,Payment
,Close
');


$head1=' 
<div class="container-fluid">
<div class="row">


<div class="input-group mb-1 input-group-sm col-sm-3">
<input type="text" class="form-control" disabled value="'.$title.'"><input type="text" class="form-control" disabled id="fld0" /></div>

<div class="input-group mb-1 input-group-sm col-sm-1">
<select class="form-control" id="fld2"><option value=0>Subcon</option><option value=1 selected>Subsidiary</option></select></div> 

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[2].'</span></div>
<select class="form-control" id="fld4"></select></div> 

<div class="input-group mb-1 input-group-sm col-sm-4"><div class="input-group-prepend"><span class="input-group-text">'.$cap[3].'</span></div>
<input type="text" class="form-control" id="fld3"></div> 

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[4].'</span></div>
<input type="text" class="form-control" id="fld3"></div>

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[5].'</span></div>
<input type="text" class="form-control" id="fld3"></div> 

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[6].'</span></div>
<input type="date" class="form-control" id="fld3"></div> 

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[7].'</span></div>
<input type="text" class="form-control" id="fld3"></div> 

<div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">'.$cap[8].'</span></div>
<input type="number" class="form-control" id="fld3 disabled"></div> 

<div class="input-group mb-1 input-group-sm col-sm-4">
<input type="button" class="btn btn-outline-dark btn-sm" value="'.$cap[9].'" onclick="saveheader()"/>
<input type="button" class="btn btn-outline-dark btn-sm" value="'.$cap[10].'" onclick="saveheader()"/>
<input type="button" class="btn btn-outline-dark btn-sm" value="'.$cap[11].'" onclick="saveheader()"/>
<input type="button" class="btn btn-outline-dark btn-sm" value="'.$cap[12].'" onclick="saveheader()"/>
</div> 

<div class="input-group mb-1 input-group-sm col-sm-6"><div class="input-group-prepend"><span class="input-group-text">'.$cap[13].'</span></div>
<input type="number" class="form-control" id="fld3 disabled"></div> 

<div class="input-group mb-1 input-group-sm col-sm-3"><div class="input-group-prepend"><span class="input-group-text">'.$cap[14].'</span></div>
<input type="number" class="form-control" id="fld3 disabled"></div> 

<div class="input-group mb-1 input-group-sm col-sm-3"><div class="input-group-prepend"><span class="input-group-text">'.$cap[15].'</span></div>
<input type="number" class="form-control" id="fld3 disabled"></div> 


</div></div> ';

$head2='
<div class="container-fluid">
<div class="row">


<div class="input-group mb-1 input-group-sm"> <input type="text" class="form-control" value="'.$cap[16].'" disabled> </div> 

<div class="input-group mb-1 input-group-sm"><div class="input-group-prepend"><span class="input-group-text">'.$cap[17].'</span></div>
<input type="number" class="form-control" id="fld3" > </div>  

<div class="input-group mb-1 input-group-sm"><div class="input-group-prepend"><span class="input-group-text">'.$cap[18].'</span></div>
<input type="number" class="form-control" id="fld3" > </div>  

<div class="input-group mb-1 input-group-sm"><div class="input-group-prepend"><span class="input-group-text">'.$cap[19].'</span></div>
<input type="number" class="form-control" id="fld3" > </div>  

<div class="input-group mb-1 input-group-sm"><div class="input-group-prepend"><span class="input-group-text">'.$cap[20].'</span></div>
<input type="number" class="form-control" id="fld3" > </div>     


</div>

</div>';

$dtl1=' 
<div class="container-fluid">

        <ul class="nav nav-tabs">
        <li class="nav-item"> <a class="nav-link active" data-toggle="tab" href="#t1m1">Check Entry</a> </li>
        <li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#t1m2">Purchase Return</a> </li>
        <li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#t1m3">Offset Delivery Receipt</a> </li>
        
        </ul>
        
        <!-- Tab panes -->
        <div class="tab-content">
            
        <div class="tab-pane container-fluid active" id="t1m1">
        
        <div class="row" >
        
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">Bank</span></div>
            <select class="form-control" id="fld3" > </select></div>    
        
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">Date</span></div>
            <input type="date" class="form-control" id="fld3" value="'.date('Y-m-d').'" > </div>    
        
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">Cheque#</span></div>
            <input type="text" class="form-control" id="fld3" > </div>    
        
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">Amount</span></div>
            <input type="number" class="form-control" id="fld3" > </div>   
            
        <div class="input-group mb-1 input-group-sm col-sm-2">    
            <input type="button" class="btn btn-outline-dark btn-sm" value="Save" onclick="savecheck()"></div>   
            
        </div>   
        <table id="lt1m1" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>Date</th>
        <th>Bank</th>
        <th>Check No.</th>
        <th>Amount</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <td colspan=4 align="right"><b>Total Check Disbursement</th>
        <th>0</th>
        </tr>
        </tfoot>
        </table>
        
        </div>
            
        <div class="tab-pane container-fluid fade" id="t1m2">
        
        <div class="row" >
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">PR#</span></div>
            <select class="form-control" id="fld3" > </select></div>   
            
        <div class="input-group mb-1 input-group-sm col-sm-2">    
            <input type="button" class="btn btn-outline-dark btn-sm" value="Save" onclick="savecheck()"></div>   
            
        </div>    
            
        <table id="lt1m2" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>Date</th>
        <th>PR#</th>
        <th>Amount</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <td colspan=3 align="right"><b>Total Amount</td>
        <th>0</th>
        </tr>
        </tfoot>
        </table>
        
        </div>
        
        <div class="tab-pane container-fluid fade" id="t1m3">
        
        
        <div class="row" >
        <div class="input-group mb-1 input-group-sm col-sm-2"><div class="input-group-prepend"><span class="input-group-text">A/R#</span></div>
            <select class="form-control" id="fld3" > </select></div>   
            
        <div class="input-group mb-1 input-group-sm col-sm-2">    
            <input type="button" class="btn btn-outline-dark btn-sm" value="Save" onclick="savecheck()"></div>   
            
        </div>    
        
        <table id="lt1m3" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>Date</th>
        <th>A/R#</th>
        <th>Amount</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <td colspan=3 align="right"><b>TOTAL Amount</td>
        <th>0</th>
        </tr>
        </tfoot>
        </table> 
            
        </div> 
</div>'; 

$dtl2='
<div class="container-fluid">
<div class="row">
    <div class="col-sm-8">
        <ul class="nav nav-tabs">
        <li class="nav-item"> <a class="nav-link active" data-toggle="tab" href="#t2m1">Receiving Report</a> </li>
        <li class="nav-item"> <a class="nav-link" data-toggle="tab" href="#t2m2">G/L Entry</a> </li>
        </ul>
        
        <!-- Tab panes -->
        <div class="tab-content">
            
            <div class="tab-pane container-fluid active" id="t2m1"> 
        
        <div class="row" >
        <div class="input-group mb-1 input-group-sm col-sm-6"><div class="input-group-prepend"><span class="input-group-text">RR#</span></div>
            <select class="form-control" id="fld3" > </select></div>   
            
        <div class="input-group mb-1 input-group-sm col-sm-2">    
            <input type="button" class="btn btn-outline-dark btn-sm" value="Save" onclick="savecheck()"></div>   
            
        </div>
        
        <table id="lt2m1" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>RR#</th>
        <th>Date</th>
        <th>Total Due</th>
        <th>Prv. Payment</th>
        <th>Still Due</th>
        <th>Applied</th>
        <th>Adjustment</th>
        <th>Balance</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <th colspan=6>Total Applied To RR</th>
        <th>0</th>
        <th>0</th>
        <th></th>
        </tr>
        </tfoot>
        </table>
        
        </div>
            <div class="tab-pane container-fluid fade" id="t2m2">
            
        
        <div class="row" >
        <div class="input-group mb-1 input-group-sm col-sm-6"><div class="input-group-prepend"><span class="input-group-text">COA</span></div>
            <select class="form-control" id="fld3" > </select></div>   
            
        <div class="input-group mb-1 input-group-sm col-sm-2">    
            <input type="button" class="btn btn-outline-dark btn-sm" value="Save" onclick="savecheck()"></div>   
            
        </div>
        
        
        <table id="lt2m2" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>Code#</th>
        <th>Account Name</th>
        <th>Amount</th>
        
        </tr>
        </thead>
        
        <tfoot>
        <tr>
        <th colspan=3>Total Applied To Accounts</th>
        <th>0</th>
        </tr>
        </tfoot>
        
        </table>
        
        </div>
        
        <div class="tab-pane container-fluid fade" id="t2m3">
        
        <table id="lt2m2" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>Date#</th>
        <th>Bank</th>
        <th>Check #</th>
        <th>Amount</th>
        <th>Status</th>
        </tr>
        </thead>
        
        <tfoot>
        <tr>
        <th colspan=3>TOTAL Check Amount</th>
        <th>0</th>
        </tr>
        </tfoot>
        
        </table>
        
        </div>
        
        <div class="tab-pane container-fluid fade" id="t2m4"> 
        <br/>
        <div class="input-group mb-1 input-group-sm col-sm-4"><div class="input-group-prepend"><span class="input-group-text">Missing Charger</span></div>
        <input type="number" class="form-control" id="fld3"></div>
        
        <div class="input-group mb-1 input-group-sm col-sm-4"><div class="input-group-prepend"><span class="input-group-text">Cash Amount</span></div>
        <input type="number" class="form-control" id="fld3"></div>
        
        </div>
        
        <div class="tab-pane container-fluid fade" id="t2m5"> 
        
        <br/>
        <div class="input-group mb-1 input-group-sm col-sm-4"><div class="input-group-prepend"><span class="input-group-text">Customer</span></div>
        <select class="form-control" id="fld3"></select></div> 
        
        
        <table id="lt2m2" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>A/R#</th>
        <th>Date#</th>
        <th>Amount</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <th colspan=3>TOTAL A/R Sales Amount</th>
        <th>0</th>
        </tr>
        </tfoot>
        </table>
        
        
        </div>
        
        <div class="tab-pane container-fluid fade" id="t2m6"> 
        
        
        <table id="lt2m6" class="table">
        <thead>
        <tr>
        <th>#</th>
        <th>RS#</th>
        <th>Date#</th>
        <th>Amount</th>
        </tr>
        </thead>
        <tfoot>
        <tr>
        <th colspan=3>TOTAL RS Sales Amount</th>
        <th>0</th>
        </tr>
        </tfoot>
        </table>
        
        
        </div>
        
        </div>
        
    </div>
    <div class="col-sm-4">'.$head2.'</div>
</div>'; 

?>

<title><?=$title?></title>
<br />
<div class="container-fluid">

  
  <div id="xsearch" class="row"  >
    
<div class="input-group mb-1 input-group-sm col-xs-6 col-md-3">
<div class="input-group-prepend"> <span class="input-group-text"><?=$title?></span></div></div>
    

<input type="hidden" id="br" value=0 >
<input type="hidden" id="wh" value=1 >  
<input type="hidden" id="st" value=0 >   

<div class="input-group mb-1 input-group-sm col-xs-6 col-md-8"></div>
<div class="input-group mb-1 input-group-sm col-sm-1"> <input type="button" class="form-control " value="Add" onclick="addrec()"  > </div>  

</div>  
  
<div class="row" id="forms"></div>

<div class="row" id="form_entry">
<div class="container-fluid">
    
    <div class=card> <div class=card-header> <?=$head1?></div> </div
    
    <div class=card> <div class=card-body> <?=$dtl1?></div> </div
    
    <div class=card> <div class=card-body> <?=$dtl2?></div> </div 
</div>
    </div>
</div>
</div>

<script>

function  prints() 
    {
        var id=$("#id").val();
        if(confirm("Print this record?")==true) { var xurl="<?=base_url('89/dashboard/print/')?>" + id ; window.open(xurl); } }
        

function  prints2() 
    {
        var id=$("#id").val();
        if(confirm("Print this record?")==true) { var xurl="<?=base_url('89/dashboard/print2/')?>" + id ; window.open(xurl); } }

function savedtl()
{
    if(confirm("save this record?")==true)
    {
        var order=$("#e5").val(); var deliver=$("#e6").val();  var seq=$("#seq").val();
        
        if(seq==0){alert("invalid data");}
        else
        {
            if(order<deliver){alert("deliver qty is greater than order qty");}
            else
            {
                if(order==0){alert("deliver qty cannot be zero");}
                else
                {
                    var datas=[
                        $("#seq").val()
                        ,$("#e6").val()
                        ];
                        $.ajax({url:"<?=base_url('89/dashboard/save_dtl_rec')?>",method:"POST",data:{datas:datas},success:function(data)  
                        { 
                           
                            saveh(); 
                            getdtl(); 
                            
                        }  });
    
                    
                }
            }
        }
    } 
}

function saveheader() { if(confirm("Save record now?")==true) { saveh(); alert("record saved"); } }

function saveh()
{
var datas=[
$("#id").val()
,$("#poid").val()
,$("#fld2").val()
,$("#fld3").val()
,$("#fld5").val()
,$("#fld6").val()
,$("#fld7").val()
,$("#fld9").val()
,$("#fld10").val()
,$("#fld4").val()
,$("#tamt").val()
];
$.ajax({url:"<?=base_url('89/dashboard/saveh')?>",method:"POST",data:{datas:datas},success:function(data){}});
}

function getamt()
{
    var order=$("#e5").val();
    var deliver=$("#e6").val();
    var balance=order - deliver;
    $("#e7").val(balance);
    var cost=$("#e8").val();
    var amt=deliver * cost;
    $("#e9").val(amt);
}

function getpo()
{
    

var datas=[
    $("#id").val()
    ,$("#fld1").val()
    ]; 
    $.ajax({url:"<?=base_url('89/dashboard/getpo')?>",method:"POST",dataType:"json",data:{datas:datas},success:function(data) 
    { 
        var poid=data.poid;
        $("#poid").val(poid);
        $("#fld4").html(data.supplier); 
        getdtl();
        
    } 
        
    });

}

function getemp()
{
    

var id= $("#fld7").val()
    $.ajax({url:"<?=base_url('89/dashboard/getemp')?>",method:"POST",dataType:"json",data:{id:id},success:function(data) 
    { 
        
        //$("#poid").val(poid);
        $("#fld10").html(data.rb); 
        
    } 
        
    });

}

function clearfilter() {location.reload()}
    
function filter()
{
var datas=[
    $("#br").val()
    ,$("#wh").val()
    ,$("#st").val()
    ,$("#dn").val()
    ,$("#ds").val()
    ,$("#dna").val()
    ,$("#dsa").val()
];    
    
$.ajax({url:"<?=base_url('89/dashboard/list')?>",method:"POST",data:{datas:datas},success:function(data) {  $("#forms").empty(); $("#forms").html(data);} }); 
}    
    
$(document).ready(function()
{     
#("#form").show();
$('#form_entry').show(); 
$('#trn_list').DataTable();


function  list()
{
var datas=[
    $("#br").val()
    ,$("#wh").val()
    ,$("#st").val()
    ,$("#dn").val()
    ,$("#ds").val()
    ,$("#dna").val()
    ,$("#dsa").val()
];    
    
$.ajax({url:"<?=base_url('89/dashboard/list')?>",method:"POST",
data:{datas:datas},
success:function(data) 
{  
$("#forms").empty(); $("#forms").html(data);    
} 
}); 
}    

//list();    

$("#search").on("keyup", function() { list(); }); 

}); 

function getdtl() { var id=$("#poid").val(); $.ajax({url:"<?=base_url('89/dashboard/dtl_lst')?>",method:"POST", data:{id:id},success:function(data)  { $("#dtl").html(data); } }); }

function edit_rec(id) 
{

$.ajax({url:"<?=base_url("89/dashboard/edit_rec")?>", method:"POST", dataType:"json", data:{id:id},success:function(data) 
{ 
$("#xsearch").hide();$("#forms").empty();  $("#form_entry").show();     

$("#fld0").val(data.rr_no);
$("#fld1").val(data.po_no);  
$("#fld2").html(data.rrtype);
$("#fld3").val(data.rr_date);  
$("#fld4").html(data.supplier);
$("#fld5").html(data.no_ref);
$("#fld6").html(data.warehouse);
$("#fld9").html(data.remarks);

$("#poid").val(data.poid);

getdtl();
    
}  });  
}

function  addrec() {$.ajax({url:"<?=base_url('89/dashboard/addrec')?>",method:"POST",dataType:"json",data:{},success:function(data) { var id=data.id;$("#id").val(id); edit_rec(id)  } }); }     

function  list()
{
var datas=[
    $("#br").val()
    ,$("#wh").val()
    ,$("#st").val()
    ,$("#dn").val()
    ,$("#ds").val()
    ,$("#dna").val()
    ,$("#dsa").val()
];    
    
$.ajax({url:"<?=base_url('89/dashboard/list')?>",method:"POST",data:{datas:datas},
success:function(data) 
{  
$("#forms").empty(); $("#forms").html(data);    
} 
}); 
}    
    
function  exits()
{
var datas=[
    $("#br").val()

];    
    
$.ajax({url:"<?=base_url('89/dashboard/list')?>",method:"POST",data:{datas:datas},
success:function(data) {  $("#forms").empty(); $("#forms").html(data);    $("#form_entry").hide(); } }); 
}        

</script>         

