/**
*
*/
public static function getStringListOfUserForOrderList()
{
$safeinstance = new SafinstancesUsers();
$safeinstanceSelector = $safeinstance->select()->from($safeinstance->getTableName(), 'users_id as id')->where('safinstances_id = ' . Sydney_Tools::getSafinstancesId());
$safeinstanceResult = $safeinstance->fetchAll($safeinstanceSelector)->toArray();
$listUsers = Sydney_Tools::implode(', ', $safeinstanceResult);
$users = new Users();
$usersSelector = $users->select()->from($users->getTableName(), 'id')->where('id NOT IN (' . $listUsers . ')')->where('safinstances_id = ' . Sydney_Tools::getSafinstancesId());
$usersResult = $users->fetchAll($usersSelector)->toArray();
if (count($usersResult) > 0) {
if (!empty($listUsers)) {
$listUsers .= ', ';
}
$listUsers .= Sydney_Tools::implode(', ', $usersResult);
}
return $listUsers;
}
/**
*
* delete all contents of page $pageid
* @param $pageId id of the pagstructure
* @param $rollback determine if the content are deleted or restored
*/
public function deleteContentFromPage($pageId, $rollback = false)
{
// search all content from page
$PageDiv = new PagstructurePagdivs();
$selector = $PageDiv->select()->from(Sydney_Tools::getTableName($PageDiv), 'pagdivs_id')->where('pagstructure_id = ' . $pageId);
$rowset = $PageDiv->fetchAll($selector)->toArray();
$listContentId = Sydney_Tools::implode(',', $rowset);
// delete content
if (!empty($listContentId)) {
if ($this->isLogicalDelete()) {
return $this->update(array('isDeleted' => !$rollback), 'id IN (' . $listContentId . ')');
} else {
return $this->delete('id IN (' . $listContentId . ')');
}
}
return false;
}