public function postDlxl()
{
$this->heads = null;
$this->fields = $this->default_export_fields;
/*
$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('merchant_id',array('kind'=>'text','query'=>'like','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('actual_weight',array('kind'=>'text','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 = 'first';
$this->show_select = true;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$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('TREFERENCE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('ACCNT_CODE', array('kind' => 'text', 'callback' => 'accDesc', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DESCRIPTN', array('kind' => 'text', '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('AMOUNT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('AMOUNT', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DESCRIPTN', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$this->def_order_dir = 'DESC';
$this->def_order_by = 'TRANS_DATETIME';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('ACNT_CODE', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('DESCR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('S_HEAD', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('LOOKUP', array('kind' => 'text', 'query' => 'like', 'pos' => 'both')), array('LONG_DESCR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both')), array('LAST_CHANGE_DATETIME', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)));
$this->def_order_dir = 'ASC';
$this->def_order_by = 'ACNT_CODE';
return parent::postDlxl();
}
public function postDlxl()
{
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('SKU', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('itemDescription', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'attr' => array('class' => 'expander'), 'show' => true)), array('series', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('itemGroup', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('category', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('L', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('W', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('H', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('D', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('colour', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('material', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tags', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = $this->default_fields;
$db = Config::get('jayon.main_db');
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
$this->place_action = 'first';
$this->show_select = true;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('SKU', array('kind' => 'text', 'callback' => 'namePic', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('itemDescription', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('locationId', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('locationName', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tags', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('merchantname', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('id', array('kind' => 'numeric', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shopcategory', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('shopcategoryLink', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('email', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('street', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetimerange', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = $this->default_fields;
$this->def_order_by = 'identifier';
$this->def_order_dir = 'desc';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$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)));
$this->def_order_by = 'ordertime';
$this->def_order_dir = 'desc';
return parent::postDlxl();
}
public function postAwbdlxl()
{
$this->heads = Config::get('jex.default_awb_heads');
$this->fields = Config::get('jex.default_awb_fields');
$this->search_fields = Config::get('jex.default_fields');
//$this->export_output_fields = Config::get('jex.default_awb_fields');
$db = Config::get('jayon.main_db');
$this->def_order_by = 'pick_up_date';
$this->def_order_dir = 'desc';
$this->place_action = 'first';
$this->show_select = true;
$this->sql_key = 'delivery_id';
$this->sql_table_name = Config::get('jayon.incoming_delivery_table');
$this->sql_connection = 'mysql';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('name', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('slug', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('venue', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('phone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('latitude', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('longitude', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('category', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('description', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tags', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('IP', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('OS', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('PIC', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('PicPhone', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('PicEmail', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('SKU', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('assetType', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('contractNumber', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('hostName', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('itemDescription', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('locationId', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('locationName', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('rackId', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('rackName', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('owner', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('status', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('labelStatus', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('powerStatus', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('virtualStatus', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('rackId', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tags', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
public function postDlxl()
{
//$this->def_order_by = 'ordertime';
//$this->def_order_dir = 'desc';
return parent::postDlxl();
}
public function postDlxl()
{
$this->heads = null;
$this->fields = array(array('propertyId', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('sourceID', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('number', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('address', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('city', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('zipCode', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('state', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('bed', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('bath', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('pool', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('garage', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('basement', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('category', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tags', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('propertyStatus', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('houseSize', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lotSize', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('listingPrice', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('FMV', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('monthlyRental', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('leaseStartDate', array('kind' => 'date', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('leaseTerms', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('annualRental', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('dpsqft', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('equity', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('HOA', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('OPR', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('ROI', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('ROIstar', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('RentalYield', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('insurance', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('description', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('maintenanceAllowance', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('parcelNumber', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('propManagement', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('propertyManager', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('publishDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('publishStatus', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('reservedAt', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('reservedBy', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('section8', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('sequence', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('specialConditionRemarks', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('tax', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('type', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('typeOfConstruction', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('vacancyAllowance', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('yearBuilt', array('kind' => 'text', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('createdDate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)), array('lastUpdate', array('kind' => 'datetime', 'query' => 'like', 'pos' => 'both', 'show' => true)));
return parent::postDlxl();
}
