Ejemplo n.º 1
1
 /**
  * (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();
 }
Ejemplo n.º 2
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.º 3
0
 /**
  * (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();
 }
Ejemplo n.º 4
0
 /**
  * (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();
 }
Ejemplo n.º 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();
 }
Ejemplo n.º 6
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.º 7
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.º 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();
 }
Ejemplo n.º 9
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.º 10
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();
 }
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 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.º 13
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.º 14
0
 /**
  * (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();
 }
Ejemplo n.º 15
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.º 16
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();
 }
Ejemplo n.º 17
0
 /**
  * (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();
 }
Ejemplo n.º 18
0
 /**
  * (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();
 }
Ejemplo n.º 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();
 }
Ejemplo n.º 20
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.º 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, '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.º 23
0
 /**
  * (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();
 }
Ejemplo n.º 24
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();
 }
Ejemplo n.º 25
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.º 26
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.º 27
0
 /**
  * (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();
 }
Ejemplo n.º 28
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.º 29
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.º 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();
 }