/** * (non-PHPdoc) * @see BaseEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'syssettings'); DaoMap::setStringType('type', 'varchar', 50); DaoMap::setStringType('value', 'varchar', 255); DaoMap::setStringType('description', 'varchar', 100); parent::__loadDaoMap(); DaoMap::createUniqueIndex('type'); DaoMap::commit(); }
/** * (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, 'tstat'); DaoMap::setStringType('name', 'varchar', 20); DaoMap::setStringType('description', 'text'); parent::__loadDaoMap(); DaoMap::createUniqueIndex('name'); DaoMap::commit(); }
/** * (non-PHPdoc) * @see BaseEntity::loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'sess'); DaoMap::setStringType('key', 'varchar', 32); DaoMap::setStringType('data', 'longtext'); parent::__loadDaoMap(); DaoMap::createUniqueIndex('key'); 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, '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_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, '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, '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, 'pro_img'); DaoMap::setManyToOne('product', 'Product', 'pro_img_pro'); DaoMap::setStringType('imageAssetId', 'varchar', 32); parent::__loadDaoMap(); DaoMap::createIndex('imageAssetId'); 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, 'cn_item'); DaoMap::setManyToOne('creditNote', 'CreditNote', 'cn_item_cn'); DaoMap::setManyToOne('orderItem', 'OrderItem', 'cn_it', true); DaoMap::setManyToOne('product', 'Product', 'cn_pro'); DaoMap::setIntType('qty'); DaoMap::setIntType('unitPrice', 'double', '10,4'); DaoMap::setIntType('unitCost', 'double', '10,4'); DaoMap::setIntType('totalPrice', 'double', '10,4'); DaoMap::setStringType('itemDescription', 'varchar', '255'); parent::__loadDaoMap(); 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 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(); }
/** * (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 HydraEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::setStringType('value', 'varchar', 255); DaoMap::setManyToOne(StringUtilsAbstract::lcFirst($this->_entityClass), $this->_entityClass, strtolower(get_class($this)) . '_entity'); DaoMap::setManyToOne('type', get_class($this) . 'Type', strtolower(get_class($this)) . '_info_type'); parent::__loadDaoMap(); }
/** * (non-PHPdoc) * @see BaseEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'pro_price_rule'); DaoMap::setManyToOne('product', 'Product', 'pro_rule_pro'); DaoMap::setStringType('price_from', 'varchar', '16', true, null); DaoMap::setStringType('price_to', 'varchar', '16', true, null); DaoMap::setStringType('offset', 'varchar', '16', true, null); DaoMap::setManyToOne('company', 'PriceMatchCompany', 'pro_rule_company'); parent::__loadDaoMap(); DaoMap::commit(); }
/** * (non-PHPdoc) * @see BaseEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'r'); DaoMap::setStringType('name', 'varchar'); DaoMap::setManyToMany("userAccounts", "UserAccount", DaoMap::RIGHT_SIDE, "ua"); parent::__loadDaoMap(); DaoMap::createUniqueIndex('name'); 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 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, '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, '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 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, '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 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 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, '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 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 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, '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(); }