<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Dashboard extends CI_Controller {

public function __construct()
{
parent::__construct();$this->load->helper('form'); $this->load->helper('url', 'form');$this->load->model('user_model');
if(!$this->session->userdata('user_id'))  { redirect('user/login');  }    
}

function index() 
{ 
$data['fld']=$this->db->list_fields('sr'); 
//if($this->user_model->chk_group($a)==true) 
{ $this->load->view("header"); $this->load->view("25/view",$data); } 
// else { redirect(base_url()); }
}    

function add_rec()
{
$uid=$_SESSION['user_id'];
$fld=$this->db->list_fields('sr');    

$loc=$this->db->where('id',$uid)->get('users')->row('location');
$unm=$this->db->where('id',$uid)->get('users')->row('name');
$branch=$this->db->where('id',$loc)->get('location')->row('name');    

$dat['branch']=$loc; $dat['Date']=date('Y-m-d'); $dat['Warehouse']=1;
$dat['prepared_by']=$uid;
$this->db->insert('sr',$dat);

$id=$data['id']=$this->db
->where('branch',$loc)
->order_by('id','desc')
->limit(1)
->get('sr')->row('id');    
$cl=strlen($id);
$code='SR';
for($a=0;$a< 8 - $cl;$a++)
{
$code.='0';
}
$code.=$id;
$dat['SR_no']=$code;
$dat['id']=$id;
$this->db->where('id',$id)->update('sr',array('SR_no'=>$code));
echo json_encode($dat);

}

function edit_rec()
{
$id=$_POST['id']; $uid=$_SESSION['user_id']; $fld=$this->db->list_fields('sr');    

$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];
}
    
$loc=$this->db->where('id',$uid)->get('users')->row('location');
$unm=$this->db->where('id',$uid)->get('users')->row('name');
$branch=$this->db->where('id',$loc)->get('location')->row('name');

$rs=$this->db->where('id',25)->get('scm_settings')->result();
foreach($rs as $row) { $title=$row->caption;}    

$rsx=$this->db->where('id',$id)->get('sr')->result_array();   
foreach($rsx as $row)
{
$wh=$row['Warehouse']; 
$br=$row['Branch'];
$pb=$row['prepared_by'];
$xdt=$row['deliver_type'];
$xdd=$row['delivery_day'];
$xstat=$row['Status'];    
$rs=$this->db->get('wh')->result();    
$whopt='';    
foreach($rs as $rows)
{
    $sel='';if($rows->id==$wh) {$sel='selected';}
    $whopt.='<option value='.$rows->id.' '.$sel.'>'.$rows->name.'</option>';    

}

 $bropt='<option value='.$br.' selected>
'.$this->db->where('id',$br)->get('location')->row('name').'</option>';    

 $pbopt='<option value='.$pb.' selected>
'.$this->db->where('id',$pb)->get('users')->row('name').'</option>';
$days=array(0=>'Sunday',1=>'Monday',2=>'Tuesday',3=>'Wednesday',4=>'Thursday',5=>'Friday',6=>'Saturday');


$day_opt='';
    for($a=0;$a<count($days);$a++)
    {
        $sel=''; if($a==$xdt) {$sel='selected';}
        $day_opt.='<option value='.$a.' '.$sel.'>'.$days[$a].'</option>';
    }
    
$dt=array(0=>'New',1=>'Pickup',2=>'Delivery')    ;    
$dt_opt='';
    for($a=0;$a<count($dt);$a++)
    {
        $sel='';if($a==$xdd) {$sel='selected';}
        $dt_opt.='<option value='.$a.' '.$sel.'>'.$dt[$a].'</option>';
    }
    
$stat=array(0=>'New',1=>'Preparation',2=>'For Delivery',2=>'Delivered')    ;    
$stat_opt='';
    for($a=0;$a<count($dt);$a++)
    {
        $sel='';if($a==$xstat) {$sel='selected';}
        $stat_opt.='<option value='.$a.' '.$sel.'>'.$dt[$a].'</option>';
    }

$fldnm=$fld[0]; 
$datafld=$row[$fldnm];

echo ' 
<div class="row" >

<input type="hidden" id="'.$fldnm.'" value='.$datafld.' />';
    
$fldnm=$fld[1]; $datafld=$row[$fldnm];
echo '    
<div class="col-sm-3">
<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"><span class="input-group-text">'.$title.'</span></div>
<input type="text" class="form-control '.$fldnm.'" 
id="'.$fldnm.'" value="'.$datafld.'" disabled /> </div>';
    
$fldnm=$fld[2]; $datafld=$row[$fldnm];
echo '  

<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<input type="text" class="form-control '.$fldnm.'" id="'.$fldnm.'"
value="'.$datafld.'"  disabled /></div> ';
    
$fldnm=$fld[3]; $datafld=$row[$fldnm];
echo '  

<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<select class="form-control '.$fldnm.'" id="'.$fldnm.'"
onchange="header_save()" >'.$bropt.'</select></div>   ';
    
$fldnm=$fld[4]; $datafld=$row[$fldnm];
echo '  
  
<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<select class="form-control '.$fldnm.'" id="'.$fldnm.'"
 onchange="header_save()" >'.$whopt.'</select></div>  ';
    
$fldnm=$fld[5]; $datafld=$row[$fldnm];
echo '     

<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<input type="date" class="form-control '.$fldnm.'" id="'.$fldnm.'"
value="'.$datafld.'"  onchange="header_save()" /></div> ';
    
$fldnm=$fld[6]; $datafld=$row[$fldnm];
echo '   

<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<select class="form-control '.$fldnm.'" id="'.$fldnm.'"
 onchange="header_save()" >'.$day_opt.'</select></div>    ';
    
$fldnm=$fld[7]; $datafld=$row[$fldnm];
echo '    

<div class="input-group mb-1 input-group-sm">
<div class="input-group-prepend"> <span class="input-group-text">'.$fldnm.'</span></div> 
<select class="form-control '.$fldnm.'" id="'.$fldnm.'"
 onchange="header_save()" >'.$stat_opt.'</select></div>    
 
 <div class="input-group mb-1 input-group-sm">
    <button type="button" class="btn btn-outline-info btn-sm" onclick="export()">Export</button>
    <button type="button" class="btn btn-outline-info btn-sm"  onclick="app_rec()">Approved</button>
    <button type="button" class="btn btn-outline-info btn-sm" onclick="exits()">Close</button> 
  
</div>  
</div>  
';
}
    
echo '     

<div class="col-sm-9">

<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">Item</span></div> 
<select class="form-control Item" id="Item" ></select>
</div>    

<div class="input-group mb-1 input-group-sm col-sm-3">
<div class="input-group-prepend"> <span class="input-group-text">Qty</span></div> 
<input type="number" class="form-control qty" id="qty" value=0 />
<input type="hidden" class="seq" id="seq" value=0 />
</div>   

<div class="input-group mb-1 input-group-sm col-sm-3">
  
<input type="button" class="form-control btn-outline-dark" value ="Save" onclick="save_dtl()" /> 
<input type="button" class="form-control btn-outline-danger" value ="Delete" onclick="del_dtl()" /> 
<input type="button" class="form-control btn-outline-dark" value ="Clear" onclick="clr_dtl()" /> </div>

<div id="dtl" class="col-sm-12"> </div> 

</div> 

</div> 

<script>



function  list()
{
$.ajax({url:"'.base_url('25/dashboard/list').'",method:"POST",data:{search:$("#search").val()},
success:function(data) 
{  
$("#forms").empty(); $("#forms").html(data);    
} 
}); 
} 

function  app_rec()
{
var id=$("#id").val(); 
if(confirm("approved this record?")==true)
{


$.ajax({url:"'.base_url('25/dashboard/app_rec').'",method:"POST",  
data:{id:id},
success:function(data) 
{  window.location.href = "'.base_url('25/dashboard').'"; } }); 

}

}

function  header_save()
    {
        '.$var.'
$.ajax({url:"'.base_url('25/dashboard/header_save').'",method:"POST", dataType:"json", 
data:{'.$post.'},
success:function(data) 
{      
} }); 
    }
    
function clr_dtl()
{    
$("#seq").val(0); 
$("#qty").val(0); 
$("#Item").html(""); 
}

function list_dtl()
{
$.ajax({url:"'.base_url("25/dashboard/list_dtl").'", method:"POST", 
data:{id:$("#id").val()},success:function(data) { $("#dtl").html(data); } });  
}

$(document).ready(function() 
{
$("#Warehouse").focus();

function list_dtl()
{
$.ajax({url:"'.base_url("25/dashboard/list_dtl").'", method:"POST", 
data:{id:$("#id").val()},success:function(data) { $("#dtl").html(data); } });  
}

list_dtl();

$("#Item").select2({ajax: {  placeholder: "Select a Item",
allowClear: true,
url: "'.base_url("25/dashboard/Item").'",
type: "post", dataType: "json",  delay: 250,  data: function (params) { return { searchTerm: params.term  };  },processResults: function (response) {  return { results: response  };  },  cache: true   }});    

$("#Warehouses").select2({ajax: {  placeholder: "Select a Warehouse",
allowClear: true,
url: "'.base_url("25/dashboard/Warehouse").'",
type: "post", dataType: "json",  delay: 250,  data: function (params) { return { searchTerm: params.term  };  },processResults: function (response) {  return { results: response  };  },  cache: true   }});    

}); 

function save_dtl()
{
var qty=$("#qty").val();
var seq=$("#seq").val();
var Item=$("#Item").val();
var id=$("#id").val();

if(parseInt(Item)==0)
{ 
alert("Please select Item..."); 
}
else
{
if(parseInt(qty)==0)
{
alert("Please enter Qty..."); 
}
else
{
$.ajax({url:"'.base_url("25/dashboard/save_dtl").'",
method:"POST",  dataType:"json", 
data:{id:id,seq:seq,qty:qty,Item:Item},success:function(data) 
{ 
if(data.sw==0)
{
list_dtl();clr_dtl();$("#Item").focus();
}
else
{
alert(data.msg);
}

} 
}); 

}
}
}


</script>
</div> 

</div>





';
}

function list_dtl()
{
$id=$_POST['id'];
$rs=$this->db->where('id',$id)->get('sr_dtl')->result_array();
$th=$td=$tf='';$qty=0;
$tth=explode(',','seq,item,qty');
for($a=0;$a<count($tth);$a++) { $th.='<td>'.$tth[$a].'</td>'; }
foreach($rs as $row)
{
$qty+=$row[$tth[2]];
$item=$row[$tth[1]];
$itemnm=$this->db->where('id',$item)->get('item')->row('code');
$itemnm.=' '.$this->db->where('id',$item)->get('item')->row('name');
    
$td.='<tr>
<td>'.$row[$tth[0]].'</td>
<td>'.$itemnm.'</td>
<td>'.$row[$tth[2]].'</td>
</tr>';
}
$tf='
<td colspan=2>Total</td>
<td>'.$qty.'</td>
';
echo '
<br />
<table id="tbl_listd" class="display nowrap" style="width:100%" > 
<thead> <tr>'.$th.'</tr> </thead> 
<tbody>'.$td.'</tbody> 
<tfoot><tr>'.$tf.'</tr></tfoot></table>

<script>

$(document).ready(function() 
{ 
var table = $("#tbl_listd").DataTable();

$("#tbl_listd tbody").on("click", "tr", function () 
{ var data = table.row( this ).data();  edit_dtl(data[0]); });

function edit_dtl(id) 
{ 
$.ajax({url:"'.base_url("25/dashboard/edit_dtl").'",
method:"POST",  dataType:"json", 
data:{id:id},success:function(data) 
{ 
$("#seq").val(data.seq);
$("#qty").val(data.qty);
$("#Item").html(data.item);
$("#qty").focus();
} 
});  
} 

});

</script>

';
}

function list() 
{
$str=$_POST['search']; 

$rs=$this->db 
//->like('name',$str)     
->get('sr') 
->result_array();

$fld=$this->db->list_fields('sr'); 
$th=''; for($a=0;$a < count($fld);$a++) 
{ 
$th.='<th>'.strtoupper($fld[$a]).'</th>';     


}
$td=''; 
foreach($rs as $row) 
{ 
$td.='<tr>' ; 
for($a=0;$a<count($fld);$a++) 
{
$stat=array(0=>'New',1=>'Preparation',2=>'For Delivery',3=>'Delivered');
$dt=array(0=>'New',1=>'Pickup',2=>'Delivery');
$datafld=$row[$fld[$a]];   
    if($a==3) {$datafld=$this->db->where('id',$datafld)->get('location')->row('name');}
    if($a==4) {$datafld=$this->db->where('id',$datafld)->get('wh')->row('name');}
    if($a==8) {$datafld=$stat[$datafld];}
    if($a==7) {$datafld=$dt[$datafld];}
    
    if($a==9 or $a==10) {$datafld=$this->db->where('id',$datafld)->get('users')->row('name');}

{ $td.='<td>'.$datafld.'</td>'; } 

}

$td.='</tr>' ;
}

echo '<script>

$(document).ready(function() 
{ 
var table = $("#tbl_list").DataTable({"scrollX": true, "order": [[ 1, "desc" ]]});

$("#tbl_list tbody").on("click", "tr", function () 
{ var data = table.row( this ).data();  edit_rec(data[0]); });

function edit_rec(id) 
{ 
$.ajax({url:"'.base_url("25/dashboard/edit_rec").'",
method:"POST", 
data:{id:id},success:function(data) 
{ 
$("#xsearch").hide();  $("#forms").html(data); 
} 
});  
} 

});

</script>

<table id="tbl_list" class="display nowrap" style="width:100%" > <thead> <tr>'.$th.'</tr> </thead> <tbody>'.$td.'</tbody></table>';
}   

function save_dtl() 
{
$data['id']=$_POST['id']; 
$data['Item']=$_POST['Item']; 
$data['qty']=$_POST['qty']; 

$seq=$_POST['seq']; 
$dat['sw']=0; $dat['msg']='record saved...';
if($seq==0) 
{ 
    $rs=$this->db
        ->where('id',$data['id'])
        ->where('Item',$data['Item'])
        ->get('sr_dtl')->result();
    
    if(count($rs)>0) { $dat['sw']=1;$dat['msg']='Duplicate item found...'; }    
    else { $this->db->insert('sr_dtl',$data); }
    
    
}
else 
{ 

    $rs=$this->db
    ->where('id',$data['id'])
    ->where('seq!=',$seq)
    ->where('Item',$data['Item'])
    ->get('sr_dtl')->result();
    
    if(count($rs)>0) { $dat['sw']=1;$dat['msg']='Duplicate item found...'; }
    else { $this->db->where('seq',$seq)->update('sr_dtl',$data); }

}
echo json_encode($dat);
}   

function save_rec() 
{
$id=$_POST['id']; $fld=$this->db->list_fields('sr'); 
for($a=1;$a<count($fld);$a++) { $data[$fld[$a]] =$_POST[$fld[$a]]; }
$dat['sw']=0; $dat['msg']='record saved...';
if($id==0) 
{ 
$rs=$this->db->where('name',$data['name'])->get('sr')->result();
if(count($rs)>0)
{
$dat['sw']=1; $dat['msg']='duplicate rs name found...';
}
else { $this->db->insert('sr',$data); }

}
else 
{ 
$rs=$this->db
->where('id !=',$id)
->where('name',$data['name'])
->get('sr')->result();
if(count($rs)>0)
{$dat['sw']=1; $dat['msg']='duplicate rs name found...'; }
else {$this->db->where('id',$id)->update('sr',$data); }

}
echo json_encode($dat);
}          

function Warehouse() 
{
$xs=$this->input->post('searchTerm');  $xt='wh'; 
$rs = $this->db
->like('name',$xs)  
->order_by('name') ->limit(10) ->get($xt)->result_array(); 
//$data[]=array("id"=>0, "text"=>'select category');

foreach($rs as $row)  {$data[]=array("id"=>$row['id'], "text"=>$row['name']);}
echo json_encode($data); 
}        

function edit_dtl() 
{
$id=$_POST['id'];
$rs=$this->db->where('seq',$id)
->get('sr_dtl')->result_array();
$fld=$this->db->list_fields('sr_dtl'); 

$dat[$fld[0]]=$rs[0][$fld[0]];
$item=$this->db->where('id',$rs[0][$fld[1]])->get('item')->row('code');
$item.='-'.$this->db->where('id',$rs[0][$fld[1]])->get('item')->row('name');
$dat[$fld[1]]='<option value='.$rs[0][$fld[1]].' selected> '.$item.'</option>';
$dat[$fld[2]]=$rs[0][$fld[2]];
$dat[$fld[3]]=$rs[0][$fld[3]]; 


echo json_encode($dat);
}

function header_save() 
{
    $fld=$this->db->list_fields('sr'); 
    $id=$_POST['id'];
    
    for($a=4;$a<9;$a++) 
    {
        $dat[$fld[$a]]=$_POST[$fld[$a]];
    }
    $this->db->where('id',$id)->update('sr',$dat);
    
}
    
function Item() 
{
$xs=$this->input->post('searchTerm');  $xt='Item'; 
$rs = $this->db
->like('name',$xs) 
->or_like('code',$xs) 
->order_by('code') ->limit(10) ->get($xt)->result_array(); 
//$data[]=array("id"=>0, "text"=>'select category');

foreach($rs as $row)  {$data[]=array("id"=>$row['id'], "text"=>$row['code'].'-'.$row['name']);}
echo json_encode($data); 
}       
    
function  app_rec()
{
    $id=$_POST['id'];
    $dat['approved_by']=$_SESSION['user_id'];
    $dat['date_approved']=date('Y-m-d');
    $this->db->where('id',$id)->update('sr',$dat);
}

}

?>