public function indexAction($offset = 0)
{
$this->language->load("clinic_reservations");
$branches = Form_helper::queryToDropdown('clinic_branches', 'clinic_branch_id', 'clinic_branch');
$specification = Form_helper::queryToDropdown('clinic_specifications', 'clinic_specification_id', 'specification');
$doctors = new \modules\clinic\models\Clinic_doctors();
$doctors->_select = "clinic_doctor_id,(SELECT users.fullname FROM users WHERE users.user_id = clinic_doctors.user_id)\n AS doctor_name";
$users = ['' => 'select..'];
foreach ($doctors->get() as $item) {
$users[$item->clinic_doctor_id] = $item->doctor_name;
}
$doctors->_select = "users.fullname,users.image,specification,clinic_branch,clinic_doctor_id";
$doctors->_joins = ['users' => ['clinic_doctors.`user_id` = users.`user_id`'], 'clinic_specification_branches' => ['clinic_doctors.`clinic_specification_id` = clinic_specification_branches.`clinic_specification_id`'], 'clinic_specifications' => ['clinic_specifications.`clinic_specification_id` = clinic_doctors.`clinic_specification_id`'], 'clinic_branches' => ['clinic_branches.`clinic_branch_id` =`clinic_specification_branches`.`clinic_branch_id`']];
$doctors->_group_by = [['clinic_doctors.`clinic_doctor_id`']];
$doctors->_order_by = false;
if ($this->input->get('clinic_branch_id')) {
$doctors->where('clinic_branches.`clinic_branch_id` ', $this->input->get('clinic_branch_id'));
}
if ($this->input->get('specification_id')) {
$doctors->where('clinic_specifications.`clinic_specification_id`', $this->input->get('specification_id'));
}
if ($this->input->get('clinic_doctor_id')) {
$doctors->where('clinic_doctors.`clinic_doctor_id`', $this->input->get('clinic_doctor_id'));
}
$this->load->library('pagination');
$doctors->_limit = $this->config->get('limit');
$doctors->_offset = $offset;
$config = ['url' => Uri_helper::url('clinic_reservation/index'), 'doctors' => $doctors->get(true), 'limit' => $doctors->_limit, 'offset' => $doctors->_offset];
return $this->render('clinic_reservations/clinic_reservations', ['branches' => $branches, 'specification' => $specification, 'doctors' => $doctors->get(), 'users' => $users, 'pagination' => $this->Pagination->generate($config)]);
}
protected function permission($action = null)
{
if (!$this->permissions->checkUserCredentials()) {
return Uri_helper::redirect('management');
}
//get_class($this)
}
public function __construct()
{
parent::__construct();
$this->language->load("commerce_orders");
$this->user = $this->permissions->getUserInformation();
if (!$this->user) {
Uri_helper::redirect('users/register');
}
}
public function __construct()
{
parent::__construct();
// CHECK THE SUITABLE HOME PAGE
if ($setting = $this->module->getSettings($this->_module)) {
if (isset($setting->default_home_page) && $setting->default_home_page != 'home') {
Uri_helper::redirect($setting->default_home_page);
}
}
}
public function getCustomMenu($param)
{
$links = [];
$menu = Brightery::SuperInstance()->Database->where('link_type_id', $param)->get('links')->result();
foreach ($menu as $item) {
$links[] = ['name' => $item->name, 'url' => strpos($item->url, 'http') !== false ? $item->url : Uri_helper::url($item->url)];
}
return $links;
// return 'b3sh2k ya gazma';
}
public function indexAction($offset = 0)
{
$this->permission('index');
$this->load->library('pagination');
$commerce_invoices = new \modules\commerce\models\Commerce_invoices();
$commerce_invoices->_select = "`commerce_invoices`.*,`commerce_orders`.`total`,`commerce_orders`.`created`, `users`.`fullname`";
$commerce_invoices->_joins = ['commerce_orders' => ['commerce_orders.commerce_order_id=commerce_invoices.commerce_order_id'], 'users' => ['users.user_id=commerce_orders.user_id']];
$commerce_invoices->_limit = $this->config->get('limit');
$commerce_invoices->_offset = $offset;
return $this->render('commerce_invoices/index', ['items' => $commerce_invoices->get(), 'pagination' => $this->Pagination->generate(['url' => Uri_helper::url('management/commerce_invoices/index'), 'total' => $commerce_invoices->get(true), 'limit' => $commerce_invoices->_limit, 'offset' => $commerce_invoices->_offset])]);
}
public function indexAction()
{
$this->permission('index');
$settings = $this->module->getSettings($this->_module);
if ($this->validation->validate($this)) {
$this->module->saveSettings($this->_module, ['default_home_page' => $this->input->post('default_home_page')]);
Uri_helper::redirect('management/' . $this->_module);
} else {
return $this->render('home/index', ['home_pages' => Form_helper::arrayToDropdown($this->Config->get('Home')), 'setting' => $settings]);
}
}
public function to_wishlistAction($id = false)
{
if (!$id) {
return Brightery::error404();
}
$userInfo = $this->permissions->getUserInformation();
$product_id = $this->cart->getProductId($id);
$this->cart->remove($id);
$this->database->insert('commerce_wishlist', ['commerce_product_id' => $product_id, 'user_id' => $userInfo->user_id]);
Uri_helper::redirect("commerce_cart");
}
public function indexAction($offset = 0)
{
$this->permission('index');
$this->load->library('pagination');
$pm_issues = new \modules\pm\models\Pm_issues();
$pm_issues->_select = "pm_issue_id, title, pm_issue_statues_id";
$pm_issue_statues = new \modules\pm\models\Pm_issue_statues();
$pm_issue_statues->_select = "pm_issue_statues_id, title, color";
$pm_issue_statues->_limit = $this->config->get('limit');
$pm_issue_statues->_offset = $offset;
return $this->render('pm_sticky_issues/index', ['items' => $pm_issue_statues->get(), 'issues' => $pm_issues->get(), 'issue_model' => $pm_issues, 'pagination' => $this->Pagination->generate(['url' => Uri_helper::url('management/pm_sticky_issues/index'), 'total' => $pm_issue_statues->get(true), 'limit' => $pm_issue_statues->_limit, 'offset' => $pm_issue_statues->_offset])]);
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404("The page you requested is not found.");
}
$model = new \modules\pm\models\Pm_priorities();
$model->pm_priority_id = $id;
if ($model->delete()) {
Uri_helper::redirect("management/pm_priorities");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$pm_issue_statues = new \modules\pm\models\Pm_issue_statues();
$pm_issue_statues->pm_issue_statues_id = $id;
if ($pm_issue_statues->delete()) {
Uri_helper::redirect("management/pm_issue_statues");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model = new \modules\pages\models\Pages();
$model->page_id = $id;
if ($model->delete()) {
Uri_helper::redirect("management/pages");
}
}
public function indexAction()
{
$this->permission('index');
$settings = $this->module->getSettings($this->_module);
$status = Form_helper::queryToDropdown('Pm_issue_statues', 'Pm_issue_statues_id', 'title');
if ($this->validation->validate($this)) {
$this->module->saveSettings($this->_module, ['creation_status' => $this->input->post('creation_status'), 'start_status' => $this->input->post('start_status'), 'pause_status' => $this->input->post('pause_status'), 'done_status' => $this->input->post('done_status')]);
Uri_helper::redirect('management/' . $this->_module . '/pm_settings');
} else {
return $this->render('pm_settings/index', ['status' => $status, 'setting' => $settings]);
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model = new \modules\clinic\models\Clinic_doctor_reviews();
$model->clinic_doctor_review_id = $id;
if ($model->delete()) {
Uri_helper::redirect("management/clinic_doctor_reviews");
}
}
public function indexAction($offset = 0)
{
$this->permission('index');
$this->language->load("modules");
$model = new \modules\store\models\Modules();
$model->_select = "module_id, name, raw_name, status";
$this->load->library('pagination');
$model->_offset = $offset;
$model->_limit = $this->config->get('limit');
$config = ['url' => Uri_helper::url('management/blog_categories/index'), 'total' => $model->get(true), 'limit' => $model->_limit, 'offset' => $model->_offset];
return $this->render('modules/index', ['items' => $model->get(), 'pagination' => $this->Pagination->generate($config)]);
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$classfied = new \modules\classfied\models\Classfied_currencies();
$classfied->classfied_currency_id = $id;
if ($classfied->delete()) {
Uri_helper::redirect("management/classfied_currencies");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$commerce_payment_method = new \modules\commerce\models\Commerce_payment_method();
$commerce_payment_method->commerce_payment_method_id = $id;
if ($commerce_payment_method->delete()) {
Uri_helper::redirect("management/commerce_payment_method");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$commerce_product_attributes = new \modules\commerce\models\Commerce_product_attributes();
$commerce_product_attributes->commerce_product_attribute_id = $id;
if ($commerce_product_attributes->delete()) {
Uri_helper::redirect("management/commerce_product_attributes");
}
}
public function indexAction($offset = 0)
{
$this->permission('index');
$this->language->load("clinic_patients");
$model = new \modules\users\models\Users();
$model->_select = "user_id, fullname";
$this->load->library('pagination');
$model->_limit = $this->config->get('limit');
$model->_offset = $offset;
$config = ['url' => Uri_helper::url('management/clinic_patients/index'), 'total' => $model->get(true), 'limit' => $model->_limit, 'offset' => $model->_offset];
return $this->render('clinic_patients/index', ['items' => $model->get(), 'pagination' => $this->Pagination->generate($config)]);
}
public function to_cartAction($id = false)
{
if (!$id) {
return Brightery::error404();
}
$commerce_wishlist = new \modules\commerce\models\Commerce_wishlist();
$commerce_wishlist->commerce_wishlist_id = $id;
$product_id = $commerce_wishlist->get()->commerce_product_id;
$commerce_wishlist->delete();
$this->cart->add($product_id);
Uri_helper::redirect("commerce_wishlist");
}
public function manageAction($id = false)
{
$this->permission('manage');
$model = new \modules\pm\models\Pm_roles();
$model->attributes = $this->Input->post();
if ($id) {
$model->pm_role_id = $id;
}
if ($model->save()) {
Uri_helper::redirect("management/pm_roles");
}
return $this->render('pm_roles/manage', ['item' => $id ? $model->get() : null]);
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model = new \modules\usergroups\models\Usergroups();
$model_user_group = new \modules\usergroups\models\Usergroup_zones();
$model->usergroup_id = $id;
$model_user_group->usergroup_id = $id;
if ($model_user_group->delete() && $model->delete()) {
Uri_helper::redirect("management/usergroups");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model = new \modules\classfied\models\Classfied_cities();
$model->classfied_city_id = $id;
$city = $model->get();
$model->classfied_country_id = $city->classfied_country_id;
if ($model->delete()) {
Uri_helper::redirect("management/classfied_cities/index/{$city->classfied_country_id}");
}
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$this->model_instance->{$this->model_instance->getPrimaryKey()} = $id;
if (!$this->model_instance->get()) {
return Brightery::error404();
}
if ($this->model_instance->delete()) {
Uri_helper::redirect("management/" . $this->_controller);
}
}
public function urlAction()
{
$str = $this->input->get('url');
$replace = array();
$delimiter = '-';
if (!empty($replace)) {
$str = str_replace((array) $replace, ' ', $str);
}
$clean = $str;
$clean = preg_replace("/[^a-zA-Z0-9اأإبتثجحخدذرزسشصضطظعغفقكلمنهويىة\\/_|+ -]/", '', $clean);
$clean = trim($clean, '-');
$clean = preg_replace("/[\\/_|+ -]+/", $delimiter, $clean);
echo json_encode(['url' => Uri_helper::url('page', $clean), 'permalink' => $clean]);
}
public function indexAction($offset = 0)
{
$query = $this->input->get('q');
$jobs = new \modules\classfied\models\Classfied_jobs();
$jobs->like('classfied_jobs.title', $query);
$jobs->is_active = 1;
$jobs->_select = 'classfied_jobs.classfied_job_id, classfied_jobs.title, classfied_jobs.created_on, classfied_jobs.company, `classfied_countries`.`image` as country_image, `locations`.`image` as location_image, `locations`.`name` as location_name, `classfied_countries`.`name` as country_name,`classfied_types`.`name` as type, `classfied_types`.`color`, (SELECT COUNT(*) FROM classfied_job_applications WHERE classfied_job_applications.classfied_job_id = classfied_jobs.classfied_job_id) as appicants';
$jobs->_joins = ['classfied_countries' => ['`classfied_countries`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_countries` `locations' => ['`locations`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_types' => ['`classfied_types`.`classfied_type_id`=`classfied_jobs`.`classfied_type_id`', 'left']];
$jobs->_order_by['classfied_jobs.classfied_job_id'] = 'DESC';
$this->load->library('pagination');
$jobs->_limit = $this->config->get('limit');
$jobs->_offset = $offset;
return $this->render('classfied_search', ['query' => $query, 'jobs' => $jobs->get(), 'pagination' => $this->pagination->generate(['url' => Uri_helper::url('classfied_search/index/'), 'postfix_url' => '?' . http_build_query($_GET), 'total' => $jobs->get(true), 'limit' => $jobs->_limit, 'offset' => $jobs->_offset])]);
}
public function indexAction()
{
$userInfo = $this->permissions->getUserInformation();
if (!$userInfo) {
Uri_helper::redirect("users");
}
$commerce = new \modules\commerce\models\Commerce_shares('frontend_add');
$commerce->attributes = $this->Input->input['post'];
$commerce->user_id = $userInfo->user_id;
if ($commerce->save()) {
Uri_helper::redirect("commerce_sharing");
} else {
return $this->render('commerce_manage_sharing', ['item' => $commerce->get()]);
}
}
public function indexAction($id, $offset = 0)
{
$category = new \modules\classfied\models\Classfied_categories();
$jobs = new \modules\classfied\models\Classfied_jobs();
$category->classfied_category_id = $id;
$jobs->classfied_category_id = $id;
$jobs->is_active = 1;
$jobs->_select = 'classfied_jobs.classfied_job_id, classfied_jobs.title, classfied_jobs.created_on, classfied_jobs.company, `classfied_countries`.`image` as country_image, `locations`.`image` as location_image, `locations`.`name` as location_name, `classfied_countries`.`name` as country_name,`classfied_types`.`name` as type, `classfied_types`.`color`, (SELECT COUNT(*) FROM classfied_job_applications WHERE classfied_job_applications.classfied_job_id = classfied_jobs.classfied_job_id) as appicants';
$jobs->_joins = ['classfied_countries' => ['`classfied_countries`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_countries` `locations' => ['`locations`.`classfied_country_id`=`classfied_jobs`.`classfied_country_id`', 'left'], 'classfied_types' => ['`classfied_types`.`classfied_type_id`=`classfied_jobs`.`classfied_type_id`', 'left']];
$jobs->_order_by['classfied_jobs.classfied_job_id'] = 'DESC';
$this->load->library('pagination');
$jobs->_limit = $this->config->get('limit');
$jobs->_offset = $offset;
return $this->render('classfied_category', ['item' => $category->get(), 'jobs' => $jobs->get(), 'pagination' => $this->Pagination->generate(['url' => Uri_helper::url('classfied_category/index/' . $id), 'total' => $jobs->get(true), 'limit' => $jobs->_limit, 'offset' => $jobs->_offset])]);
}
public function indexAction($offset = 0)
{
$category = new \modules\commerce\models\Commerce_categories();
$brands = new \modules\commerce\models\Commerce_brands();
$product = new \modules\commerce\models\Commerce_products();
$category->_select = "commerce_category_id, title, parent";
$category->parent = 0;
$sorting = ['' => 'Sort By', 'name' => 'Name', 'low_price' => 'Low Price', 'heigh_price' => 'Heigh Price'];
if (is_array($this->input->get('category_id')) && count($this->input->get('category_id')) && !empty($this->input->get('category_id.0'))) {
$product->where('commerce_category_id IN (SELECT commerce_category_id FROM commerce_categories WHERE parent IN ("' . implode('","', $this->input->get('category_id')) . '")) ');
}
//UNION ALL SELECT ("'. implode('","', $this->input->get('category_id')) .'
if ($this->input->get('brand_id')) {
$product->where('commerce_brand_id IN ("' . implode('","', $this->input->get('brand_id')) . '")');
}
if ($this->input->get('q')) {
$product->like('commerce_products.name', $this->input->get('q'));
}
if ($this->input->get('from_price')) {
$product->like('commerce_products.price >=', $this->input->get('from_price'));
}
if ($this->input->get('to_price')) {
$product->like('commerce_products.price <=', $this->input->get('to_price'));
}
if ($this->input->get('sorting')) {
if ($this->input->get('sorting') == 'name') {
$product->_order_by['name'] = 'ASC';
} elseif ($this->input->get('sorting') == 'low_price') {
$product->_order_by['price'] = 'ASC';
} elseif ($this->input->get('sorting') == 'heigh_price') {
$product->_order_by['price'] = 'DESC';
}
}
$this->load->library('pagination');
$product->_limit = $this->config->get('limit');
$product->_offset = $offset;
return $this->render('commerce_search', ['categories' => $category->get(), 'brands' => $brands->get(), 'sorting' => $sorting, 'products' => $product->get(), 'product_model' => $product, 'pagination' => $this->Pagination->generate(['url' => Uri_helper::url('commerce_search/index'), 'total' => $product->get(true), 'limit' => $product->_limit, 'offset' => $product->_offset])]);
}
public function deleteAction($id = false)
{
$this->permission('delete');
if (!$id) {
return Brightery::error404();
}
$model_schedules = new \modules\clinic\models\Clinic_schedules();
$model_schedules->clinic_doctor_id = $id;
$model_exceptions = new modules\clinic\models\Clinic_schedule_exceptions();
$model_exceptions->clinic_doctor_id = $id;
$model = new \modules\clinic\models\Clinic_doctors();
$model->clinic_doctor_id = $id;
$model_resevration_type = new \modules\clinic\models\Clinic_doctor_reservation_types();
$model_resevration_type->clinic_doctor_id = $id;
$model_reservation = new \modules\clinic\models\Clinic_reservations();
$model_reservation->clinic_doctor_id = $id;
if ($model->delete() && $model_exceptions->delete() && $model_schedules->delete() && $model_resevration_type->delete() && $model_reservation->delete()) {
Uri_helper::redirect("management/clinic_doctors");
}
}
