public function getUserById($id)
{
$db = parent::_dbSelect();
$select = $db->from('KutuUser', '*', 'hid')->where("kopel='" . $id . "'");
$result = parent::_getDefaultAdapter()->fetchRow($select);
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 getCatalogByGuid($guid)
{
$db = parent::_dbSelect();
$statement = $db->from('KutuCatalogFolder')->where('catalogGuid=?', $guid);
$row = parent::_getDefaultAdapter()->fetchRow($statement);
return $row;
}
/**
* @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;
}
public function getUserGroup($packageId)
{
$db = parent::_dbSelect();
$select = $db->from('gacl_aro_groups', '*', 'hid')->where("id = {$packageId}");
$result = parent::_getDefaultAdapter()->fetchRow($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;
}
/**
* @return obj
*/
public function getHistory($id)
{
$db = parent::_dbSelect();
$select = $db->from('KutuOrderHistory')->where("orderId = '{$id}'");
$result = parent::_getDefaultAdapter()->fetchAll($select);
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 getSpecifiedStatus($where)
{
$db = parent::_dbSelect();
$select = $db->from('KutuOrderStatus')->where('orderStatusId = ' . $where);
$result = parent::_getDefaultAdapter()->fetchAll($select);
return $result;
}
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;
}
/**
* @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 getOrderDetail($idOrder)
{
$db = parent::_dbSelect();
$select = $db->from('KutuOrderDetail')->where("orderId = " . $idOrder);
$result = parent::_getDefaultAdapter()->fetchAll($select);
return $result;
}
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;
}
/**
* @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;
}
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 getInvoiceById($id)
{
$db = parent::_dbSelect();
$select = $db->from('KutuUserInvoice')->where("uid='" . $id . "'");
$conn = self::$_db;
$result = $conn->fetchAll($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'] : '';
}
/**
* @return obj
*/
public function getNumber()
{
$db = parent::_dbSelect();
$statement = $db->from('KutuNumber');
$conn = self::$_db;
$result = $conn->fetchRow($statement);
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 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;
}
/**
* @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 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;
}
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;
}
public function fetchNewsCatalog($profileGuid, $start = null, $end = null)
{
$data = $this->implode_with_keys(", ", $profileGuid, "'");
$db = parent::_dbSelect();
$select = $db->from('KutuCatalog')->join('KutuCatalogFolder', 'KutuCatalog.guid=KutuCatalogFolder.catalogGuid', array('folderGuid'))->where('KutuCatalog.status=?', 99);
$select->where("KutuCatalog.profileGuid IN ({$data})")->order('KutuCatalog.publishedDate DESC');
if (is_int($start) && is_int($end)) {
$select->limit($end, $start);
}
/*$sql = $select->__toString();
print_r($sql);die;*/
$conn = self::$_db;
$rows = $conn->fetchAll($select);
return $rows;
}
public function getUserByMonth($packageId, $mon)
{
$db = parent::_dbSelect();
$statement = $db->from('KutuUser', array('COUNT(*) as count'))->where("packageId={$packageId}")->where("createdDate LIKE '%" . $mon . "%'");
/*$sql = $statement->__toString();
print_r($sql);exit();*/
$conn = self::$_db;
$row = $conn->fetchRow($statement);
return $row !== null ? $row['count'] : 0;
}
public function getCountCalendar()
{
$db = parent::_dbSelect();
$statement = $db->from('calendar_mssgs', array('COUNT(*) as count'))->joinLeft('KutuUser', 'calendar_mssgs.uid=KutuUser.guid', array());
$row = parent::_getDefaultAdapter()->fetchRow($statement);
return $row !== null ? $row['count'] : 0;
}
public function getIdByTitle($st)
{
$db = parent::_dbSelect();
$row = parent::_getDefaultAdapter()->fetchRow($db->from('KutuFolder')->where("cmsParams like '%" . '"menu":true,"st":"' . $st . '"' . "%'"));
return $row;
}
public function getCatalogByProfile($profileGuid)
{
$db = parent::_dbSelect();
$row = parent::_getDefaultAdapter()->fetchAll($db->from('KutuCatalog')->where('profileGuid=?', $profileGuid)->order('createdDate ASC'));
return $row;
}
