/** * 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); }
function xcrud_get_instance($name = true) { return Xcrud::get_instance($name); }
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'); }
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'); }
function xcrud_get_instance($name = false) { $CI =& get_instance(); $CI->load->library('session'); $CI->load->helper('url'); Xcrud_config::$scripts_url = base_url(''); $xcrud = Xcrud::get_instance($name); return $xcrud; }
/** * 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 $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();
/** 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 $instance->inner_where[$fitem['table'] . '.' . $fitem['field']] = $inner_tbl . '.' . $tbl_field; // this connects nested table with parent return $instance; // only one cycle } } }
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');
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() { 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'); }
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'); }