/** * (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(); }