/**
* This function will use to display Checkin detail with checkin history
*
* @access public
*
* @return void
*/
public function alertinfo($checkin_id)
{
$session = $this->session->userdata('admin_id');
if (empty($session)) {
redirect(site_url('login'), 'refresh');
}
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance();
/* Get Checkin data*/
$result = $this->checkins->getcheckinbyid($checkin_id);
$data['checkin'] = $result[0];
/* Get User data*/
$result_user = $this->users->getuserdetail($result[0]['user_id']);
$data['user'] = $result_user[0];
$xcrud->table('checkinhistory');
$xcrud->columns('time,status,latitude,longitude');
$xcrud->fields('updated_on', true, true, 'view');
$xcrud->change_type('time', 'date_format', '', '');
/* If checkin missed marke it as red (5= Missed checkin)*/
$xcrud->highlight('status', '=', '5', 'red');
$xcrud->change_type('status', 'select', '', array('values' => array('0' => 'Pending', '1' => 'Started', '2' => 'Confirmed', '3' => 'Deleted', '4' => 'Closed', '5' => 'Missed')));
$xcrud->where('checkin_id', $checkin_id);
$xcrud->unset_add();
$xcrud->unset_edit();
$xcrud->unset_remove();
$xcrud->unset_view();
$xcrud->unset_title();
$xcrud->unset_print();
$data['content'] = $xcrud->render();
/* Load Google Map*/
try {
$map_pos = $result[0]['latitude'] . "," . $result[0]['longitude'];
$config['center'] = $map_pos;
$config['zoom'] = 10;
$this->googlemaps->initialize($config);
$marker = array();
$marker['position'] = $map_pos;
$this->googlemaps->add_marker($marker);
$data['map'] = $this->googlemaps->create_map();
} catch (Exception $e) {
$this->load->view('error');
exit;
}
$this->load->view('alertinfo', $data);
}
/**
* This function will use for alert display
*
* @access public
* @return render view
*/
public function index()
{
$session = $this->session->userdata('admin_id');
if (empty($session)) {
redirect(site_url('login'), 'refresh');
}
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance();
$xcrud->table('alerts');
$xcrud->subselect('Media', "select count(*) from media where foreign_id = {id} AND table_id = '2' ");
$xcrud->columns('id,username,created_on,situation,Media');
$xcrud->column_name('id', 'Alert No');
$xcrud->column_name('username', 'Name');
$xcrud->column_name('situation', 'Status');
$xcrud->order_by('id', 'desc');
$xcrud->where('delete', 0);
$xcrud->button(site_url('media/reportmedia/{id}'), 'Media', 'glyphicon glyphicon-picture', '', '', array('Media', '!=', '0'));
$xcrud->button(site_url('report/reportinfo/{id}'), 'INFO', 'glyphicon glyphicon-search');
$xcrud->unset_add();
$xcrud->unset_edit();
$xcrud->unset_view();
$xcrud->unset_remove();
$xcrud->unset_title();
$xcrud->unset_print();
$data['content'] = $xcrud->render();
$this->load->view('report', $data);
}
public function index()
{
ob_start();
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance('xcrud_pr');
$xcrud->connection('root', 'root', 'bcspurchase_2015', '10.2.2.32');
//$xcrud->table('lpb');
$grp = GROUPDESC;
if ($grp == 'Administrator') {
$xcrud->table('lpb');
$xcrud->where('user_group', array('Administrator', 'General User', 'Transportation', 'Dam Truck', 'Marketing', 'Legal Department', 'Maintenance_Cilegon', 'Finance', 'Maintenance_Narogong'));
} else {
$xcrud->table('lpb');
$xcrud->where('user_group', array(GROUPDESC));
}
$xcrud->unset_edit();
$xcrud->unset_remove();
$xcrud->columns('lpb_no,lpb_date,po_no,received_by');
$xcrud->fields('lpb_no,lpb_date,po_no,received_by,user_group,no_urut,kategori');
$xcrud->unset_title();
$xcrud->label('user_group', '');
$xcrud->label('lpb_no', 'WRS No');
$xcrud->label('lpb_date', 'WRS Date');
$xcrud->label('kategori', '');
$xcrud->label('no_urut', '');
$xcrud->label('po_no', 'PO No.');
$xcrud->label('project_code', 'Project Code');
$xcrud->label('received_by', 'Received By');
$xcrud->set_attr('po_no', array('id' => 'po'));
//$xcrud->create_action('generate_wrs','generate_wrs');
//$xcrud->validation_required('kategori');
$xcrud->validation_required('lpb_no');
$xcrud->validation_required('lpb_date');
//$xcrud->validation_required('non_pr_grn_no');
$usergroup = GROUPDESC;
$kategori = "PR";
// echo $kategori;
$xcrud->set_attr('user_group', array('id' => 'user_group', 'type' => 'hidden', 'value' => $usergroup));
//optional ambil session
$xcrud->set_attr('no_urut', array('id' => 'no_urut', 'type' => 'hidden'));
//optional ambil session
$xcrud->set_attr('kategori', array('id' => 'kategori', 'type' => 'hidden', 'value' => $kategori));
//optional ambil session
$xcrud->set_attr('lpb_no', array('id' => 'lpb_no', 'ReadOnly' => 'True'));
//optional ambil session
$xcrud->set_attr('lpb_date', array('id' => 'lpb_date'));
//optional ambil session
$user = USER_NAME;
//echo $user;
//echo $data;
$xcrud->set_attr('received_by', array('readOnly' => 'True', 'id' => 'received_by', 'value' => $user));
//optional ambil session
$xcrud->set_attr('project_code', array('readOnly' => 'True', 'id' => 'project_code'));
//
// $xcrud->relation('project_code','project','project_code','project');
$xcrud->unset_remove();
// $xcrud->unset_edit();
$xcrud->default_tab('WRS Header');
$xcrud->benchmark(true);
$sub_table = $lpbdetail = $xcrud->nested_table('WRS Detail', 'lpb_no', 'lpb_detail', 'lpb_no');
// sub_table begin
$lpbdetail->columns('lpb_no,po_item_id,qty,unit');
//,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn
$lpbdetail->fields('lpb_no,po_item_id,qty');
//non_pr_grn_detail_brand_price ,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn,
$lpbdetail->label('lpb_no', 'WRS NO');
$lpbdetail->unset_edit();
$lpbdetail->unset_title();
//$lpbdetail->after_insert('Update_balance_po');
// $this->fb->log($po_item_id,'po_item_id_grn');
// die;
$lpbdetail->set_attr('po_item_id', array('id' => 'po_item_id'));
//
$lpbdetail->set_attr('qty', array('id' => 'qty'));
//
$lpbdetail->default_tab('');
$lpbdetail->set_attr('lpb_no', array('readOnly' => 'True', 'id' => 'lpb_no'));
$lpbdetail->relation('po_item_id', 'eproc_po_item_description', 'po_item_id', 'description', 'po_no = (select po_no from lpb where lpb_no = "{lpb_no}")');
//,
//$xcrud->where(‘status =’,’active’);
$sub_table->connection('root', 'root', 'bcspurchase_2015', '10.2.2.32');
// end sub_table
$sub_table = $po_item = $xcrud->nested_table('PO Item', 'po_no', 'po_item', 'po_no');
// sub_table begin
$po_item->columns('po_item_id,po_no,qty,unit,price,subtotal,discount,lpb_balance');
//$po_item->fields('po_item_id,po_no,qty,unit,price,discount');
$po_item->change_type('subtotal', 'price', '0', array('prefix' => 'Rp. ', 'separator' => '.', 'point' => ','));
$po_item->column_class('subtotal', 'align-right');
//$po_item->subselect('SELECT SUM(subtotal) FROM po_item '); // current table FROM trans_grn_detail_non_pr
// $po_item->sum('subtotal','Total price is {value}');
$po_item->relation('po_item_id', 'eproc_po_item_description', 'po_item_id', 'description');
$po_item->unset_remove();
$po_item->unset_add();
$po_item->unset_edit();
$po_item->default_tab('Po details');
$po_item->unset_title();
$sub_table->connection('root', 'root', 'bcspurchase_2015', '10.2.2.32');
// end sub_table
$data['content'] = $xcrud->render();
//--------------------------------------------------------------------------------------------------------------------------------------------------------
$this->load->helper('xcrud');
//$outstanding_pr = =GROUPDESC;
$groupdesc = GROUPDESC;
//echo $groupdesc;
$view_wrs = Xcrud::get_instance('view_wrs');
$view_wrs->connection('root', 'root', 'bcspurchase_2015');
$view_wrs->table('print_lpb');
//eproc_pr_outstanding AND `pr`.`user_group`=$group
$view_wrs->unset_title();
$view_wrs->limit(10);
$view_wrs->benchmark();
$view_wrs->change_type('price', 'price', '0', array('prefix' => 'Rp. ', 'separator' => '.', 'point' => ','));
$view_wrs->column_class('price', 'align-right');
$view_wrs->sum('price', 'Total is {Price}');
//$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','root', 'bcspurchase_2015','10.2.2.32');
$data['content4'] = $view_wrs->render();
// //-----------------------------------------------------------------------------------------------------------------
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('grn', $data);
$this->load->view('commons/foot_r');
}
function xcrud_get_instance($name = true)
{
return Xcrud::get_instance($name);
}
public function index()
{
$this->load->library('session');
$this->load->helper(array('url', 'xcrud'));
Xcrud_config::$scripts_url = base_url('');
$this->output->set_output(Xcrud::get_requested_instance());
}
public function index()
{
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance('xcrud');
$xcrud->table('work_order');
$xcrud->unset_title();
$xcrud->default_tab('Header');
$xcrud->columns('driver_name,no_rangka,nama_tipe,no_lambung,mechanic,payment_code,id,kilometer,hourmeter,problem,cause,status', true);
$xcrud->fields('nomor_unit,project_code,wo_no,date,vendor,no_rangka,nama_tipe,no_lambung', false, 'Unit');
$xcrud->fields('driver_name,mechanic,payment_code,kilometer,hourmeter,user_group,date_promised', false, 'Unit 2');
$xcrud->fields('problem,cause', false, 'Problem & Cause');
$xcrud->where('user_group =', GROUPDESC);
//Select only this group records
$xcrud->relation('nomor_unit', 'trans_mstr_unit', 'nomor_unit', 'nomor_unit');
$xcrud->relation('driver_name', 'trans_mstr_supir', 'id', 'nama_personil', "trans_mstr_supir.aktif = 1 and trans_mstr_supir.kode = 'D'");
$xcrud->set_attr('project_code', array('id' => 'project_code'));
$xcrud->set_attr('project_code', array('readOnly' => 'True'));
$xcrud->set_attr('wo_no', array('id' => 'wo_no'));
$xcrud->set_attr('wo_no', array('readOnly' => 'True'));
$xcrud->set_attr('nomor_unit', array('id' => 'nomor_unit'));
$xcrud->set_attr('vendor', array('id' => 'vendor'));
$xcrud->set_attr('vendor', array('readOnly' => 'True'));
$xcrud->set_attr('no_rangka', array('id' => 'no_rangka'));
$xcrud->set_attr('no_rangka', array('readOnly' => 'True'));
$xcrud->set_attr('nama_tipe', array('id' => 'nama_tipe'));
$xcrud->set_attr('nama_tipe', array('readOnly' => 'True'));
$xcrud->set_attr('no_lambung', array('id' => 'no_lambung'));
$xcrud->set_attr('no_lambung', array('readOnly' => 'True'));
$xcrud->set_attr('user_group', array('id' => 'user_group'));
$xcrud->set_attr('user_group', array('readOnly' => 'True'));
$xcrud->change_type('payment_code', 'select', '', array('values' => array('-- Silahkan pilih --', '00 = Customer', '01 = Internal', '02 = Warranty')));
$xcrud->label('vendor', 'Customer');
$xcrud->label('no_rangka', 'Chassis No');
$xcrud->label('nama_tipe', 'Type');
$xcrud->label('no_lambung', 'Unit Code');
$xcrud->label('nomor_unit', 'Unit No');
$xcrud->label('date_promised', 'Promise Ready');
$xcrud->validation_required('nomor_unit');
$xcrud->validation_required('project_code');
$xcrud->validation_required('wo_no');
$xcrud->create_action('generate_wo', 'generate_wo');
//generate WO number automaticaly
$wodetail = $xcrud->nested_table('Detail', 'wo_no', 'work_order_detail', 'wo_no');
// sub_table begin
$wodetail->fields('wo_no,op_number,op_description,qty,op_price,op_total,date_begin,date_end');
$wodetail->unset_title();
$wodetail->set_attr('wo_no', array('readOnly' => 'True'));
$wodetail->set_attr('qty', array('id' => 'qty', 'class' => 'qty_price'));
$wodetail->set_attr('op_price', array('id' => 'op_price', 'class' => 'qty_price'));
$wodetail->set_attr('op_total', array('id' => 'op_total'));
$wodetail->set_attr('op_total', array('readOnly' => 'True'));
$wodetail->label('op_price', 'Time');
$wodetail->label('op_total', 'Time Total');
$data['content'] = $xcrud->render();
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('wo', $data);
$this->load->view('commons/foot_r');
}
/**
* This function will use to display all user list
*
* @access public
* @return render view
*/
public function userinfo()
{
$session = $this->session->userdata('admin_id');
if (empty($session)) {
redirect(site_url('login'), 'refresh');
}
$login_type = $this->session->userdata('type');
$this->load->helper('xcrud');
Xcrud_config::$dbname = 'iwmf_user';
$xcruduser = Xcrud::get_instance();
$xcruduser->table('users');
$xcruduser->subselect('Name', "CONCAT_WS(' ',firstname,lastname)");
$xcruduser->columns('Name,checkin_count,alert_count, language, phone, jobtitle,created_on,status,last_checkin_time,checkin_status');
$xcruduser->change_type('checkin_status', 'select', '', array('values' => array('0' => 'Pending', '1' => 'Started', '2' => 'Confirmed', '3' => 'Deleted', '4' => 'Closed', '5' => 'Missed')));
$xcruduser->where('delete', 0);
$xcruduser->column_name('jobtitle', 'Title');
$xcruduser->column_name('created_on', 'Join Date');
$xcruduser->column_name('alert_count', '# Alerts');
$xcruduser->column_name('checkin_count', '# Check-Ins');
$xcruduser->column_name('last_checkin_time', 'Last Check-in');
$xcruduser->column_name('checkin_status', 'Check-in Status');
$xcruduser->change_type('status', 'select', '', array('values' => array('-1' => 'Locked', '0' => 'Inactive', '1' => 'Active')));
/*view user link for normal admin*/
if ($login_type == 1) {
$url = site_url('userinfo/userinfo/viewuser/{id}');
} else {
/*Edit user link for supper admin*/
$url = site_url('userinfo/userinfo/index/{id}');
}
$xcruduser->column_pattern('Name', '<a href=' . $url . ' class="" data-task="" data-primary="{id}">{Name}</a>');
$xcruduser->change_type('status', 'select', '', array('values' => array('-1' => 'Locked', '0' => 'Inactive', '1' => 'Active')));
$xcruduser->change_type('type', 'select', '', array('values' => array('1' => 'Admin', '2' => 'User')));
$xcruduser->change_type('Check-in Status', 'select', '', array('values' => array('0' => 'Pending', '1' => 'Started', '2' => 'Confirmed', '3' => 'Deleted', '4' => 'Closed', '5' => 'Missed')));
$xcruduser->search_columns('Name,language,jobtitle,status', 'Name');
$xcruduser->unset_edit();
$xcruduser->unset_add();
$xcruduser->unset_view();
$xcruduser->unset_title();
$xcruduser->unset_print();
$xcruduser->unset_remove();
if ($login_type == 1) {
$xcruduser->button(site_url('userinfo/userinfo/viewuser/{id}'), 'EDIT', 'glyphicon glyphicon-eye-open');
} else {
$xcruduser->button(site_url('userinfo/userinfo/index/{id}'), 'EDIT', 'glyphicon glyphicon-pencil');
$xcruduser->button('{id}', 'Delete', 'glyphicon glyphicon-trash', 'ref', '', array('type', '!=', 3));
}
$data['content'] = $xcruduser->render();
$this->load->view('home', $data);
}
/**
*This function will use for display all active(Pending, started, Confirmed) Checkin
*
* @access public
*
* @return render view
*/
public function index()
{
$session = $this->session->userdata('admin_id');
if (empty($session)) {
redirect(site_url('login'), 'refresh');
}
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance();
$xcrud->table('checkin');
/* Get media count*/
$xcrud->subselect('Media', "select IF(count(id) > 0, count(id), 0) from media where foreign_id = {id} AND table_id = '1'");
$xcrud->where('status', array('0', '1', '2'));
$xcrud->columns('id,username,starttime,endtime,laststatustime,status,description,Media');
$xcrud->order_by('id', 'desc');
$xcrud->column_name('id', 'Check In No');
$xcrud->column_name('username', 'Name');
$xcrud->column_name('starttime', 'Start Time');
$xcrud->column_name('endtime', 'End Time');
$xcrud->where('delete', 0);
$xcrud->column_name('laststatustime', 'Last Status Time');
$xcrud->search_columns('id,Name,status', 'Name');
/* If checkin missed marke it as red (5= Missed checkin)*/
$xcrud->highlight('status', '=', '5', 'red');
$xcrud->change_type('status', 'select', '', array('values' => array('0' => 'Pending', '1' => 'Started', '2' => 'Confirmed', '3' => 'Deleted', '4' => 'Closed', '5' => 'Missed')));
$xcrud->button(site_url('media/checkinmedia/{id}'), 'Media', 'glyphicon glyphicon-picture', '', '', array('Media', '!=', '0'));
$xcrud->button(site_url('alert/alertinfo/{id}'), 'INFO', 'glyphicon glyphicon-search');
$xcrud->unset_add();
$xcrud->unset_edit();
$xcrud->unset_view();
$xcrud->unset_remove();
$xcrud->unset_title();
$xcrud->unset_print();
if ($this->input->server('REQUEST_METHOD') == 'POST') {
/*Filter checkin base on status*/
if ($this->input->post('status') >= 0) {
$xcrud->where('status', $this->input->post('status'));
}
echo $xcrud->render();
exit;
}
$data['content'] = $xcrud->render();
$this->load->view('checkinSchedules', $data);
}
<?php
/**
* @ignore
*/
?>
<html>
<head>
<?php
$this->load->view('head');
?>
<?php
echo Xcrud::load_css();
?>
<?php
echo Xcrud::load_js();
?>
<script type="text/javascript">
$(document).ready(function(){
$('#jobtitle option[value="<?php
$container['jobtitle'] = $this->security->xss_clean($container['jobtitle']);
echo $container['jobtitle'];
?>
"]').attr("selected",true);
$('#freelancer option[value="<?php
$container['freelancer'] = $this->security->xss_clean($container['freelancer']);
echo $container['freelancer'];
?>
"]').attr("selected",true);
$('#status option[value="<?php
public function index()
{
$this->load->helper('xcrud');
$xcrud_wrs_non_pr = Xcrud::get_instance('xcrud_wrs_non_pr');
$xcrud_wrs_non_pr->connection('root', '', 'bcspurchase_2015');
// $xcrud_wrs_non_pr->table('lpb');
$grp = GROUPDESC;
$kat = "NON_PR";
$xcrud_wrs_non_pr->table('lpb');
// $xcrud_wrs_non_pr->where('user_group',$grp)->where('kategori =',$kat);
$xcrud_wrs_non_pr->where("lpb.user_group='" . $grp . "' AND lpb.kategori ='" . $kat . "' ");
$xcrud_wrs_non_pr->columns('lpb_no,lpb_date,vendor,project_code,received_by');
$xcrud_wrs_non_pr->fields('lpb_no,lpb_date,project_code,vendor,received_by,transporter,mengetahui,user_group,kategori');
$xcrud_wrs_non_pr->unset_title();
$xcrud_wrs_non_pr->label('lpb_no', 'WRS No.');
$xcrud_wrs_non_pr->label('user_group', '');
$xcrud_wrs_non_pr->label('transporter', 'Transporter');
$xcrud_wrs_non_pr->label('mengetahui', 'Acknowledge');
$xcrud_wrs_non_pr->label('lpb_date', 'WRS Date');
$xcrud_wrs_non_pr->label('kategori', '');
$xcrud_wrs_non_pr->label('project_code', 'Project Code');
$xcrud_wrs_non_pr->label('received_by', 'Received By');
$xcrud_wrs_non_pr->set_attr('po_no', array('id' => 'po'));
//$xcrud_wrs_non_pr->validation_required('kategori');
$xcrud_wrs_non_pr->validation_required('lpb_no');
$xcrud_wrs_non_pr->validation_required('lpb_date');
//$xcrud->validation_required('non_pr_grn_no');
$usergroup = GROUPDESC;
$kategori = "NON_PR";
//$xcrud->relation('po_no','po','po_no','po_no');
$xcrud_wrs_non_pr->set_attr('user_group', array('id' => 'user_group', 'type' => 'hidden', 'value' => $usergroup));
//optional ambil session
$xcrud_wrs_non_pr->set_attr('kategori', array('id' => 'kategori', 'type' => 'hidden', 'value' => $kategori));
//optional ambil session
$xcrud_wrs_non_pr->set_attr('lpb_no', array('id' => 'lpb_no', 'ReadOnly' => 'True'));
//optional ambil session
$xcrud_wrs_non_pr->set_attr('lpb_date', array('id' => 'lpb_date'));
//optional ambil session
$user = USER_NAME;
//echo $user;
$xcrud_wrs_non_pr->set_attr('received_by', array('readOnly' => 'True', 'id' => 'received_by', 'value' => $user));
//optional ambil session
$xcrud_wrs_non_pr->set_attr('project_code', array('id' => 'project_code'));
//
//$xcrud_wrs_non_pr->unset_remove();
// $xcrud->unset_edit();
$xcrud_wrs_non_pr->relation('project_code', 'eproc_service_project', 'project_code', 'project_site');
$xcrud_wrs_non_pr->relation('mengetahui', 'ss_approvedby', 'nama1', 'nama1');
$xcrud_wrs_non_pr->relation('vendor', 'view_vendor', 'vendor_id', 'nama');
//'eproc_service_project','project_code','project_site'
$xcrud_wrs_non_pr->default_tab('WRS Header');
$xcrud_wrs_non_pr->benchmark(true);
$sub_table = $xcrud_wrs_non_pr_detail = $xcrud_wrs_non_pr->nested_table('WRS Detail', 'lpb_no', 'lpb_detail', 'lpb_no');
// sub_table begin
$xcrud_wrs_non_pr_detail->columns('lpb_no,po_item_id,qty,unit,price');
//,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn
$xcrud_wrs_non_pr_detail->fields('lpb_no,po_item_id,qty,price');
//non_pr_grn_detail_brand_price ,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn,
$xcrud_wrs_non_pr_detail->unset_title();
$xcrud_wrs_non_pr_detail->label('po_item_id', 'Description');
$xcrud_wrs_non_pr_detail->unset_edit();
$xcrud_wrs_non_pr_detail->label('lpb_no', 'WRS No.');
$xcrud_wrs_non_pr_detail->validation_required('po_item_id');
$xcrud_wrs_non_pr_detail->validation_required('qty');
$xcrud_wrs_non_pr_detail->set_attr('lpb_no', array('readOnly' => 'True'));
$xcrud_wrs_non_pr_detail->relation('po_item_id', 'eproc_m_description', 'material_id', 'description');
//,,'po_no = (select po_no from lpb where lpb_no = "{lpb_no}")'
$sub_table->connection('root', '', 'bcspurchase_2015');
// end sub_table
$data['content2'] = $xcrud_wrs_non_pr->render();
// //-
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('grn_non_pr', $data);
$this->load->view('commons/foot_r');
}
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');
}
<?php
echo Xcrud::get_instance()->table('payments');
/** nested table constructor */
public function nested_table($instance_name = '', $field = '', $inner_tbl = '', $tbl_field = '')
{
if ($instance_name && $field && $inner_tbl && $tbl_field) {
$fdata = $this->_parse_field_names($field, 'nested_table');
foreach ($fdata as $fitem) {
$this->inner_table_instance[$instance_name] = $fitem['table'] . '.' . $fitem['field'];
// name of nested object will be stored in parent instance
$instance = Xcrud::get_instance($instance_name);
// just another xcrud object
$instance->table($this->prefix . $inner_tbl);
$instance->is_inner = true;
// nested flag
$fdata2 = $this->_parse_field_names($tbl_field, 'nested_table', $inner_tbl);
$instance->inner_where[$fitem['table'] . '.' . $fitem['field']] = key($fdata2);
// this connects nested table with parent
// only one cycle
return $instance;
}
}
}
public function index()
{
ob_start();
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance('xcrud_pr');
$xcrud->connection('root', '', 'bcspurchase_2015');
$xcrud->table('lpb');
$xcrud->columns('lpb_no,lpb_date,po_no,received_by');
$xcrud->fields('lpb_no,lpb_date,po_no,received_by,user_group,no_urut,kategori');
$xcrud->unset_title();
$xcrud->label('user_group', '');
$xcrud->label('lpb_no', 'WRS No');
$xcrud->label('lpb_date', 'WRS Date');
$xcrud->label('kategori', '');
$xcrud->label('no_urut', '');
$xcrud->label('po_no', 'PO No.');
$xcrud->label('project_code', 'Project Code');
$xcrud->label('received_by', 'Received By');
$xcrud->set_attr('po_no', array('id' => 'po'));
$xcrud->validation_required('lpb_no');
$xcrud->validation_required('lpb_date');
$usergroup = GROUPDESC;
$kategori = "PR";
$xcrud->where("lpb.user_group='" . $usergroup . "' AND lpb.kategori ='" . $kategori . "' ");
$xcrud->set_attr('user_group', array('id' => 'user_group', 'type' => 'hidden', 'value' => $usergroup));
//optional ambil session
$xcrud->set_attr('no_urut', array('id' => 'no_urut', 'type' => 'hidden'));
//optional ambil session
$xcrud->set_attr('kategori', array('id' => 'kategori', 'type' => 'hidden', 'value' => $kategori));
//optional ambil session
$xcrud->set_attr('lpb_no', array('id' => 'lpb_no', 'ReadOnly' => 'True'));
//optional ambil session
$xcrud->set_attr('lpb_date', array('id' => 'lpb_date'));
//optional ambil session
$user = USER_NAME;
$xcrud->set_attr('received_by', array('readOnly' => 'True', 'id' => 'received_by', 'value' => $user));
//optional ambil session
$xcrud->set_attr('project_code', array('readOnly' => 'True', 'id' => 'project_code'));
//
$xcrud->unset_remove();
$xcrud->default_tab('WRS Header');
$xcrud->benchmark(true);
$sub_table = $lpbdetail = $xcrud->nested_table('WRS Detail', 'lpb_no', 'lpb_detail', 'lpb_no');
// sub_table begin
$sub_table->connection('root', '', 'bcspurchase_2015');
// end sub_table
$lpbdetail->columns('lpb_no,po_item_id,qty,unit');
//,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn
$lpbdetail->fields('lpb_no,po_item_id,qty,unit');
//non_pr_grn_detail_brand_price ,trans_grn_detail_non_pr_diskon,trans_grn_detail_non_pr_ppn,
$lpbdetail->label('lpb_no', 'WRS NO');
$lpbdetail->unset_edit();
$lpbdetail->unset_title();
$lpbdetail->relation('po_item_id', 'eproc_po_item_description', 'po_item_id', 'description', 'po_no = (select po_no from lpb where lpb_no = "{lpb_no}")');
//,
$lpbdetail->set_attr('lpb_no', array('readOnly' => 'True', 'id' => 'lpb_no'));
$lpbdetail->set_attr('po_item_id', array('id' => 'po_item_id'));
//
$lpbdetail->set_attr('qty', array('id' => 'qty'));
//
$lpbdetail->set_attr('unit', array('readOnly' => 'True', 'id' => 'unit'));
$lpbdetail->before_insert('update_balance');
//RUNS UPDATE BALANCE IN FUNCTION.PHP
$sub_table = $po_item = $xcrud->nested_table('PO Item', 'po_no', 'po_item', 'po_no');
// sub_table begin
$sub_table->connection('root', '', 'bcspurchase_2015');
// end sub_table
$po_item->columns('po_item_id,po_no,qty,unit,price,subtotal,discount,lpb_balance');
$po_item->change_type('subtotal', 'price', '0', array('prefix' => 'Rp. ', 'separator' => '.', 'point' => ','));
$po_item->column_class('subtotal', 'align-right');
$po_item->relation('po_item_id', 'eproc_po_item_description', 'po_item_id', 'description');
$po_item->unset_remove();
$po_item->unset_add();
$po_item->unset_edit();
$po_item->default_tab('Po details');
$po_item->unset_title();
$data['content'] = $xcrud->render();
//--------------------------------------------------------------------------------------------------------------------------------------------------------
$this->load->helper('xcrud');
$groupdesc = 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->unset_title();
$view_wrs->limit(10);
$view_wrs->benchmark();
$view_wrs->change_type('price', 'price', '0', array('prefix' => 'Rp. ', 'separator' => '.', 'point' => ','));
$view_wrs->column_class('price', 'align-right');
$view_wrs->sum('price', 'Total is {Price}');
$data['content4'] = $view_wrs->render();
//-----------------------------------------------------------------------------------------------------------------
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('grn', $data);
$this->load->view('commons/foot_r');
}
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table('payments');
$xcrud->table_name('This is table name!', 'And this is table tooltip...');
$xcrud->field_tooltip('checkNumber', 'Wow, check number? Really?');
$xcrud->column_tooltip('customerNumber', 'Yeah! Column tooltip!');
echo $xcrud->render();
public static function load_js()
{
$out = '';
if (self::$instance) {
$instance = reset(self::$instance);
$language = $instance->language;
$lang_arr = $instance->lang_arr;
} else {
$language = Xcrud_config::$language;
$lang_arr = self::_get_language_static();
}
if (!self::$css_loaded && !self::$instance) {
Xcrud_config::$scripts_url = self::check_url(Xcrud_config::$scripts_url, true);
Xcrud_config::$editor_url = self::check_url(Xcrud_config::$editor_url);
Xcrud_config::$editor_init_url = self::check_url(Xcrud_config::$editor_init_url);
}
if (self::$js_loaded) {
self::error('Xcrud\'s scripts already rendered! Please, set <strong>$manual_load = true</strong> in your configuration file');
}
self::$js_loaded = true;
if (Xcrud_config::$load_jquery) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/jquery.min.js"></script>';
}
if (Xcrud_config::$jquery_no_conflict) {
$out .= '
<script type="text/javascript">
<!--
jQuery.noConflict();
-->
</script>';
}
if (Xcrud_config::$load_jquery_ui) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/jquery-ui/jquery-ui.min.js"></script>';
}
if (Xcrud_config::$load_jcrop) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/jcrop/jquery.Jcrop.min.js"></script>';
}
if (Xcrud_config::$load_bootstrap) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/bootstrap/js/bootstrap.min.js"></script>';
}
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/timepicker/jquery-ui-timepicker-addon.js"></script>';
if (Xcrud_config::$editor_url) {
$out .= '<script src="' . Xcrud_config::$editor_url . '"></script>';
}
if (Xcrud_config::$load_googlemap) {
$out .= '<script src="//maps.google.com/maps/api/js?sensor=false&language=' . $language . '"></script>';
}
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$plugins_uri . '/xcrud.js"></script>';
$config = array('url' => Xcrud_config::$scripts_url . '/' . Xcrud_config::$ajax_uri, 'editor_url' => Xcrud_config::$editor_url, 'editor_init_url' => Xcrud_config::$editor_init_url, 'force_editor' => Xcrud_config::$force_editor, 'date_first_day' => Xcrud_config::$date_first_day, 'date_format' => Xcrud_config::$date_format, 'time_format' => Xcrud_config::$time_format, 'lang' => $lang_arr, 'rtl' => Xcrud_config::$is_rtl ? 1 : 0);
$out .= '
<script type="text/javascript">
<!--
var xcrud_config = ' . json_encode($config) . ';
-->
</script>';
if ($language != 'en') {
if (is_file(XCRUD_PATH . '/' . Xcrud_config::$lang_path . '/datepicker/jquery.ui.datepicker-' . $language . '.js')) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$lang_uri . '/datepicker/jquery.ui.datepicker-' . $language . '.js"></script>';
}
if (is_file(XCRUD_PATH . '/' . Xcrud_config::$lang_path . '/timepicker/jquery-ui-timepicker-' . $language . '.js')) {
$out .= '<script src="' . Xcrud_config::$scripts_url . '/' . Xcrud_config::$lang_uri . '/timepicker/jquery-ui-timepicker-' . $language . '.js"></script>';
}
}
return $out;
}
<?php
include 'xcrud.php';
header('Content-Type: text/html; charset=' . Xcrud_config::$mbencoding);
echo Xcrud::get_requested_instance();
function xcrud_restore_session()
{
$CI =& get_instance();
$CI->load->library('session');
Xcrud::import_session($CI->session->userdata('xcrud_sess'));
}
public function index()
{
$this->load->helper('xcrud');
$xcrud = Xcrud::get_instance('instance1');
$xcrud->table('trans_mstr_unit');
$xcrud->table_name('Master Unit');
$xcrud->columns('nomor_unit,
kode_unit,
nama_tipe,
nama_produk,
axle_arr ,
no_rangka,
no_mesin,
project_area,
sub_project,supir1,
aktif');
$xcrud->fields('nomor_unit,
nama_tipe,
pemilik,
tahun,
no_rangka,
no_mesin,
kode_unit,
aktif', false, 'Detail I');
$xcrud->fields('axle_arr,
nama_produk,
project_area,
sub_project,
helper', false, 'Detail II');
$xcrud->relation('pemilik', 'trans_mstr_owner', 'kode_owner', 'nama_owner');
$xcrud->relation('tipe_unit', 'trans_mstr_tipe_unit', 'kode_tipe_unit', 'nama_tipe');
$xcrud->relation('nama_tipe', 'trans_mstr_tipeunit', 'nama_tipe', 'nama_tipe');
//$xcrud->relation('nama_produk','estation_product','nama','nama');
$xcrud->relation('nama_produk', 'service_product_model', 'unit_model_id', 'unit_model_model_name');
$xcrud->relation('project_area', 'eproc_service_project', 'project_code', 'project_site');
$xcrud->relation('supir1', 'trans_mstr_supir', 'kode_personil', 'nama_personil');
$xcrud->relation('supir2', 'trans_mstr_supir', 'kode_personil', 'nama_personil');
$xcrud->relation('supir3', 'trans_mstr_supir', 'kode_personil', 'nama_personil');
$xcrud->relation('supir4', 'trans_mstr_supir', 'kode_personil', 'nama_personil');
$xcrud->relation('helper', 'trans_mstr_supir', 'kode_personil', 'nama_personil', 'kode="H"');
$xcrud->change_type('bussiness_unit', 'radio', 'Transportation', 'Dump Truck, Transportation, Outsourcing');
$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->label('nama_produk', 'Product & Model');
$xcrud->label('no_proyek', 'Project Area');
$xcrud->label('nomor_unit', 'Nomor Polisi');
$xcrud->label('nama_tipe', 'Type Unit');
$xcrud->unset_remove();
$xcrud->unset_title();
$mst_unit_surat = $xcrud->nested_table('Dokumentasi', 'id', 'trans_mstr_unit_surat', 'id_unit');
$mst_unit_surat->unset_title();
$mst_unit_surat->default_tab('Detail Information');
$mst_unit_surat->table_name('Detail Material');
$mst_unit_surat->columns('jenis_surat,tgl_expired,attachment');
$mst_unit_surat->fields('jenis_surat,no_dokumen,tgl_expired,attachment,attachment_2');
$mst_unit_surat->change_type('attachment', 'image');
$mst_unit_surat->change_type('attachment_2', 'image');
$data['content'] = $xcrud->render();
//--------------------------------------------------------------------
$this->load->helper('xcrud');
$xcrud2 = Xcrud::get_instance('instance2');
$xcrud2->table('trans_mstr_tipeunit');
$xcrud2->columns('nama_tipe,tipeunit_no');
$xcrud2->fields('nama_tipe,tipeunit_no');
$xcrud2->label('category_id', 'Category Code ');
$xcrud2->label('tipeunit_no', 'Type No');
$xcrud2->default_tab('Vehicle Type');
$xcrud2->unset_title();
$data['content2'] = $xcrud2->render();
//--------------------------------------------------------------------
$this->load->helper('xcrud');
$modeldanproduc = Xcrud::get_instance('instance3');
$modeldanproduc->table('trans_mstr_unit_product');
$modeldanproduc->table_name('Product & Model');
$modeldanproduc->columns('unit_product_no,nama');
$modeldanproduc->fields('unit_product_no,nama');
//$modeldanproduc->set_attr('id',array('readonly'=>'True'));
$modeldanproduc->label('nama', 'Product Name');
$modeldanproduc->limit(10);
$modeldanproduc->default_tab('Product');
$modeldanproduc->unset_title();
$trans_mstr_unit_model = $modeldanproduc->nested_table('Model', 'id', 'trans_mstr_unit_model', 'unit_model_product');
// 2nd level
$trans_mstr_unit_model->columns('unit_model_id', true);
$trans_mstr_unit_model->fields('unit_model_no,unit_model_product,unit_model_model_name');
//$trans_mstr_unit_model->set_attr('unit_model_id',array('disabled'=>''));
$trans_mstr_unit_model->set_attr('unit_model_product', array('disabled' => ''));
$trans_mstr_unit_model->label('unit_model_product', 'Product Name');
$trans_mstr_unit_model->label('unit_model_model_name', 'Model Name');
$trans_mstr_unit_model->relation('unit_model_product', 'trans_mstr_unit_product', 'id', 'nama');
$trans_mstr_unit_model->default_tab('');
$trans_mstr_unit_model->limit(10);
$data['content3'] = $modeldanproduc->render();
//'create','edit',12
//--------------------------------------------------------------------
$meta = $this->meta;
$this->load->view('commons/header', $meta);
$this->load->view('unit', $data);
$this->load->view('commons/footer');
}
