public function getNewRFollowID()
{
$sql = "select max(rfollowID) from rfollow";
// echo $sql;
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
return $result->current()['max(rfollowID)'] + 1;
}
public function getRandomUser($used = 1)
{
$usedCount = $this->getUnusedCount();
if (intval($usedCount) == 0) {
return false;
}
$userData = $this->getOrderByRand($this->table, array("is_used" => 0), 1);
if (!$userData) {
return false;
}
$uid = $userData[0]["id"];
$where = array("id" => $uid);
$connection = $this->dbAdapter->getDriver()->getConnection();
$connection->beginTransaction();
$sql = "select * from " . $this->table . " where id =? for update";
$result = $this->dbAdapter->query($sql, array($uid));
$userInfo = $result->toArray();
// $updateData = array("is_used" => $used, "used_time" => time());
$updateData = array("is_used" => $used);
if ($userInfo[0]["is_used"] == 0) {
$this->updateData($this->table, $where, $updateData);
$connection->commit();
if (!empty($userInfo)) {
return $userInfo[0];
}
} else {
$connection->commit();
return $this->getRandomUser($used);
}
}
public function industries(AdapterInterface $adapter)
{
$sql = "SELECT industries_id,industry_name from industries where status=1 ORDER by xorder ASC";
$statement = $adapter->query($sql);
$result = $statement->execute();
return $result;
}
public function getNewPageID()
{
$sql1 = 'select max(pageID) from page';
$statement = $this->dbAdapter->query($sql1);
$result = $statement->execute();
$row = $result->current();
// Debug::dump($row );
return $row['max(pageID)'] + 1;
}
/**
* Initializes database on first run then resets tables on subsequent runs.
*
* @see \Spork\Test\TestCase\TestCaseService::setUp()
* @throws \Exception on attempt to reset non temporary table
*/
protected function setUp()
{
parent::setUp();
$services = $this->getServiceLocator();
if (null === self::$dbAdapter) {
// initialize database connections
if (isset($GLOBALS['DB_MAIN_SERVICE_NAME'])) {
self::$dbAdapterName = $GLOBALS['DB_MAIN_SERVICE_NAME'];
}
$dbAdapterDefault = $services->get(self::$dbAdapterName);
self::$dbSchemaDefault = $dbAdapterDefault->getCurrentSchema();
if (isset($GLOBALS['DB_TEST_SERVICE_NAME'])) {
self::$dbAdapter = $services->get($GLOBALS['DB_TEST_SERVICE_NAME']);
self::$dbSchemaTest = self::$dbAdapter->getCurrentSchema();
} else {
self::$dbAdapter = $dbAdapterDefault;
}
// drop static tables
if (null !== self::$dbSchemaTest) {
self::$dbAdapter->query("DROP DATABASE {$this->quoteIdentifier(self::$dbSchemaTest)}", Adapter::QUERY_MODE_EXECUTE);
self::$dbAdapter->query("CREATE DATABASE {$this->quoteIdentifier(self::$dbSchemaTest)}", Adapter::QUERY_MODE_EXECUTE);
self::$dbAdapter->query("USE {$this->quoteIdentifier(self::$dbSchemaTest)}", Adapter::QUERY_MODE_EXECUTE);
}
// create test tables
foreach ($this->getTables($dbAdapterDefault) as $table) {
$this->createTestTable($table, $dbAdapterDefault, self::$dbAdapter);
}
// copy triggers
if (null !== self::$dbSchemaTest) {
$triggers = self::$dbAdapter->query("SHOW TRIGGERS FROM {$this->quoteIdentifier(self::$dbSchemaDefault)}", Adapter::QUERY_MODE_EXECUTE);
foreach ($triggers as $trigger) {
$createTrigger = self::$dbAdapter->query("SHOW CREATE TRIGGER {$this->quoteIdentifier(self::$dbSchemaDefault)}.{$this->quoteIdentifier($trigger['Trigger'])}", Adapter::QUERY_MODE_EXECUTE);
self::$dbAdapter->query($createTrigger->current()['SQL Original Statement'], Adapter::QUERY_MODE_EXECUTE);
}
}
} else {
foreach ($this->getTables(self::$dbAdapter) as $table) {
// make sure temporary tables are temporary
if (null === self::$dbSchemaTest) {
$createTable = $this->getCreateTable($table, self::$dbAdapter);
if (strpos($createTable, 'CREATE TEMPORARY TABLE') === false) {
throw new \Exception("Table '{$table}' is not temporary");
}
}
// empty tables
$result = self::$dbAdapter->query("truncate table `{$table}`", Adapter::QUERY_MODE_EXECUTE);
}
$allowOverride = $services->getAllowOverride();
$services->setAllowOverride(true)->setService(self::$dbAdapterName, self::$dbAdapter)->setAllowOverride($allowOverride);
}
$allowOverride = $services->getAllowOverride();
$services->setAllowOverride(true)->setService(self::$dbAdapterName, self::$dbAdapter)->setAllowOverride($allowOverride);
}
public function findRec()
{
if (WAuthUtil::get_auth() !== null) {
$userId = WAuthUtil::get_auth()->userID;
$sql = "select page.*,predictRating,user.* from (recs join page on recs.pageId = page.pageID)join user on recs.userId = user.userId where \n recs.userId = {$userId} and predictRating <> 0 order by predictRating desc";
$statement = $this->dbAdapter->query($sql);
$result = $statement->execute();
if ($result instanceof ResultInterface && $result->isQueryResult()) {
$resultSet = new WHydrateResultset($this->hydrator, $this->pagePrototype, $this->prototypeArr);
$tmp = $resultSet->initialize($result);
// foreach ($resultSet as $row){
// Debug::dump($row);
// }
return $tmp;
}
throw new \InvalidArgumentException("Forum with given ID:{$id} not found.");
} else {
return null;
}
}
public function childModuleAccessRights(AdapterInterface $adapter, $module_id, $function_name)
{
//Get user credentials
$session = new Container('base');
$user = $session->offsetGet('user');
$this->adapter = $adapter;
$statement = $adapter->query("SELECT `module_name`, function_name\n FROM\n `app_sub_accesses`\n LEFT JOIN\n `app_modules`\n ON\n `app_modules`.`app_modules_id` = `app_sub_accesses`.`module_id`\n LEFT JOIN\n `app_roles`\n ON\n `app_sub_accesses`.`role_id` = `app_roles`.`app_roles_id`\n WHERE\n `app_roles`.`app_roles_id`= " . $user['role_id'] . "\n AND `app_modules`.`app_modules_id` = {$module_id}\n AND `app_roles`.`status`=1\n AND function_name='" . $function_name . "'\n ");
$result = $statement->execute();
//Count number of records
if (count($result) > 0) {
return true;
} else {
return false;
}
}
public function updateReplynum($id)
{
$sql = "update page set preplynum=preplynum+1 where pageID={$id}";
$statement = $this->dbAdapter->query($sql);
$statement->execute();
}
