public function rows_post_process($rows, $aux = null)
{
//print_r($this->aux_data);
$total_base = 0;
$total_converted = 0;
$end = 0;
$br = array_fill(0, $this->column_count(), '');
$nrows = array();
$subhead1 = '';
$subhead2 = '';
$subhead3 = '';
$seq = 0;
$subamount1 = 0;
$subamount2 = 0;
if (count($rows) > 0) {
for ($i = 0; $i < count($rows); $i++) {
//print_r($rows[$i]['extra']);
if ($subhead1 == '' || $subhead1 != $rows[$i][1] || $subhead2 != $rows[$i][4]) {
$headline = $br;
if ($subhead1 != $rows[$i][1]) {
$headline[1] = '<b>' . $rows[$i]['extra']['PERIOD'] . '</b>';
} else {
$headline[1] = '';
}
$headline[4] = '<b>' . $rows[$i]['extra']['ACCNT_CODE'] . '</b>';
$headline['extra']['rowclass'] = 'row-underline';
if ($subhead1 != '') {
$amtline = $br;
$amtline[8] = '<b>' . Ks::idr($subamount1) . '</b>';
$amtline[10] = '<b>' . Ks::idr($subamount2) . '</b>';
$amtline['extra']['rowclass'] = 'row-doubleunderline row-overline';
$nrows[] = $amtline;
$subamount1 = 0;
$subamount2 = 0;
}
$subamount1 += $rows[$i]['extra']['OTHER_AMT'];
$subamount2 += $rows[$i]['extra']['AMOUNT'];
$nrows[] = $headline;
$seq = 1;
$rows[$i][0] = $seq;
$rows[$i][8] = $rows[$i]['extra']['CONV_CODE'] == 'IDR' ? Ks::idr($rows[$i][8]) : '';
$rows[$i][9] = $rows[$i]['extra']['CONV_CODE'] == 'IDR' ? Ks::dec2($rows[$i][9]) : '';
$rows[$i][10] = Ks::usd($rows[$i][10]);
$nrows[] = $rows[$i];
} else {
$seq++;
$rows[$i][0] = $seq;
$rows[$i][8] = $rows[$i]['extra']['CONV_CODE'] == 'IDR' ? Ks::idr($rows[$i][8]) : '';
$rows[$i][9] = $rows[$i]['extra']['CONV_CODE'] == 'IDR' ? Ks::dec2($rows[$i][9]) : '';
$rows[$i][10] = Ks::usd($rows[$i][10]);
$nrows[] = $rows[$i];
}
$total_base += doubleval($rows[$i][8]);
$total_converted += doubleval($rows[$i][10]);
$end = $i;
$subhead1 = $rows[$i][1];
$subhead2 = $rows[$i][4];
}
// show total Page
if ($this->column_count() > 0) {
$tb = $br;
$tb[1] = 'Total Page';
$tb[8] = Ks::idr($total_base);
$tb[10] = Ks::usd($total_converted);
$nrows[] = $tb;
if (!is_null($this->aux_data)) {
$td = $br;
$td[1] = 'Total';
$td[8] = Ks::idr($aux['total_data_base']);
$td[10] = Ks::usd($aux['total_data_converted']);
$nrows[] = $td;
}
}
return $nrows;
} else {
return $rows;
}
// show total queried
}
<?php
return array('tracker_app' => 'com.kickstartlab.android.mctracker', 'hub_app' => 'com.kickstartlab.android.mcwarehouse', 'pickup_app' => 'com.kickstartlab.android.mcpickup', 'buckets' => array('incoming' => 'Incoming', 'dispatcher' => 'Dispatcher', 'tracker' => 'Tracker', 'archive' => 'Archive'), 'move_options' => array('dispatched' => 'Dispatcher', 'inprogress' => 'Tracker'), 'logistic_type_select' => array('' => 'All', 'internal' => 'Internal', 'external' => 'External'), 'node_type' => array('hub' => 'Hub', 'warehouse' => 'Warehouse', 'courier' => 'Courier', '3pl' => '3PL'), 'default_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('TRIP', array('search' => true, 'style' => 'max-width:50px;', 'sort' => true)), array('STATUS', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:175px;', 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('LOGISTIC TYPE', array('search' => true, 'select' => array('' => 'All', 'internal' => 'Internal', 'external' => 'External'), 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CUST ID', array('search' => true, 'sort' => true)), array('DELIVERY ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('COD VALUE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true))), 'default_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'callback' => 'statusList', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'courier_status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic_type', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'callback' => 'dupeFF', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod', array('kind' => 'currency', 'callback' => 'internalCod', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_V', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_export_heads' => array(array('Created Date', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('Status', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:250px;', 'sort' => true)), array('Courier status', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:250px;', 'sort' => true)), array('Pickup status', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:250px;', 'sort' => true)), array('3PL status', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:250px;', 'sort' => true)), array('Warehouse status', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:250px;', 'sort' => true)), array('Consig', array('search' => true, 'sort' => true)), array('Order ID', array('search' => true, 'sort' => true)), array('Pick up date', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('Trip', array('search' => true, 'sort' => true)), array('Fulfillment id', array('search' => true, 'sort' => true)), array('Number of package', array('search' => true, 'sort' => true)), array('Cod value', array('search' => true, 'sort' => true)), array('Email', array('search' => true, 'sort' => true)), array('Name', array('search' => true, 'sort' => true)), array('Addr', array('search' => true, 'style' => 'min-width:120px;width:120px !important;', 'sort' => true)), array('City', array('search' => true, 'sort' => true)), array('District', array('search' => true, 'sort' => true)), array('Region', array('search' => true, 'sort' => true)), array('Zip', array('search' => true, 'sort' => true)), array('Phone', array('search' => true, 'sort' => true)), array('Contact', array('search' => true, 'sort' => true)), array('Desc', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('Awb', array('search' => true, 'sort' => true)), array('Cust ID', array('search' => true, 'sort' => true)), array('Service', array('search' => true, 'sort' => true)), array('Insurance', array('search' => true, 'sort' => true))), 'default_export_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('courier_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('pickup_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('3pl_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('warehouse_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_zoning_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('CITY', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('TRIP', array('search' => true, 'style' => 'max-width:50px;', 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true))), 'default_zoning_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_courierassign_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('DEVICE ID', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('TRIP', array('search' => true, 'style' => 'max-width:50px;', 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CONS CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true))), 'default_courierassign_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('device_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_dispatched_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('TRIP', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('DEVICE NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('COURIER NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('STATUS', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:175px;', 'sort' => true)), array('3PL STATUS', array('search' => true, 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('PENDING COUNT', array('search' => true, 'sort' => true)), array('LAST ACTION', array('search' => true, 'sort' => true)), array('PICTURES', array('search' => false, 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CONS CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('DELIVERY ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('COD VALUE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true)), array('UPLOADED', array('search' => true, 'sort' => true))), 'default_dispatched_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('device_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('courier_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'callback' => 'statusList', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('logistic_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('last_action', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'text', 'callback' => 'picList', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'callback' => 'dupeFF', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('uploaded', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_dispatched_export_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('TRIP', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('DEVICE NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('COURIER NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('STATUS', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:175px;', 'sort' => true)), array('3PL STATUS', array('search' => true, 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('PENDING COUNT', array('search' => true, 'sort' => true)), array('LAST ACTION', array('search' => true, 'sort' => true)), array('PICTURES', array('search' => false, 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CONS CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('DELIVERY ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('COD VALUE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true)), array('UPLOADED', array('search' => true, 'sort' => true))), 'default_dispatched_export_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('trip', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('device_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('courier_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('last_action', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('uploaded', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_delivered_heads' => array(array('CREATED DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('PICK UP DATE', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('DELIVERED AT', array('search' => true, 'sort' => true, 'style' => 'min-width:120px;', 'daterange' => true)), array('DEVICE NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('COURIER NAME', array('search' => true, 'style' => 'min-width:120px;', 'sort' => true)), array('STATUS', array('search' => true, 'select' => Ks::statusoptions(), 'style' => 'min-width:175px;', 'sort' => true)), array('3PL STATUS', array('search' => true, 'sort' => true)), array('3PL PICK UP', array('search' => true, 'sort' => true)), array('3PL NOTE', array('search' => true, 'sort' => true)), array('PENDING COUNT', array('search' => true, 'sort' => true)), array('PICTURES', array('search' => false, 'sort' => true)), array('CURR POSITION', array('search' => true, 'select' => Prefs::getPosition()->PositionToSelection('node_code', 'name'), 'sort' => true)), array('LOGISTIC', array('search' => true, 'sort' => true)), array('SERVICE', array('search' => true, 'sort' => true)), array('CONSIG', array('search' => true, 'sort' => true)), array('AWB', array('search' => true, 'sort' => true)), array('CONS CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true)), array('NUMBER OF PACKAGE', array('search' => true, 'sort' => true)), array('COD VALUE', array('search' => true, 'sort' => true)), array('EMAIL', array('search' => true, 'sort' => true)), array('NAME', array('search' => true, 'sort' => true)), array('ADDR', array('search' => true, 'style' => 'min-width:250px;width:250px !important;', 'sort' => true)), array('CITY', array('search' => true, 'sort' => true)), array('DISTRICT', array('search' => true, 'sort' => true)), array('REGION', array('search' => true, 'sort' => true)), array('ZIP', array('search' => true, 'sort' => true)), array('PHONE', array('search' => true, 'sort' => true)), array('CONTACT', array('search' => true, 'sort' => true)), array('DESC', array('search' => true, 'sort' => true)), array('W/V', array('search' => true, 'sort' => true)), array('INSURANCE', array('search' => true, 'sort' => true))), 'default_delivered_fields' => array(array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pick_up_date', array('kind' => 'daterange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('delivered_time', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('device_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('courier_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'callback' => 'statusList', 'query' => 'like', 'pos' => 'both', 'show' => true, 'multi' => array('status', 'warehouse_status', 'pickup_status'), 'multirel' => 'OR')), array('logistic_status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic_pickup_time', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic_last_note', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pending_count', array('kind' => 'text', 'callback' => 'picList', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('position', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('logistic', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_service', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consig', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number_of_package', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('cod', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_addr', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('district', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_region', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_zip', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contact', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_desc', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('w_v', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_inst_amt', array('kind' => 'currency', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_log_heads' => array(array('TIMESTAMP', array('search' => true, 'sort' => true, 'style' => 'min-width:90px;', 'daterange' => true)), array('DELIVERY ID', array('search' => true, 'sort' => true, 'style' => '')), array('FULFILLMENT ID', array('search' => true, 'sort' => true, 'style' => '')), array('TYPE', array('search' => true, 'sort' => true, 'style' => '')), array('ACTION', array('search' => true, 'sort' => true, 'style' => '')), array('REASON', array('search' => true, 'style' => '', 'sort' => true)), array('ACTOR', array('search' => true, 'style' => '', 'sort' => true))), 'default_log_fields' => array(array('timestamp', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('object.delivery_id', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('object.fulfillment_code', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('objectType', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('action', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('reason', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('actor', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true))), 'default_awb_heads' => array(array('AWB', array('search' => true, 'sort' => true)), array('CONS CUST ID', array('search' => true, 'sort' => true)), array('ORDER ID', array('search' => true, 'sort' => true)), array('FULFILLMENT ID', array('search' => true, 'sort' => true))), 'default_awb_fields' => array(array('awb', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_cust', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('no_sales_order', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('consignee_olshop_orderid', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true))));
public function toIdr($data, $field)
{
return '<h5 style="text-align:right;">IDR ' . Ks::idr($data[$field]) . '</h5>';
}
public function unitPrice($data)
{
return Ks::idr($data['productDetail']['priceRegular']);
}
