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;
}
