/** * (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 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(); }
/** * removing all the information object * * @param InfoEntityAbstract $entity * @param InfoTypeAbstract $type * * @return Ambigous <multitype:, multitype:BaseEntityAbstract > */ public static function remove(InfoEntityAbstract $entity, InfoTypeAbstract $type = null) { $where = StringUtilsAbstract::lcFirst(str_replace('Info', '', get_called_class())) . 'Id = ?'; $params = array($entity->getId()); if ($type instanceof InfoTypeAbstract) { $where .= ' AND typeId = ?'; $params[] = $type->getId(); } self::updateByCriteria('active = 0', $where, $params); }
/** * (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, '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(); }
/** * (non-PHPdoc) * @see BaseEntity::__loadDaoMap() */ public function __loadDaoMap() { DaoMap::begin($this, 'pal'); DaoMap::setManyToOne('product', 'Product', 'pal_pro'); DaoMap::setDateType('lastPurchaseTime'); DaoMap::setManyToOne('receivingItem', 'ReceivingItem', 'pal_rec_item', true); DaoMap::setManyToOne('purchaseOrderItem', 'PurchaseOrderItem', 'pal_po_item', true); DaoMap::setManyToOne('orderItem', 'OrderItem', 'pal_ord_item', true); DaoMap::setManyToOne('creditNoteItem', 'CreditNoteItem', 'pal_cn_item', true); DaoMap::setManyToOne('productQtyLog', 'ProductQtyLog', 'pal_pql'); DaoMap::setStringType('comments', 'varchar', 255); parent::__loadDaoMap(); DaoMap::commit(); }