/**
* (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, '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 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, '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 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, 'pro_price_type');
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('description', 'varchar', 255);
DaoMap::setBoolType('needTime');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('name');
DaoMap::createIndex('needTime');
DaoMap::commit();
}
/**
* load the default elments of the base entity
*/
protected function __loadDaoMap()
{
DaoMap::setBoolType('active', 'bool', 1);
DaoMap::setDateType('created');
DaoMap::setManyToOne('createdBy', 'UserAccount');
DaoMap::setDateType('updated', 'timestamp', false, 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP');
DaoMap::setManyToOne('updatedBy', 'UserAccount');
}
/**
* (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 BaseEntityAbstract::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ord_item');
DaoMap::setManyToOne('order', 'Order', 'ord');
DaoMap::setManyToOne('product', 'Product', 'pro');
DaoMap::setIntType('qtyOrdered');
DaoMap::setIntType('unitPrice', 'double', '10,4');
DaoMap::setIntType('totalPrice', 'double', '10,4');
DaoMap::setDateType('eta', 'datetime', true, null);
DaoMap::setBoolType('isPicked');
DaoMap::setBoolType('isShipped');
DaoMap::setBoolType('isOrdered');
DaoMap::setIntType('mageOrderId');
DaoMap::setIntType('margin', 'double', '10,4');
DaoMap::setIntType('unitCost', 'double', '10,4');
DaoMap::setStringType('itemDescription', 'varchar', '255');
parent::__loadDaoMap();
DaoMap::createIndex('isPicked');
DaoMap::createIndex('isShipped');
DaoMap::createIndex('isOrdered');
DaoMap::createIndex('qtyOrdered');
DaoMap::createIndex('unitPrice');
DaoMap::createIndex('totalPrice');
DaoMap::createIndex('margin');
DaoMap::createIndex('unitCost');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'pro');
DaoMap::setStringType('sku', 'varchar', 50);
DaoMap::setStringType('name', 'varchar', 100);
DaoMap::setStringType('mageId', 'varchar', 10);
DaoMap::setIntType('totalOnHandValue', 'double', '10,4', false);
DaoMap::setIntType('totalInPartsValue', 'double', '10,4', false);
DaoMap::setIntType('stockOnHand', 'int', 10, false);
DaoMap::setIntType('stockOnOrder', 'int', 10, false);
DaoMap::setIntType('stockOnPO', 'int', 10, false);
DaoMap::setIntType('stockInParts', 'int', 10, false);
DaoMap::setIntType('stockInRMA', 'int', 10, false);
DaoMap::setIntType('stockMinLevel', 'int', 10, true, true);
DaoMap::setIntType('stockReorderLevel', 'int', 10, true, true);
DaoMap::setIntType('totalRMAValue', 'double', '10,4', false);
DaoMap::setStringType('assetAccNo', 'varchar', 10);
DaoMap::setStringType('revenueAccNo', 'varchar', 10);
DaoMap::setStringType('costAccNo', 'varchar', 10);
DaoMap::setBoolType('isFromB2B');
DaoMap::setBoolType('sellOnWeb');
DaoMap::setManyToOne('status', 'ProductStatus', 'pro_status', true);
DaoMap::setManyToOne('manufacturer', 'Manufacturer', 'pro_man', true);
DaoMap::setDateType('asNewFromDate', 'datetime', true);
DaoMap::setDateType('asNewToDate', 'datetime', true);
DaoMap::setStringType('shortDescription', 'varchar', 255);
DaoMap::setStringType('fullDescAssetId', 'varchar', 100);
DaoMap::setOneToMany('supplierCodes', 'SupplierCode', 'pro_sup_code');
DaoMap::setOneToMany('categories', 'Product_Category', 'pro_cate');
DaoMap::setOneToMany('codes', 'ProductCode', 'pro_pro_code');
DaoMap::setBoolType('isKit');
DaoMap::setManyToOne('attributeSet', 'ProductAttributeSet', 'pro_attr_set', true);
DaoMap::setBoolType('manualDatafeed');
DaoMap::setIntType('weight', 'double', '10,4');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('sku');
DaoMap::createIndex('name');
DaoMap::createIndex('mageId');
DaoMap::createIndex('stockOnHand');
DaoMap::createIndex('stockOnOrder');
DaoMap::createIndex('stockOnPO');
DaoMap::createIndex('stockInParts');
DaoMap::createIndex('stockInRMA');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('shortDescription');
DaoMap::createIndex('fullDescAssetId');
DaoMap::createIndex('sellOnWeb');
DaoMap::createIndex('asNewFromDate');
DaoMap::createIndex('asNewToDate');
DaoMap::createIndex('assetAccNo');
DaoMap::createIndex('revenueAccNo');
DaoMap::createIndex('costAccNo');
DaoMap::createIndex('isKit');
DaoMap::createIndex('attributeSet');
DaoMap::createIndex('manualDatafeed');
DaoMap::createIndex('weight');
DaoMap::commit();
}
/**
* (non-PHPdoc)
* @see BaseEntity::__loadDaoMap()
*/
public function __loadDaoMap()
{
DaoMap::begin($this, 'ord');
DaoMap::setStringType('orderNo');
DaoMap::setStringType('type', 'varchar', 10);
DaoMap::setStringType('invNo');
DaoMap::setDateType('invDate');
DaoMap::setDateType('orderDate');
DaoMap::setManyToOne('customer', 'Customer', 'o_cust');
DaoMap::setIntType('totalAmount', 'Double', '10,4');
DaoMap::setIntType('totalPaid', 'Double', '10,4');
DaoMap::setIntType('totalCreditNoteValue', 'Double', '10,4');
DaoMap::setBoolType('passPaymentCheck');
DaoMap::setBoolType('isFromB2B');
DaoMap::setManyToOne('status', 'OrderStatus', 'o_status');
DaoMap::setManyToOne('billingAddr', 'Address', 'baddr', true);
DaoMap::setManyToOne('shippingAddr', 'Address', 'saddr', true);
DaoMap::setStringType('pONo', 'varchar', 50);
DaoMap::setIntType('margin', 'Double', '10,4');
DaoMap::setOneToMany('shippments', 'Shippment', 'o_ship');
DaoMap::setOneToMany('payments', 'Payment', 'py');
DaoMap::setOneToMany('orderItems', 'OrderItem', 'o_items');
parent::__loadDaoMap();
DaoMap::createUniqueIndex('orderNo');
DaoMap::createIndex('invNo');
DaoMap::createIndex('invDate');
DaoMap::createIndex('type');
DaoMap::createIndex('orderDate');
DaoMap::createIndex('passPaymentCheck');
DaoMap::createIndex('isFromB2B');
DaoMap::createIndex('pONo');
DaoMap::createIndex('margin');
DaoMap::createIndex('totalAmount');
DaoMap::createIndex('totalPaid');
DaoMap::commit();
}
