/**
  * (non-PHPdoc)
  * @see BaseEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 'preloc');
     DaoMap::setManyToOne('location', 'Location', 'preloc_loc');
     DaoMap::setManyToOne('product', 'Product', 'preloc_pro');
     DaoMap::setManyToOne('type', 'PreferredLocationType', 'preloc_loc_type');
     parent::__loadDaoMap();
     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();
 }
Exemple #3
0
 /**
  * (non-PHPdoc)
  * @see BaseEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 'courierinfo');
     DaoMap::setManyToOne('courier', 'Courier');
     parent::__loadDaoMap();
     DaoMap::commit();
 }
Exemple #4
0
 /**
  * (non-PHPdoc)
  * @see BaseEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 'shippmentitem');
     DaoMap::setManyToOne('shippment', 'Shippment', 'shitem_Shippment');
     parent::__loadDaoMap();
     DaoMap::commit();
 }
Exemple #5
0
 /**
  * (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();
 }
Exemple #6
0
 /**
  * (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();
 }
Exemple #7
0
 /**
  * (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();
 }
Exemple #8
0
 /**
  * (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 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, '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();
 }
Exemple #11
0
 /**
  * (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();
 }
Exemple #12
0
 /**
  * (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();
 }
Exemple #13
0
 /**
  * (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, 'sup_fd_rule');
     DaoMap::setManyToOne('supplier', 'Supplier', 'sup_fd_rule_sup');
     DaoMap::setManyToOne('manufacturer', 'Manufacturer', 'sup_fd_rule_man', true);
     DaoMap::setManyToOne('category', 'ProductCategory', 'sup_fd_rule_pro_cate', true);
     DaoMap::setManyToOne('priceMatchRule', 'ProductPriceMatchRule', 'sup_fd_rule_pro_price_rule', true);
     DaoMap::createIndex('supplier');
     parent::__loadDaoMap();
     DaoMap::commit();
 }
Exemple #15
0
 /**
  * (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();
 }
Exemple #16
0
 /**
  * (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();
 }
Exemple #17
0
 /**
  * (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();
 }
Exemple #18
0
 /**
  * (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();
 }
Exemple #19
0
 /**
  * (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();
 }
Exemple #20
0
 /**
  * (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_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();
 }
Exemple #22
0
 /**
  * (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, '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();
 }
Exemple #24
0
 /**
  * (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();
 }
 /**
  * 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');
 }
Exemple #26
0
 /**
  * (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();
 }
Exemple #27
0
 /**
  * (non-PHPdoc)
  * @see BaseEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 'kcom');
     DaoMap::setManyToOne('kit', 'Kit', 'kcom_kit');
     DaoMap::setManyToOne('component', 'Product', 'kcom_com');
     DaoMap::setIntType('qty');
     DaoMap::setIntType('unitCost', 'double', '10,4');
     DaoMap::setIntType('unitPrice', 'double', '10,4');
     parent::__loadDaoMap();
     DaoMap::commit();
 }
Exemple #28
0
 /**
  * (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();
 }
Exemple #29
0
 /**
  * (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();
 }
Exemple #30
-1
 /**
  * (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();
 }