public static function getShopByUser($userId, $roleId = 0, $shopId = 0)
{
$model = new Default_Model_Shops();
if ($roleId == 14) {
$names = array();
$select = $model->getMapper()->getDbTable()->select()->from(array('s' => 'shops'), array('s.*'))->joinLeft(array('su' => 'district_manager_shops'), 's.id = su.idShop', array('suid' => 'su.id'))->where('NOT s.deleted')->where('su.idUser = ?', $userId)->setIntegrityCheck(false);
$result = $model->fetchAll($select);
if ($result) {
foreach ($result as $value) {
$names[] = $value->getName();
}
}
return implode(', ', $names);
} else {
$model->find($shopId);
}
return $model->getName();
}
public function deleteAction()
{
$userId = NULL;
$auth = Zend_Auth::getInstance();
$authAccount = $auth->getStorage()->read();
if (null != $authAccount) {
if (null != $authAccount->getId()) {
$userId = $authAccount->getId();
}
}
$id = $this->getRequest()->getParam('id');
$model = new Default_Model_Shops();
if ($model->find($id)) {
if ($model->delete()) {
$this->_flashMessenger->addMessage("<div class='success canhide'><p>The shop was successfully deleted!<a href='javascript:;'>Close</a></p></div>");
} else {
$this->_flashMessenger->addMessage("<div class='failure canhide'><p>The shop was not deleted!<a href='javascript:;'>Close</a></p></div>");
}
$this->_redirect('shops/index');
}
}
