public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_model('My_Custom_model');
$crud->set_table('ips_ordertracking', 'ips_productitems');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
// void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] )
$crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category');
// $crud->set_relation('ordertrackingid','ips_productitems','description');
// $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action');
// $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID');
$crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action');
$crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
$crud->callback_column('fullfillment', array($this, '_callback_fullfillment'));
// $crud->callback_column('product',array($this,'_callback_product'));
$crud->callback_column('status', array($this, '_callback_status'));
$crud->callback_column('itemrece', array($this, '_callback_itemrece'));
$crud->callback_column('cost', array($this, '_callback_recovery_min'));
$crud->callback_column('mrp', array($this, '_callback_recovery_max'));
$crud->callback_column('Action', array($this, '_callback_viewpage_url'));
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
if ($state == 'view') {
redirect('store/viewtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
public function checkout($id)
{
if (!($master = $this->model_proposal->getDataProposal($id))) {
redirect('proposal');
}
$this->load->library('grocery_CRUD');
$this->load->model('grocery_CRUD_Model');
$crud = new grocery_CRUD();
$crud->set_model('CheckoutModel');
$crud->set_table('proposal_detail');
//Change to your table name
$crud->columns('name', 'brand', 'unit', 'size', 'qty', 'price', 'discount', 'discount_price', 'sub_total', 'ppn', 'final_sub_total');
$crud->basic_model->getDataProposalDetail($id);
$crud->callback_column('unit', array($this, '_callback_unit'));
$crud->callback_column('price', array($this, '_callback_currency'));
$crud->callback_column('discount', array($this, '_callback_currency'));
$crud->callback_column('discount_price', array($this, '_callback_currency'));
$crud->callback_column('sub_total', array($this, '_callback_currency'));
$crud->callback_column('ppn', array($this, '_callback_currency'));
$crud->callback_column('final_sub_total', array($this, '_callback_currency'));
$crud->display_as('final_sub_total', 'total');
//
$crud->unset_add()->unset_edit()->unset_delete()->unset_print()->unset_read();
$output = $crud->render();
// $this->render($output);
$data['output'] = $output;
$data['master'] = $master;
$data['proposal_type'] = $this->proposal_type[$master->type];
$data['status_ppn'] = $this->status_ppn[$master->status_ppn];
$this->parser->parse("list_detail.tpl", $data);
// $data['items'] = $this->model_proposal->getDataProposalDetail($id);
// $this->parser->parse("proposal_checkout.tpl", $data);
}
