Ejemplo n.º 1
1
 /**
  * (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();
 }
Ejemplo n.º 2
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();
 }
Ejemplo n.º 3
0
 /**
  * (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();
 }
Ejemplo n.º 4
0
 /**
  * (non-PHPdoc)
  * @see HydraEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 'cn');
     DaoMap::setStringType('creditNoteNo', 'varchar', 12);
     DaoMap::setManyToOne('customer', 'Customer', 'cn_cus');
     DaoMap::setManyToOne('order', 'Order', 'cn_ord', true);
     DaoMap::setStringType('applyTo', 'varchar', 10);
     DaoMap::setDateType('applyDate');
     DaoMap::setIntType('totalValue', 'double', '10,4');
     DaoMap::setIntType('totalPaid', 'double', '10,4');
     DaoMap::setIntType('shippingValue', 'double', '10,4');
     DaoMap::setStringType('description', 'varchar', 255);
     DaoMap::setOneToMany('items', 'CreditNoteItem', 'cn_item');
     parent::__loadDaoMap();
     DaoMap::createUniqueIndex('creditNoteNo');
     DaoMap::createIndex('applyTo');
     DaoMap::createIndex('applyDate');
     DaoMap::commit();
 }
Ejemplo n.º 5
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();
 }
Ejemplo n.º 6
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();
 }
Ejemplo n.º 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();
 }
Ejemplo n.º 8
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();
 }
Ejemplo n.º 9
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();
 }
Ejemplo n.º 10
0
 /**
  * (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();
 }
Ejemplo n.º 11
0
 /**
  * (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();
 }
Ejemplo n.º 12
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();
 }
Ejemplo n.º 13
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();
 }
Ejemplo n.º 14
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();
 }
Ejemplo n.º 15
0
 /**
  * (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();
 }
Ejemplo n.º 16
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();
 }
Ejemplo n.º 17
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();
 }
Ejemplo n.º 18
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();
 }
Ejemplo n.º 19
0
 /**
  * (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();
 }
Ejemplo n.º 20
0
 /**
  * (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();
 }
Ejemplo n.º 21
0
 /**
  * (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();
 }
Ejemplo n.º 22
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();
 }
Ejemplo n.º 23
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();
 }
Ejemplo n.º 24
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();
 }
Ejemplo n.º 25
0
 /**
  * (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();
 }
Ejemplo n.º 26
0
 /**
  * (non-PHPdoc)
  * @see BaseEntity::__loadDaoMap()
  */
 public function __loadDaoMap()
 {
     DaoMap::begin($this, 't');
     DaoMap::setStringType('fromEntityName', 'varchar', 50);
     DaoMap::setIntType('fromEntityId');
     DaoMap::setManyToOne('status', 'TaskStatus', 't_st');
     DaoMap::setManyToOne('customer', 'Customer', 't_cust');
     DaoMap::setManyToOne('technician', 'UserAccount', 't_tech', true);
     DaoMap::setDateType('dueDate');
     DaoMap::setStringType('instructions', 'text');
     parent::__loadDaoMap();
     DaoMap::createIndex('fromEntityName');
     DaoMap::createIndex('fromEntityId');
     DaoMap::createIndex('dueDate');
     DaoMap::commit();
 }