/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'price_match_record');
DaoMap::setManyToOne('min', 'PriceMatchMin', 'price_match_record_min');
DaoMap::setManyToOne('company', 'PriceMatchCompany', 'price_match_record_company');
DaoMap::setStringType('url', 'varchar', 255);
DaoMap::setIntType('price', 'double', '10,4');
DaoMap::setStringType('name', 'varchar', 100);
parent::__loadDaoMap();
DaoMap::createIndex('price');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'price_match_min');
DaoMap::setStringType('sku', 'varchar', 50);
DaoMap::setManyToOne('record', 'PriceMatchRecord', 'price_match_min_record', true);
parent::__loadDaoMap();
DaoMap::createIndex('sku');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'rec_item');
DaoMap::setManyToOne('purchaseOrder', 'PurchaseOrder', 'rec_item_po');
DaoMap::setManyToOne('product', 'Product', 'rec_item_pro');
DaoMap::setIntType('unitPrice', 'double', '10,4');
DaoMap::setStringType('serialNo', 'varchar', '100');
DaoMap::setStringType('invoiceNo', 'varchar', '20');
DaoMap::setIntType('qty', 'int', 10, false);
parent::__loadDaoMap();
DaoMap::createIndex('serialNo');
DaoMap::createIndex('unitPrice');
DaoMap::createIndex('invoiceNo');
DaoMap::setIntType('qty');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro_cate');
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
DaoMap::setManyToOne('parent', __CLASS__, 'pro_cate_parent', true);
DaoMap::setManyToOne('root', __CLASS__, 'pro_cate_root', true);
DaoMap::setStringType('position', 'varchar', 255);
DaoMap::setIntType('mageId');
DaoMap::setManyToOne('productAttributeSet', 'ProductAttributeSet', 'pro_cate_as', true);
DaoMap::setBoolType('isFromB2B');
DaoMap::setBoolType('isAnchor');
DaoMap::setBoolType('includeInMenu');
DaoMap::setStringType('urlKey', 'varchar', 50);
parent::__loadDaoMap();
DaoMap::createUniqueIndex('name');
DaoMap::createIndex('position');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('mageId');
DaoMap::createIndex('isAnchor');
DaoMap::createIndex('includeInMenu');
DaoMap::createIndex('urlKey');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ost');
DaoMap::setStringType('name', 'varchar', 32);
DaoMap::setStringType('mageStatus', 'varchar', 50);
parent::__loadDaoMap();
DaoMap::createUniqueIndex('name');
DaoMap::createIndex('mageStatus');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'py');
DaoMap::setManyToOne('order', 'Order', 'ord', true);
DaoMap::setManyToOne('creditNote', 'CreditNote', 'py_cn', true);
DaoMap::setManyToOne('method', 'PaymentMethod', 'py_method');
DaoMap::setIntType('value', 'Double', '10,4', false);
DaoMap::setStringType('type', 'varchar', '10');
DaoMap::setDateType('paymentDate');
parent::__loadDaoMap();
DaoMap::createIndex('type');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro_att');
DaoMap::setIntType('attributeSetMageId');
DaoMap::setStringType('code', 'varchar', 100);
DaoMap::setStringType('type', 'varchar', 100);
DaoMap::setBoolType('required');
DaoMap::setStringType('scope', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
DaoMap::setIntType('mageId');
DaoMap::setBoolType('isFromB2B');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('code');
DaoMap::createIndex('attributeSetMageId');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('mageId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ra');
DaoMap::setStringType('raNo', 'varchar', 12);
DaoMap::setStringType('status', 'varchar', 12);
DaoMap::setManyToOne('order', 'Order', 'ra_order', true);
DaoMap::setManyToOne('customer', 'Customer', 'ra_customer');
DaoMap::setIntType('totalValue', 'double', '10,4');
DaoMap::setStringType('description', 'varchar', '255');
DaoMap::setOneToMany('items', 'RMAItem', 'ra_item');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('raNo');
DaoMap::createIndex('status');
DaoMap::createIndex('totalValue');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'shippment');
DaoMap::setManyToOne('order', 'Order', 'sh_order');
DaoMap::setManyToOne('courier', 'Courier', 'sh_courier');
DaoMap::setIntType('noOfCartons');
DaoMap::setStringType('receiver', 'varchar', 100);
DaoMap::setManyToOne('address', 'Address', 'sh_addr');
DaoMap::setStringType('contact', 'varchar', 100);
DaoMap::setDateType('shippingDate');
DaoMap::setStringType('conNoteNo', 'varchar', 100);
DaoMap::setIntType('estShippingCost', 'Double', '10,4');
DaoMap::setIntType('actualShippingCost', 'Double', '10,4');
DaoMap::setStringType('deliveryInstructions', 'varchar', 255);
DaoMap::setStringType('mageShipmentId', 'varchar', 100);
parent::__loadDaoMap();
DaoMap::createIndex('receiver');
DaoMap::createIndex('conNoteNo');
DaoMap::createIndex('shippingDate');
DaoMap::createIndex('mageShipmentId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'comm');
DaoMap::setIntType('entityId');
DaoMap::setStringType('entityName', 'varchar', 100);
DaoMap::setStringType('comments', 'varchar', 255);
DaoMap::setStringType('groupId', 'varchar', 100);
DaoMap::setStringType('type', 'varchar', 50);
parent::__loadDaoMap();
DaoMap::createIndex('entityId');
DaoMap::createIndex('entityName');
DaoMap::createIndex('groupId');
DaoMap::createIndex('type');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'log');
DaoMap::setStringType('transId', 'varchar', 100);
DaoMap::setStringType('type', 'varchar', 100);
DaoMap::setIntType('entityId');
DaoMap::setStringType('entityName', 'varchar', 100);
DaoMap::setStringType('funcName', 'varchar', 100);
DaoMap::setStringType('msg', 'LONGTEXT');
DaoMap::setStringType('comments', 'varchar', 255);
parent::__loadDaoMap();
DaoMap::createIndex('transId');
DaoMap::createIndex('entityId');
DaoMap::createIndex('entityName');
DaoMap::createIndex('type');
DaoMap::createIndex('funcName');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'sell_item');
DaoMap::setManyToOne('orderItem', 'OrderItem', 'rec_item_oi');
DaoMap::setManyToOne('order', 'Order', 'sell_item_or');
DaoMap::setManyToOne('product', 'Product', 'rec_item_pro');
DaoMap::setManyToOne('kit', 'Kit', 'sell_item_kit', true);
DaoMap::setStringType('serialNo', 'varchar', '100');
DaoMap::setStringType('description', 'varchar', '255');
parent::__loadDaoMap();
DaoMap::createIndex('serialNo');
DaoMap::createIndex('description');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'con');
DaoMap::setStringType('assetId', 'varchar', 32);
DaoMap::setStringType('type', 'varchar', 20);
DaoMap::setStringType('filename', 'varchar', 100);
DaoMap::setStringType('mimeType', 'varchar', 50);
DaoMap::setStringType('path', 'varchar', 200);
parent::__loadDaoMap();
DaoMap::createUniqueIndex('assetId');
DaoMap::createIndex('type');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'addr');
DaoMap::setStringType('companyName', 'varchar', 100);
DaoMap::setStringType('contactName', 'varchar', 100);
DaoMap::setStringType('contactNo', 'varchar', 50);
DaoMap::setStringType('street', 'varchar', 200);
DaoMap::setStringType('city', 'varchar', 20);
DaoMap::setStringType('region', 'varchar', 20);
DaoMap::setStringType('country', 'varchar', 20);
DaoMap::setStringType('postCode', 'varchar', 10);
DaoMap::setStringType('sKey', 'varchar', 32);
parent::__loadDaoMap();
DaoMap::createIndex('sKey');
DaoMap::createIndex('companyName');
DaoMap::createIndex('contactName');
DaoMap::createIndex('contactNo');
DaoMap::createIndex('city');
DaoMap::createIndex('region');
DaoMap::createIndex('country');
DaoMap::createIndex('postCode');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'msg');
DaoMap::setStringType('transId', 'varchar', 32);
DaoMap::setStringType('type', 'varchar', 50);
DaoMap::setStringType('from', 'varchar', 200);
DaoMap::setStringType('to', 'varchar', 255);
DaoMap::setStringType('subject', 'varchar', 200);
DaoMap::setStringType('body', 'longtext');
DaoMap::setStringType('status', 'varchar', 10);
DaoMap::setStringType('attachAssetIds', 'longtext');
parent::__loadDaoMap();
DaoMap::createIndex('transId');
DaoMap::createIndex('type');
DaoMap::createIndex('from');
DaoMap::createIndex('to');
DaoMap::createIndex('status');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'po');
DaoMap::setStringType('purchaseOrderNo', 'varchar', 100);
DaoMap::setManyToOne('supplier', 'Supplier', 'po_sup');
DaoMap::setStringType('supplierRefNo', 'varchar', 100);
DaoMap::setStringType('status', 'varchar', 20);
DaoMap::setBoolType('isCredit', 'bool', false);
DaoMap::setManyToOne('fromPO', 'PurchaseOrder', 'po_fromPO', true);
DaoMap::setStringType('supplierContact', 'varchar', 100);
DaoMap::setStringType('supplierContactNumber', 'varchar', 100);
DaoMap::setStringType('shippingCost', 'Double', '10,4');
DaoMap::setStringType('handlingCost', 'Double', '10,4');
DaoMap::setDateType('orderDate');
DaoMap::setDateType('eta');
DaoMap::setIntType('totalAmount', 'Double', '10,4');
DaoMap::setIntType('totalPaid', 'Double', '10,4');
DaoMap::setOneToMany('items', 'PurchaseOrderItem', 'po_item');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('purchaseOrderNo');
DaoMap::createIndex('supplierRefNo');
DaoMap::createIndex('status');
DaoMap::createIndex('isCredit');
DaoMap::createIndex('orderDate');
DaoMap::createIndex('eta');
DaoMap::createIndex('totalAmount');
DaoMap::createIndex('totalPaid');
DaoMap::createIndex('supplierContact');
DaoMap::createIndex('supplierContactNumber');
DaoMap::createIndex('shippingCost');
DaoMap::createIndex('handlingCost');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro_img');
DaoMap::setManyToOne('product', 'Product', 'pro_img_pro');
DaoMap::setStringType('imageAssetId', 'varchar', 32);
parent::__loadDaoMap();
DaoMap::createIndex('imageAssetId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ra_item');
DaoMap::setManyToOne('RMA', 'RMA', 'ra_item_ra');
DaoMap::setManyToOne('orderItem', 'OrderItem', 'ra_item_ord_item', true);
DaoMap::setManyToOne('product', 'Product', 'ra_pro');
DaoMap::setIntType('qty');
DaoMap::setIntType('unitCost', 'double', '10,4');
DaoMap::setStringType('itemDescription', 'varchar', '255');
DaoMap::setDateType('receivedDate');
parent::__loadDaoMap();
DaoMap::createIndex('qty');
DaoMap::createIndex('unitCost');
DaoMap::createIndex('receivedDate');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'sup_code');
DaoMap::setManyToOne('supplier', 'Supplier', 'scode_sup');
DaoMap::setManyToOne('product', 'Product', 'scode_pro');
DaoMap::setStringType('code', 'varchar', 100);
DaoMap::setIntType('canSupplyQty', 'int', 10, true, null);
parent::__loadDaoMap();
DaoMap::createIndex('code');
DaoMap::createIndex('canSupplyQty');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'location');
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
parent::__loadDaoMap();
DaoMap::createUniqueIndex('name');
DaoMap::createIndex('description');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'po_item');
DaoMap::setManyToOne('purchaseOrder', 'PurchaseOrder', 'po_item_po');
DaoMap::setManyToOne('product', 'Product', 'po_item_pro');
DaoMap::setIntType('qty', 'int', 10, false);
DaoMap::setIntType('receivedQty', 'int', 10, false);
DaoMap::setIntType('unitPrice', 'double', '10,4');
DaoMap::setIntType('totalPrice', 'double', '10,4', false);
DaoMap::setBoolType('stockCalculated');
parent::__loadDaoMap();
DaoMap::createIndex('qty');
DaoMap::createIndex('receivedQty');
DaoMap::createIndex('stockCalculated');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'man');
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
DaoMap::setIntType('mageId');
DaoMap::setBoolType('isFromB2B');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('name');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('mageId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'cust');
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
DaoMap::setStringType('contactNo', 'varchar', 50);
DaoMap::setStringType('email', 'varchar', 100);
DaoMap::setManyToOne('billingAddress', 'Address', 'cust_bill_addr', true);
DaoMap::setManyToOne('shippingAddress', 'Address', 'cust_ship_addr', true);
DaoMap::setIntType('mageId');
DaoMap::setBoolType('isFromB2B');
parent::__loadDaoMap();
DaoMap::createIndex('name');
DaoMap::createIndex('contactNo');
DaoMap::createIndex('email');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('mageId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'kit');
DaoMap::setManyToOne('task', 'Task', 'kit_t', true);
DaoMap::setManyToOne('product', 'Product', 'kit_pro', true);
DaoMap::setStringType('barcode');
DaoMap::setManyToOne('soldToCustomer', 'Customer', 'kt_cust', true);
DaoMap::setDateType('soldDate');
DaoMap::setManyToOne('soldOnOrder', 'Order', 'kit_ord', true);
DaoMap::setManyToOne('shippment', 'Shippment', 'kit_ship', true);
DaoMap::setIntType('cost', 'Double', '10,4');
DaoMap::setIntType('price', 'Double', '10,4');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('barcode');
DaoMap::createIndex('soldDate');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro_cat');
DaoMap::setManyToOne('category', 'ProductCategory', 'pro_cat_cate');
DaoMap::setManyToOne('product', 'Product', 'pro_cat_pro');
parent::__loadDaoMap();
DaoMap::createIndex('category');
DaoMap::createIndex('product');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'courier');
DaoMap::setStringType('name');
DaoMap::setStringType('connector');
DaoMap::setStringType('code');
DaoMap::setOneToMany('shippments', 'Shippment', 'c_shippments');
parent::__loadDaoMap();
DaoMap::createIndex('name');
DaoMap::createIndex('code');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pql');
DaoMap::setManyToOne('product', 'Product', 'pql_pro', true);
DaoMap::setIntType('stockOnHand', 'int', 10, false);
DaoMap::setIntType('stockOnHandVar', 'int', 10, false);
DaoMap::setIntType('totalOnHandValue', 'double', '10,4');
DaoMap::setIntType('totalOnHandValueVar', 'double', '10,4');
DaoMap::setIntType('totalInPartsValue', 'double', '10,4');
DaoMap::setIntType('totalInPartsValueVar', 'double', '10,4');
DaoMap::setIntType('stockOnOrder', 'int', 10, false);
DaoMap::setIntType('stockOnOrderVar', 'int', 10, false);
DaoMap::setIntType('stockOnPO', 'int', 10, false);
DaoMap::setIntType('stockOnPOVar', 'int', 10, false);
DaoMap::setIntType('stockInParts', 'int', 10, false);
DaoMap::setIntType('stockInPartsVar', 'int', 10, false);
DaoMap::setIntType('stockInRMA', 'int', 10, false);
DaoMap::setIntType('stockInRMAVar', 'int', 10, false);
DaoMap::setIntType('totalRMAValue', 'double', '10,4', false);
DaoMap::setIntType('totalRMAValueVar', 'double', '10,4', false);
DaoMap::setStringType('comments', 'varchar', 255);
DaoMap::setStringType('entityName', 'varchar', 100);
DaoMap::setIntType('entityId', 'int', 10, true, 0);
DaoMap::setStringType('type', 'varchar', 2);
parent::__loadDaoMap();
DaoMap::createIndex('entityName');
DaoMap::createIndex('type');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro_price');
DaoMap::setManyToOne('product', 'Product', 'pro_price_pro');
DaoMap::setManyToOne('type', 'ProductPriceType', 'pro_price_type');
DaoMap::setIntType('price', 'double', '10,4');
DaoMap::setDateType('start', 'datetime', false, trim(UDate::zeroDate()));
DaoMap::setDateType('end', 'datetime', false, trim(UDate::maxDate()));
parent::__loadDaoMap();
DaoMap::createIndex('price');
DaoMap::createIndex('start');
DaoMap::createIndex('end');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see HydraEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'sell_item');
DaoMap::setIntType('code', 'int', '10');
DaoMap::setIntType('typeId', 'int', '10');
DaoMap::setStringType('description', 'varchar', '255');
parent::__loadDaoMap();
DaoMap::createIndex('code');
DaoMap::createIndex('typeId');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ua');
DaoMap::setStringType('username', 'varchar', 100);
DaoMap::setStringType('password', 'varchar', 40);
DaoMap::setManyToOne("person", "Person", "p");
DaoMap::setManyToMany("roles", "Role", DaoMap::LEFT_SIDE, "r", false);
parent::__loadDaoMap();
DaoMap::createUniqueIndex('username');
DaoMap::createIndex('password');
DaoMap::commit();
}
