public function index()
{
$this->load->helper('xcrud');
$xcrud = Xcrud_get_instance();
$xcrud->table('ss_internal_issue_slip_header');
$xcrud->columns('iis_no,iis_date,iis_to,iis_ref_no,iis_note');
$xcrud->fields('iis_no,iis_date,iis_to,iis_ref_no,iis_note');
$xcrud->default_tab('Internal Isseue Slip');
$xcrud->unset_title();
$xcrud->set_attr('iis_no', array('id' => 'iis_no', 'Readonly' => 'True'));
// $xcrud->set_attr('project',array('id'=>'project'));
// $xcrud->relation('project','eproc_service_project','project_code','project_site');
// $xcrud->validation_required('project');
// $xcrud->validation_required('tanggal');
// $xcrud->relation('picked_by','trans_mstr_supir','nama_personil',array('kode_personil','nama_personil'),'','','',' - ');
// $xcrud->relation('received_by','trans_mstr_supir','nama_personil',array('kode_personil','nama_personil'),'','','',' - ');
$xcrud->label('iis_no', 'No');
$xcrud->label('iis_date', 'Date');
$xcrud->label('iis_ref_no', 'Ref. No');
$xcrud->label('iis_note', 'Note');
$xcrud->label('iis_to', 'To');
$xcrud2 = $xcrud->nested_table('Details', 'iis_no', 'ss_internal_issue_slip_detail', 'iis_detail_iis_no');
// 2nd level
$xcrud2->unset_title();
// $xcrud2->relation('lpb_id','eproc_lpb','lpb_id',array('lpb_no','description'),'project_code = (select project from ss_trans_material_return where id = {mr_id})','','',' - ');
$data['content'] = $xcrud->render();
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('Trans_internal_issue_slip', $data);
$this->load->view('commons/footer');
}
public function index()
{
$this->load->helper('xcrud');
$xcrud = Xcrud_get_instance();
$xcrud->table('ss_trans_material_return');
$xcrud->columns('mr_no,tanggal,project,picked_by,received_by');
$xcrud->default_tab('Material Return');
$xcrud->table_name('Material Return');
$xcrud->set_attr('mr_no', array('id' => 'mr_no', 'Readonly' => 'True'));
$xcrud->set_attr('project', array('id' => 'project'));
$xcrud->relation('project', 'eproc_service_project', 'project_code', 'project_site');
$xcrud->validation_required('project');
$xcrud->validation_required('tanggal');
$xcrud->relation('picked_by', 'trans_mstr_supir', 'nama_personil', array('kode_personil', 'nama_personil'), '', '', '', ' - ');
$xcrud->relation('received_by', 'trans_mstr_supir', 'nama_personil', array('kode_personil', 'nama_personil'), '', '', '', ' - ');
$xcrud->label('mr_no', 'No');
$xcrud2 = $xcrud->nested_table('Details', 'id', 'ss_trans_material_return_detail', 'mr_id');
// 2nd level
$xcrud2->unset_title();
$xcrud2->relation('lpb_id', 'eproc_lpb', 'lpb_id', array('lpb_no', 'description'), 'project_code = (select project from ss_trans_material_return where id = {mr_id})', '', '', ' - ');
$xcrud2->columns('lpb_id,qty');
$xcrud2->fields('lpb_id,qty,remarks');
$xcrud2->set_attr('lpb_id', array('id' => 'lpb_id'));
$xcrud2->set_attr('mr_id', array('id' => 'mr_id'));
$xcrud2->column_cut(250, 'lpb_id');
// separate columns
$xcrud2->label('lpb_id', 'Description');
$xcrud2->validation_required('lpb_id');
$xcrud2->validation_required('qty');
$xcrud2->column_class('qty', 'align-right');
// $trans_grn_detail ->fields('mr_detail_mr_no,mr_detail_description,mr_detail_brand,mr_detail_qty, mr_detail_remarks');
// // $trans_grn_detail->label('grn_detail_material_code','Material Code');
// // $trans_grn_detail->change_type('unit_price','price', '0', array('prefix'=>'Rp. ','separator'=>'.','point'=>','));
// // $trans_grn_detail->column_class('unit_price', 'align-right');
// // $trans_grn_detail->relation('vendor_id','vendor','vendor_code','vendor');
// // $trans_grn_detail->relation('unit','unit_of_material','nama','nama');
// $trans_grn_detail->default_tab('Material Return Details');
$data['content'] = $xcrud->render();
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('trans_material_return', $data);
$this->load->view('commons/footer');
}
public function index()
{
//---------------------------------------------------------------------------------------------------------------------------------------
$this->load->helper('xcrud');
//'kode'=>$this->model_mhs->create_no_pr(),
$xcrud = Xcrud_get_instance('1');
$xcrud->connection('root', '', 'bcspurchase_2015');
//$xcrud->table('pr');
//$xcrud->where('catid =', 5);
$grp = GROUPDESC;
if ($grp == 'Administrator') {
$xcrud->table('pr');
$xcrud->where('user_group', array('Administrator', 'General User', 'Transportation', 'Dam Truck', 'Marketing', 'Legal Department', 'Maintenance_Cilegon', 'Finance', 'Maintenance_Narogong'));
} else {
$xcrud->table('pr');
$xcrud->where('user_group', array(GROUPDESC));
}
$xcrud->table_name('PR Header');
$xcrud->modal('image,description');
$xcrud->default_tab('Header');
$xcrud->columns('pr_no,pr_date,project,status,received_by,approved,request_by');
$xcrud->fields('no_urut,pr_no,pr_date,project,status,approved,prepared,request_by,user_group,received_by');
$xcrud->unset_title();
$xcrud->unset_remove();
$xcrud->pass_var('create_user', USER_NAME, 'create');
$xcrud->pass_var('create_date', date('Y-m-d H:i:s'), 'create');
$xcrud->pass_var('modify_user', USER_NAME, 'edit');
$xcrud->pass_var('modify_date', date('Y-m-d H:i:s'), 'edit');
$xcrud->benchmark(true);
$xcrud->label('received_by', '');
$xcrud->highlight('received_by', '=', 'SYSTEM', 'pink');
$xcrud->highlight('received_by', '!=', 'SYSTEM', '#68DFF0');
$xcrud->label('user_group', '');
$xcrud->label('approved', 'Approved By');
$xcrud->label('request_by', 'Request By');
$xcrud->label('prepared', 'Prepared By');
$xcrud->label('pr_no', 'PR. No');
$xcrud->label('no_urut', '');
$xcrud->label('pr_date', 'PR. Date');
$xcrud->label('project', 'Project Code');
$xcrud->label('status', 'PR. Status');
$receivedby = "SYSTEM";
$groupdesc = GROUPDESC;
$xcrud->set_attr('received_by', array('type' => 'hidden', 'value' => $receivedby));
//$xcrud->column_tooltip('received_by', 'Pink = Outstanding PR');//'id'=>'received_by'
$xcrud->set_attr('user_group', array('type' => 'hidden', 'value' => $groupdesc));
//,'value'=>$nopr ,'value'=>"02/2015/ES/001"
$xcrud->set_attr('pr_no', array('id' => 'pr_no', 'Readonly' => 'True'));
//,'value'=>$nopr ,'value'=>"02/2015/ES/001"
$xcrud->set_attr('no_urut', array('id' => 'no_urut', 'type' => 'hidden'));
$xcrud->set_attr('request_by', array('id' => 'request_by', 'type' => 'hidden'));
//,'value=>{prepared}'
$xcrud->set_attr('prepared', array('id' => 'prepared'));
$xcrud->set_attr('status', array('id' => 'status'));
$xcrud->set_attr('pr_date', array('id' => 'dated'));
//,'required'=>'required'
$xcrud->set_attr('project', array('id' => 'project'));
//,'required'=>'required'
$xcrud->validation_required('email');
$xcrud->field_tooltip('trans_purchase_status', ' Regular order, untuk order material dengan proyeksi kebutuhan selama 1 bulan, bisa berasal dari suggestion order atau diluar suggestion order
Emergency Stock, adalah order untuk top up stock per minggu, berasal dari suggestion order
Back order, adalah order untuk material yang dibutuhkan dan tidak ada di dalam stock, bisa berasal dari permintaan dari User dalam DN, SS, IIS, bisa juga karena ada potensi kebutuhan
');
$xcrud->relation('prepared', 'ss_preparedby', 'nama1', 'nama1');
$xcrud->relation('approved', 'ss_approvedby', 'nama1', 'nama1');
$xcrud->relation('status', 'trans_purchase_status', 'trans_purchase_status_code', 'trans_purchase_status_name');
$xcrud->relation('project', 'eproc_service_project', 'project_code', 'project_site');
$xcrud->limit(8);
$sub_table = $pr_detail = $xcrud->nested_table('Details', 'pr_no', 'pr_detail', 'pr_no');
// 2nd level
$pr_detail->columns('pr_no,material_id,qty,remarks');
$pr_detail->fields('pr_id,pr_no,material_id,qty,remarks');
$pr_detail->relation('material_id', 'eproc_m_description', 'material_id', 'description');
$pr_detail->relation('trans_purchase_detail_description', 'mstr_material_data', 'material_id', 'material_data_description');
$pr_detail->validation_required('material_id');
$pr_detail->label('material_id', 'Description');
$pr_detail->column_width('material_id', '60%');
$pr_detail->column_cut('250', 'material_id');
$pr_detail->label('pr_no', 'PR. No');
$pr_detail->unset_title();
$pr_detail->unset_edit();
$pr_detail->set_attr('pr_id', array('readonly' => 'readonly', 'id' => 'pr_id'));
$pr_detail->set_attr('pr_no', array('readonly' => 'readonly'));
$pr_detail->set_attr('material_id', array('id' => 'material_id'));
$pr_detail->set_attr('trans_purchase_detail_description', array('disabled' => 'disabled', 'id' => 'description'));
$pr_detail->label('trans_purchase_detail_description', 'Description');
$pr_detail->label('qty', 'Qty');
$pr_detail->label('remarks', 'Remarks');
$pr_detail->set_attr('qty', array('id' => 'qty'));
$pr_detail->default_tab(' ');
$sub_table->connection('root', '', 'bcspurchase_2015');
$data['content'] = $xcrud->render();
//view wrs---------------------------------------------------------------------------------------------------------------------------
$this->load->helper('xcrud');
//$outstanding_pr = =GROUPDESC;
$groupdesc = GROUPDESC;
//echo $groupdesc;
$view_wrs = Xcrud::get_instance('view_wrs');
$view_wrs->connection('root', '', 'bcspurchase_2015');
$view_wrs->table('print_lpb');
//eproc_pr_outstanding AND `pr`.`user_group`=$group
//$view_wrs ->columns('pr_no,pr_date,project,status,received_by,approved,request_by');
// $sub_table=
// $outstanding_pr_detail= $xcrud->nested_table('Purchase details','pr_no','pr_detail','pr_no'); // 2nd level
// $outstanding_pr_detail ->columns('pr_no,material_id,qty,remarks');
// $sub_table->connection('root','','bcspurchase_2015');
$data['content4'] = $view_wrs->render();
//outstanding-------------------------------------------------------------------------------------------------------------------------------------------
$this->load->helper('xcrud');
//$outstanding_pr = =GROUPDESC;
//$groupdesc =GROUPDESC;
//echo $groupdesc;
$outstanding_pr = Xcrud::get_instance('outstanding_pr');
$outstanding_pr->connection('root', '', 'bcspurchase_2015');
$grp = GROUPDESC;
if ($grp == 'Administrator') {
$outstanding_pr->table('eproc_pr_outstanding');
$outstanding_pr->where('user_group', array('Administrator', 'General User', 'Transportation', 'Dam Truck', 'Marketing', 'Legal Department', 'Maintenance_Cilegon', 'Finance', 'Maintenance_Narogong'));
} else {
$outstanding_pr->table('eproc_pr_outstanding');
$outstanding_pr->where('user_group', array(GROUPDESC));
}
// $outstanding_pr->query("SELECT IF(EXISTS (SELECT `pr`.`pr_no` AS `pr_no`,`pr`.`pr_date` AS `pr_date`,`pr`.`project` AS `project`,`pr`.`request_by` AS `request_by`,`pr`.`approved` AS `approved`,`pr`.`prepared` AS `prepared`,`pr`.`received_by` AS `received_by`,`pr`.`status` AS `status` from `pr` WHERE `pr`.`received_by` = 'SYSTEM' AND `pr`.`user_group`='".$groupdesc."'), IF NOT EXISTS
// (select distinct '' AS `pr_no`,'' AS `pr_date`,'' AS `project`,'' AS `request_by`,''AS `approved`,'' AS `prepared`,'' AS `received_by`,'' AS `status` from `pr`),0)as A"); //eproc_pr_outstanding AND `pr`.`user_group`=$group
$outstanding_pr->columns('pr_no,pr_date,project,status,received_by,approved,request_by,Jumlah_Material');
// $sub_table=
// $outstanding_pr_detail= $xcrud->nested_table('Purchase details','pr_no','pr_detail','pr_no'); // 2nd level
// $outstanding_pr_detail ->columns('pr_no,material_id,qty,remarks');
// $sub_table->connection('root','','bcspurchase_2015');
$data['content3'] = $outstanding_pr->render();
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('trans_purchase', $data);
$this->load->view('commons/foot_r');
}
