public function getStatic()
{
$this->heads = array(array('Timestamp', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PU Time', array('search' => true, 'sort' => true, 'style' => 'min-width:100px;', 'daterange' => true)), array('PU Pic', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;')), array('PU Person & Device', array('search' => true, 'style' => 'min-width:100px;', 'sort' => true)), array('Requested Delivery Date', array('search' => true, 'style' => 'min-width:125px;', 'sort' => true, 'daterange' => true)), array('Requested Slot', array('search' => true, 'sort' => true)), array('Zone', array('search' => true, 'sort' => true)), array('City', array('search' => true, 'sort' => true)), array('Shipping Address', array('search' => true, 'sort' => true, 'style' => 'max-width:200px;width:200px;')), array('No Invoice', array('search' => true, 'sort' => true)), array('Type', array('search' => true, 'sort' => true)), array('Merchant & Shop Name', array('search' => true, 'sort' => true)), array('Box ID', array('search' => true, 'sort' => true)), array('Status', array('search' => true, 'sort' => true)), array('Directions', array('search' => true, 'sort' => true)), array('Signatures', array('search' => true, 'sort' => true)), array('Delivery Charge', array('search' => true, 'sort' => true)), array('COD Surcharge', array('search' => true, 'sort' => true)), array('COD Value', array('search' => true, 'sort' => true)), array('Buyer', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('Phone', array('search' => true, 'sort' => true)), array('W x H x L = V', array('search' => true, 'sort' => true)), array('Weight Range', array('search' => true, 'sort' => true)));
//print $this->model->where('docFormat','picture')->get()->toJSON();
$this->title = 'General Ledger';
Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
//$this->additional_filter = View::make(strtolower($this->controller_name).'.addfilter')->with('submit_url','gl/static')->render();
//$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': $('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': $('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': $('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': $('#acc-code-to').val() }, { 'name':'acc-company', 'value': $('#acc-company').val() } );";
$this->product_info_url = strtolower($this->controller_name) . '/info';
$this->printlink = strtolower($this->controller_name) . '/print';
//table generator part
$this->fields = array(array('ordertime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickuptime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverytime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryslot', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryzone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverycity', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('merchant_trans_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_type', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array(Config::get('jayon.jayon_members_table') . '.merchantname', array('kind' => 'text', 'alias' => 'merchant_name', 'query' => 'like', 'callback' => 'merchantInfo', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('directions', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_cost', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod_cost', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('total_price', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyer_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('volume', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('weight', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$db = Config::get('jayon.main_db');
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
$this->place_action = 'none';
$this->show_select = false;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
$this->responder_type = 's';
return parent::printGenerator();
}
public function getStatic()
{
$this->heads = $this->default_heads;
//print $this->model->where('docFormat','picture')->get()->toJSON();
$this->title = 'Couriers';
Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
//$this->additional_filter = View::make(strtolower($this->controller_name).'.addfilter')->with('submit_url','gl/static')->render();
//$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': $('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': $('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': $('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': $('#acc-code-to').val() }, { 'name':'acc-company', 'value': $('#acc-company').val() } );";
$this->product_info_url = strtolower($this->controller_name) . '/info';
$this->printlink = strtolower($this->controller_name) . '/print';
//table generator part
$this->fields = $this->default_fields;
$db = Config::get('jayon.main_db');
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
$this->place_action = 'none';
$this->show_select = false;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
$this->responder_type = 's';
return parent::printGenerator();
}
public function getStatic()
{
$this->heads = array(array('Device Identifier', array('search' => true, 'sort' => true)), array('Description', array('search' => true, 'sort' => true)), array('Name', array('search' => true, 'sort' => true)), array('Key', array('search' => true, 'sort' => true)), array('Number', array('search' => true, 'sort' => true, 'date' => true)), array('District', array('search' => true, 'sort' => true, 'date' => true)), array('City', array('search' => true, 'sort' => true, 'date' => true)), array('Path Color', array('search' => true, 'sort' => true, 'date' => true)), array('Status', array('search' => true, 'sort' => true, 'date' => true)));
//print $this->model->where('docFormat','picture')->get()->toJSON();
$this->title = 'General Ledger';
Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
//$this->additional_filter = View::make(strtolower($this->controller_name).'.addfilter')->with('submit_url','gl/static')->render();
//$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': $('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': $('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': $('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': $('#acc-code-to').val() }, { 'name':'acc-company', 'value': $('#acc-company').val() } );";
$this->product_info_url = strtolower($this->controller_name) . '/info';
$this->printlink = strtolower($this->controller_name) . '/print';
//table generator part
$this->fields = array(array('identifier', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('descriptor', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('devname', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('key', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('password', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('mobile', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('color', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('is_on', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$db = Config::get('jayon.main_db');
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
$this->place_action = 'none';
$this->show_select = false;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
$this->responder_type = 's';
return parent::printGenerator();
}
public function getStatic()
{
$this->heads = array(array('Period', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('Date', array('search' => true, 'sort' => true, 'style' => 'min-width:100px;', 'daterange' => true)), array('JV Ref', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;')), array('Account', array('search' => true, 'style' => 'min-width:100px;', 'sort' => true)), array('Account Description', array('search' => true, 'style' => 'min-width:125px;', 'sort' => true)), array('Reference Doc.', array('search' => true, 'sort' => true)), array('Orig. Currency', array('search' => true, 'sort' => true)), array('Orig. Amount', array('search' => true, 'sort' => true)), array('Conversion Rate', array('search' => true, 'sort' => true)), array('Base Amount', array('search' => true, 'sort' => true)), array('Transaction Description', array('search' => true, 'sort' => true)));
//print $this->model->where('docFormat','picture')->get()->toJSON();
$this->title = 'AFE Report - Ledger Query';
$this->place_action = 'none';
$this->show_select = false;
Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
$this->additional_filter = View::make(strtolower($this->controller_name) . '.addfilter')->with('submit_url', 'afegl/static')->render();
$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': \$('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': \$('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': \$('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': \$('#acc-code-to').val() }, { 'name':'acc-company', 'value': \$('#acc-company').val() },{ 'name':'acc-afe', 'value': \$('#acc-afe').val() } );";
$this->product_info_url = strtolower($this->controller_name) . '/info';
$this->printlink = strtolower($this->controller_name) . '/print';
//table generator part
$this->fields = array(array('PERIOD', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('TRANS_DATETIME', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('VCHR_NUM', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('ACCNT_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('j10_acnt.DESCR', array('kind' => 'text', 'alias' => 'ACC_DESCR', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('TREFERENCE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('CONV_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('OTHER_AMT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'class' => 'column-amt')), array('BASE_RATE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'class' => 'column-amt')), array('AMOUNT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'class' => 'column-amt')), array('DESCRIPTN', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$db = Config::get('lundin.main_db');
$company = Input::get('acc-company');
$company = strtolower($company);
if (Schema::hasTable($db . '.' . $company . '_a_salfldg')) {
$company = Config::get('lundin.default_company');
}
$company = strtolower($company);
$this->def_order_by = 'TRANS_DATETIME';
$this->def_order_dir = 'DESC';
$this->place_action = 'none';
$this->show_select = false;
$this->sql_key = 'TRANS_DATETIME';
$this->sql_table_name = $company . '_a_salfldg';
$this->sql_connection = 'mysql2';
$this->responder_type = 's';
return parent::printGenerator();
}
public function getStatic()
{
$this->heads = Config::get('jex.default_log_heads');
//print $this->model->where('docFormat','picture')->get()->toJSON();
$this->title = 'General Ledger';
Breadcrumbs::addCrumb('Cost Report', URL::to(strtolower($this->controller_name)));
//$this->additional_filter = View::make(strtolower($this->controller_name).'.addfilter')->with('submit_url','gl/static')->render();
//$this->js_additional_param = "aoData.push( { 'name':'acc-period-to', 'value': $('#acc-period-to').val() }, { 'name':'acc-period-from', 'value': $('#acc-period-from').val() }, { 'name':'acc-code-from', 'value': $('#acc-code-from').val() }, { 'name':'acc-code-to', 'value': $('#acc-code-to').val() }, { 'name':'acc-company', 'value': $('#acc-company').val() } );";
$this->product_info_url = strtolower($this->controller_name) . '/info';
$this->printlink = strtolower($this->controller_name) . '/print';
//table generator part
$this->fields = array(array(Config::get('jayon.jayon_members_table') . '.merchantname', array('kind' => 'text', 'alias' => 'merchant_name', 'query' => 'like', 'callback' => 'merchantInfo', 'pos' => 'both', 'show' => true)), array('ordertime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickuptime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pickup_person', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverytime', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryslot', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliveryzone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('buyerdeliverycity', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shipping_address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('fulfillment_code', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('merchant_trans_id', array('kind' => 'text', 'callback' => 'dispBar', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_type', array('kind' => 'text', 'callback' => 'colorizetype', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('directions', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$db = Config::get('jayon.main_db');
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
$this->place_action = 'none';
$this->show_select = false;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
$this->responder_type = 's';
return parent::printGenerator();
}
