public function getHits($catalogGuid, $text) { $db = parent::_dbSelect(); $conn = self::$_db; $row = $conn->fetchRow($db->from('KutuAssetSetting')->where('guid=?', $catalogGuid)->where('valueText=?', $text)); return $row; }
public function getNumOfComment() { $db = parent::_dbSelect(); $select = $db->from('comments', array('COUNT(id) as count_id')); $row = parent::_getDefaultAdapter()->fetchRow($select); return $row !== null ? $row['count_id'] : 0; }
public function getOrderDetail($orderId) { $db = parent::_getDefaultAdapter(); $query = $db->query("SELECT KO.*, KOD.*\n FROM KutuOrder AS KO\n JOIN KutuOrderDetail AS KOD\n ON KOD.orderId = KO.orderId\n WHERE KO.orderId = {$orderId}"); $result = $query->fetchAll(Zend_Db::FETCH_ASSOC); return $result; }
public function getSpecifiedStatus($where) { $db = parent::_dbSelect(); $select = $db->from('KutuOrderStatus')->where('orderStatusId = ' . $where); $result = parent::_getDefaultAdapter()->fetchAll($select); return $result; }
public function unconfirmList($where, $limit, $offset) { $db = parent::_getDefaultAdapter(); $query = $db->query("SELECT\n KPC.*,KO.*, KU.*, KOS.ordersStatus\n FROM\n KutuPaymentConfirmation AS KPC,\n KutuOrder AS KO,\n KutuUser AS KU,\n KutuOrderStatus AS KOS\n WHERE\n KO.orderId = KPC.orderId\n AND\n KU.guid = KO.userId\n AND\n confirmed = 0\n AND\n KO.orderStatus = KOS.orderStatusId\n {$where}\n LIMIT {$offset}, {$limit}"); $result = $query->fetchAll(Zend_Db::FETCH_ASSOC); return $result; }
/** * @return obj */ function getPollOption($guid) { $db = parent::_dbSelect(); $select = $db->from('options')->where("pollGuid='{$guid}'", "text ASC"); $result = parent::_getDefaultAdapter()->fetchAll($select); return $result; }
public function unconfirmList($where = '', $limit, $offset) { $db = parent::_getDefaultAdapter(); $query = $db->query("SELECT\n \t\t\t\t\t\tKU.username, KU.fullName, KO.invoiceNumber, KO.orderTotal, KO.paymentMethod,\n \t\t\t\t\t\tKPC.senderAccount, KPC.senderAccountName, KPC.bankName, KPC.note, KPC.destinationAccount,\n \t\t\t\t\t\tKPC.amount, KPC.paymentDate, KPC.orderId\n FROM\n " . self::$_schema . ".KutuPaymentConfirmation AS KPC,\n " . self::$_schema . ".KutuOrder AS KO,\n hid.KutuUser AS KU,\n " . self::$_schema . ".KutuOrderStatus AS KOS\n WHERE\n KO.orderId = KPC.orderId\n AND\n KU.kopel = KO.userId\n AND\n KPC.confirmed = 0\n AND\n KO.orderStatus = KOS.orderStatusId\n {$where}\n LIMIT {$offset}, {$limit}"); $result = $query->fetchAll(Zend_Db::FETCH_ASSOC); return $result; }
/** * @return obj */ function getPollByDate($date) { $db = parent::_dbSelect(); $select = $db->from('polls')->where("checkedTime < '{$date}'", "checkedTime DESC"); $result = parent::_getDefaultAdapter()->fetchRow($select); return $result; }
/** * @return obj */ public function getDocumentById($catalogGuid, $relateAs) { $db = parent::_dbSelect(); $statement = $db->from('KutuRelatedItem')->where('relatedGuid=?', $catalogGuid)->where('relateAs=?', $relateAs); $row = parent::_getDefaultAdapter()->fetchRow($statement); return $row; }
/** * @return obj */ public function getOrderDetail($idOrder) { $db = parent::_dbSelect(); $select = $db->from('KutuOrderDetail')->where("orderId = " . $idOrder); $result = parent::_getDefaultAdapter()->fetchAll($select); return $result; }
public function addCounterAsset($catalogGuid, array $data) { if (!isset($catalogGuid)) { return 0; } $whiteList = array('guid', 'application', 'part', 'valueType', 'valueInt', 'valueText'); $addData = array(); foreach ($data as $key => $value) { if (in_array($key, $whiteList)) { $addData[$key] = $value; } } if (empty($addData)) { return 0; } $db = parent::_dbSelect(); $where = $db->from('KutuAssetSetting')->where('guid=?', $catalogGuid); $row = parent::_getDefaultAdapter()->fetchRow($where); if ($row) { // check ip /* if (($row->guid == $catalogGuid) && ($row->valueType == Pandamp_Lib_Formater::getRealIpAddr())) { return 0; } */ $row['valueInt'] = $row['valueInt'] += 1; $id = parent::_getDefaultAdapter()->update('KutuAssetSetting', array('valueInt' => $row['valueInt']), "guid='" . $catalogGuid . "'"); } else { $id = parent::_getDefaultAdapter()->insert('KutuAssetSetting', $addData); } if ((int) $id == 0) { return 0; } return $id; }
public function getUserFinance($where) { $db = parent::_getDefaultAdapter(); $query = $db->query("SELECT KUF.*, KU.fullName AS FN, KU.username AS UN, KU.createdDate, KU.createdBy, KU.updatedDate, KU.updatedBy FROM KutuUserFinance AS KUF, KutuUser AS KU WHERE userId = '{$where}' AND KU.guid = KUF.userId "); $result = $query->fetchAll(Zend_Db::FETCH_ASSOC); return $result; }
/** * @return obj */ public function getRating($id, $ip) { $db = parent::_dbSelect(); $select = $db->from('vote')->where('guid=?', $id)->where('ip=?', $ip); $row = parent::_getDefaultAdapter()->fetchRow($select); return $row; }
/** * @return obj */ public function getHistory($id) { $db = parent::_dbSelect(); $select = $db->from('KutuOrderHistory')->where("orderId = '{$id}'"); $result = parent::_getDefaultAdapter()->fetchAll($select); return $result; }
public function getUserById($id) { $db = parent::_dbSelect(); $select = $db->from('KutuUser', '*', 'hid')->where("kopel='" . $id . "'"); $result = parent::_getDefaultAdapter()->fetchRow($select); return $result; }
/** * @return obj */ public function getCatalogByGuid($guid) { $db = parent::_dbSelect(); $statement = $db->from('KutuCatalogFolder')->where('catalogGuid=?', $guid); $row = parent::_getDefaultAdapter()->fetchRow($statement); return $row; }
public function getUserGroup($packageId) { $db = parent::_dbSelect(); $select = $db->from('gacl_aro_groups', '*', 'hid')->where("id = {$packageId}"); $result = parent::_getDefaultAdapter()->fetchRow($select); return $result; }
/** * @return obj */ public function getUserGroupId($username) { $db = parent::_dbSelect(); $select = $db->from('gacl_aro')->where('section_value=?', 'user')->where('value=?', $username); $config = Zend_Registry::get('db2'); $row = $config->fetchRow($select); return $row; }
/** * @return obj */ public function getNumber() { $db = parent::_dbSelect(); $statement = $db->from('KutuNumber'); $conn = self::$_db; $result = $conn->fetchRow($statement); return $result; }
public function getUserGroup($packageId) { $db = parent::_dbSelect(); $select = $db->from('gacl_aro_groups')->where("id = {$packageId}"); $conn = self::$_db; $result = $conn->fetchRow($select); return $result; }
public function getUserStatus($statusId) { $db = parent::_dbSelect(); $select = $db->from('KutuUserStatus', array("accountStatusId", "status"))->where("accountStatusId=?", $statusId); $conn = self::$_db; $result = $conn->fetchRow($select); return $result; }
public function getCatalogAttributeValue($catalogGuid, $attributeGuid) { $db = parent::_dbSelect(); $select = $db->from('KutuCatalogAttribute', array('value'))->where('catalogGuid=?', $catalogGuid)->where('attributeGuid=?', $attributeGuid); $conn = self::$_db; $row = $conn->fetchRow($select); return $row !== null ? $row['value'] : ''; }
public function getInvoiceById($id) { $db = parent::_dbSelect(); $select = $db->from('KutuUserInvoice')->where("uid='" . $id . "'"); $conn = self::$_db; $result = $conn->fetchAll($select); return $result; }
public function getCommentParentCount($parentId) { if (!isset($parentId)) { return 0; } $db = parent::_dbSelect(); $select = $db->from('comments', array('COUNT(id) as count_id'))->where('parent=?', $parentId)->where('published=?', 99); $row = parent::_getDefaultAdapter()->fetchRow($select); return $row !== null ? $row['count_id'] : 0; }
public function getCatalogGuidByFolderGuid($node) { $db = parent::_dbSelect(); $select = $db->from('KutuCatalogFolder', array('guid' => 'catalogGuid'))->where("folderGuid=?", "{$node}")->order("catalogGuid desc"); //$sql = $select->__toString(); //print_r($sql);exit(); $conn = self::$_db; //$rows = $conn->query("SELECT catalogGuid as guid from KutuCatalogFolder where folderGuid='$node'"); //$result = $rows->fetchAll(Zend_Db::FETCH_OBJ); $result = $conn->fetchAll($select); return $result; }
/** * @return obj */ public function fetchChildren($parentGuid) { $db = parent::_dbSelect(); if ($parentGuid == 'root') { $select = $db->from('KutuFolder')->where('parentGuid=guid')->order('title ASC'); } else { $select = $db->from('KutuFolder')->where("parentGuid = '{$parentGuid}' AND NOT parentGuid=guid")->order('title ASC'); } $conn = self::$_db; $rows = $conn->fetchAll($select); return $rows; }
public function getUserByPackageId($pid) { $db = parent::_dbSelect(); $select = $db->from("KutuUser")->where("packageId=?", $pid)->where("isActive=?", 1)->where("email <> ''"); /* $select = $select->__toString(); print_r($select);exit(); * */ $configDb = Zend_Registry::get('db1'); $row = $configDb->fetchAll($select); return $row; }
/** * @return obj */ public function get_object_groups($object_id) { $db = parent::_dbSelect(); $select = $db->from("gacl_groups_aro_map", "group_id")->where('aro_id=' . $object_id); /* $select = $select->__toString(); print_r($select);exit(); * */ $configDb = Zend_Registry::get('db2'); $row = $configDb->fetchAll($select); return $row; }
public function get_group_id($value) { $db = parent::_dbSelect(); $select = $db->from("gacl_aro_groups", array("id"))->where("value='" . $value . "'"); /* $select = $select->__toString(); print_r($select);exit(); * */ $configDb = Zend_Registry::get('db2'); $row = $configDb->fetchRow($select); return $row; }
/** * @return obj */ public function EventDateCalendar($month, $year) { $db = parent::_getDefaultAdapter(); $sql = "SELECT id,d,title,text,start_time,end_time, "; if (TIME_DISPLAY_FORMAT == "12hr") { $sql .= "TIME_FORMAT(start_time, '%l:%i%p') AS stime, "; $sql .= "TIME_FORMAT(end_time, '%l:%i%p') AS etime "; } elseif (TIME_DISPLAY_FORMAT == "24hr") { $sql .= "TIME_FORMAT(start_time, '%H:%i') AS stime, "; $sql .= "TIME_FORMAT(end_time, '%H:%i') AS etime "; } else { echo "Bad time display format, check your configuration file."; } $sql .= "FROM calendar_mssgs WHERE m = {$month} AND y = {$year} "; $sql .= "ORDER BY start_time"; $conn = self::$_db; $statement = $conn->query($sql); $result = $statement->fetchAll(Zend_Db::FETCH_OBJ); return $result; }