public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $data["homepage_general"] = $cache->index($c, "homepage_general"); $data["homepage_files"] = $cache->index($c, "homepage_files"); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); if ($menu_array) { $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); } /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); /* multimedia */ $multimedia = $cache->index($c, "multimedia"); $data["multimedia"] = json_decode($multimedia); $news = $cache->index($c, "news"); $data["news"] = json_decode($news); $events = $cache->index($c, "events"); $data["events"] = json_decode($events); @(include $c["website.directory"] . "/homepage.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $homepage_general = $cache->index($c, "homepage_general"); $data["homepage_general"] = json_decode($homepage_general); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $include = WEB_DIR . "/contact.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } /* catalog list */ $userlist = $cache->index($c, "userlist"); $data['userlist'] = json_decode($userlist, true); $include = WEB_DIR . "/momxmareblismarTva.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $homepage_general = $cache->index($c, "homepage_general"); $data["homepage_general"] = json_decode($homepage_general); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $photo_gallery_list = $cache->index($c, "photo_gallery_list"); $data["photo_gallery_list"] = json_decode($photo_gallery_list); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ /* fotogallery */ $fotogallery = $cache->index($c, "files_"); $data["fotogallery"] = json_decode($fotogallery); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); @(include $c["website.directory"] . "/photogallery.php"); }
public function template($c, $page) { $cache = new cache(); $include = WEB_DIR . "/worldmaponfullscreen.php"; $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); //vectormap_new $vectormap_new = $cache->index($c, "vectormap_new"); $data["vectormap_new"] = json_decode($vectormap_new, true); // mapfilter $mapfilter = $cache->index($c, "mapfilter"); $data["mapfilter"] = json_decode($mapfilter, true); $include = WEB_DIR . "/worldmaponfullscreen.php"; if (file_exists($include)) { @(include $include); } }
public function template($c) { $conn = $this->conn($c); // connection $module_template_recoverpassword = new module_template_recoverpassword(); $data["message"] = $module_template_recoverpassword->change($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); @(include $c["website.directory"] . "/recover.php"); }
public function template($c) { $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $include = WEB_DIR . "/loadmap.php"; if (file_exists($include)) { @(include $include); } }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $team_general = $cache->index($c, "team_general"); $data["team_general"] = json_decode($team_general, true); $team_list = $cache->index($c, "team_list"); $data["team_list"] = json_decode($team_list); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); @(include $c["website.directory"] . "/team.php"); }
public function template($c, $page) { $conn = $this->conn($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* Upload Users profile picture */ if (isset($_FILES["profileimage"]["name"])) { $model_template_upload_user_logo = new model_template_upload_user_logo(); $upload = $model_template_upload_user_logo->upload($c); } $sql = 'SELECT `username`,`user_type`,`namelname`,`dob`,`email`,`mobile`,`address`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $include = WEB_DIR . "/profilisredaqtireba.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); // $text_files = $cache->index($c,"text_files"); // $data["text_files"] = json_decode($text_files); // $text_documents = $cache->index($c,"text_documents"); // $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ // $left_menu = $cache->index($c,"left_menu"); // $left_menu = json_decode($left_menu); // $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); /*company*/ $data["get_view"] = Input::method("GET", "view") ? (int) Input::method("GET", "view") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $sql = 'SELECT `studio404_users`.* FROM `studio404_users` WHERE `studio404_users`.`user_type`=:user_type AND `studio404_users`.`id`=:idx AND `studio404_users`.`allow`!=:one AND `studio404_users`.`status`!=:one '; $prepare = $conn->prepare($sql); $prepare->execute(array(":user_type" => 'website', ":idx" => $data["get_view"], ":one" => 1)); $data["fetch"] = $prepare->fetch(PDO::FETCH_ASSOC); $retrieve_users_info = new retrieve_users_info(); // echo "<pre>"; // print_r($data["fetch"]); // echo "</pre>"; @(include $c["website.directory"] . "/company.php"); }
public function nav($menu_array, $type) { // echo "<pre>"; // print_r($menu_array); // echo "</pre>"; $get_slug_from_url = new get_slug_from_url(); $slug = $get_slug_from_url->slug(); if ($type == "header") { $o = '<ul class="nav navbar-nav">'; for ($x = 0; $x < count($menu_array->date); $x++) { $active = $menu_array->slug[$x] == $slug ? 'active' : ''; if ($menu_array->sub[$x]) { $o .= '<li class="dropdown ' . $active . '">'; $o .= '<a href="' . MAIN_DIR . $menu_array->slug[$x] . '?v=<?=$menu_array->idx[$x]?>" class="sub_menu_arrow dropdown-toggle" data-toggle="dropdown">' . $menu_array->title[$x] . '</a>'; $o .= $this->sub($menu_array->sub[$x], $slug, "header"); $o .= '</li>'; } else { $o .= '<li class="' . $active . '"><a href="' . MAIN_DIR . $menu_array->slug[$x] . '?v=' . $menu_array->idx[$x] . '">' . $menu_array->title[$x] . '</a></li>'; } } $o .= '</ul>'; } else { if ($type == "footer") { $o = ''; for ($x = 0; $x < count($menu_array->date); $x++) { if ($menu_array->sub[$x]) { // if($x==1){ $offset = ' col-sm-offset-1'; }else{ $offset=""; } // $o .= '<div class="col-sm-2'.$offset.'"><ul class="text_formats_blue">'; $o .= '<div class="col-sm-2"><ul class="text_formats_blue">'; $o .= '<li>'; //'.MAIN_DIR.$menu_array->slug[$x].' $o .= '<a href="javascript:;"><span>' . $menu_array->title[$x] . '</span></a>'; $o .= '</li>'; $o .= $this->sub($menu_array->sub[$x], $slug, "footer"); $o .= '</ul></div>'; } } $o .= '<div class="col-sm-2"><ul class="text_formats_blue">'; $o .= '<li>'; $contactname = LANG == "en" ? 'Contact us' : 'კონტაქტი'; $o .= '<a href="' . MAIN_DIR . 'contact-us"><span>' . $contactname . '</span></a>'; $o .= '</li>'; /* language variables */ $cache = new cache(); $language_data = $cache->index($_SESSION["c"], "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $o .= '<li>' . $data["language_data"]["hotlinelabel"] . '</li>'; $o .= '<li>' . $data["language_data"]["hotlinevalue"] . '</li>'; $o .= '</ul></div>'; } } return $o; }
public function template($c, $page) { $conn = $this->conn($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); /* categories list */ $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* all columns catalog table */ $catalog_table_columns = $cache->index($c, "catalog_table_columns"); $data["catalog_table_columns"] = json_decode($catalog_table_columns, true); /* all columns catalog table */ // $select_form = $cache->index($c,"select_form"); // $data["select_form"] = json_decode($select_form,true); $cid = Input::method("GET", "parent"); $select_form = new select_form(); $data["select_form"] = $select_form->form($c, $cid, LANG_ID); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } if (Input::method("GET", "parent") != "") { $parent = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `idx`=:idx AND `cid`=4 AND `status`!=1 AND `lang`=:lang'; $prepareParent = $conn->prepare($parent); $prepareParent->execute(array(":idx" => Input::method("GET", "parent"), ":lang" => LANG_ID)); if ($prepareParent->rowCount() > 0) { $parent_fetch = $prepareParent->fetch(PDO::FETCH_ASSOC); $data["parent_idx"] = $parent_fetch["idx"]; $data["parent_title"] = $parent_fetch["title"]; } else { redirect::url(WEBSITE . LANG . "/katalogis-marTva"); } } else { redirect::url(WEBSITE . LANG . "/katalogis-marTva"); } $include = WEB_DIR . "/formismarTva.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $sql2 = 'SELECT `studio404_messages`.*, `studio404_users`.`namelname` AS fromusername FROM `studio404_messages`, `studio404_users` WHERE `studio404_messages`.`fromuser`="' . $_SESSION["batumi_id"] . '" AND `studio404_messages`.`draft`=1 AND NOT FIND_IN_SET("' . $_SESSION["batumi_id"] . '",`studio404_messages`.`status`) AND `studio404_messages`.`tousers`=`studio404_users`.`id` ORDER BY `studio404_messages`.`date` DESC LIMIT 20'; $prepare2 = $conn->prepare($sql2); $prepare2->execute(); if ($prepare2->rowCount() > 0) { $fetch2 = $prepare2->fetchAll(PDO::FETCH_ASSOC); $data["messages"] = $fetch2; } else { $data["messages"] = array(); } $catalog_general = $cache->index($c, "catalog_general"); $data["catalog_general"] = json_decode($catalog_general, true); $catalogitemsnovisiable = $cache->index($c, "catalogitemsnovisiable"); $data["catalogitems"] = json_decode($catalogitemsnovisiable, true); $include = WEB_DIR . "/draft.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $structure = $cache->index($c, "structure"); $structure = json_decode($structure); $structure_array = new structure_array(); $data["structure"] = $structure_array->mk($structure); $data["structure_m"] = $structure; /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $include = WEB_DIR . "/struqtura.php"; if (file_exists($include)) { /* ** Here goes any code developer wants to */ @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* Upload Users profile picture */ if (isset($_FILES["profileimage"]["name"])) { $model_template_upload_user_logo = new model_template_upload_user_logo(); $upload = $model_template_upload_user_logo->upload($c); } $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } if (Input::method("GET", "parent") != "") { $parent = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `idx`=:idx AND `cid`=4 AND `status`!=1 AND `lang`=:lang'; $prepareParent = $conn->prepare($parent); $prepareParent->execute(array(":idx" => Input::method("GET", "parent"), ":lang" => LANG_ID)); if ($prepareParent->rowCount() > 0) { $parent_fetch = $prepareParent->fetch(PDO::FETCH_ASSOC); $data["parent_idx"] = $parent_fetch["idx"]; $data["parent_title"] = $parent_fetch["title"]; } else { redirect::url(WEBSITE . LANG . "/katalogis-marTva/damateba"); } } $include = WEB_DIR . "/damateba.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $data["cataloglist_names"] = new cataloglist_names(); $data["getusername"] = new getusername(); $labellists = new labellists(); $data["labellists"] = $labellists->loadlabels($c); $sql2 = 'SELECT `studio404_module_item`.* FROM `studio404_module_item` WHERE `module_idx`=25 AND `studio404_module_item`.`idx`=:idx AND `studio404_module_item`.`lang`=:lang AND `studio404_module_item`.`status`!=:status'; $prepare2 = $conn->prepare($sql2); $prepare2->execute(array(":idx" => Input::method("GET", "view"), ":lang" => LANG_ID, ":status" => 1)); if ($prepare2->rowCount() > 0) { $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC); } else { redirect::url(WEBSITE . LANG . "/welcomesystem"); } $include = WEB_DIR . "/monacemisnaxva.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $include = WEB_DIR . "/contactus.php"; if (file_exists($include)) { $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); $text_documents = $cache->index($c, "text_documents"); $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ // $breadcrups = $cache->index($c,"breadcrups"); // $breadcrups = json_decode($breadcrups); //$data["left_menu"] = $model_template_main_menu->left($left_menu); /* languages */ $hidden_team_list = $cache->index($c, "hidden_team_list"); $data["hidden_team_list"] = json_decode($hidden_team_list, true); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); @(include $include); } else { $controller = new error_page(); } }
public function newsfetch($c) { $conn = $this->conn($c); // connection $cache = new cache(); $news_general = $cache->index($c, "news_general"); $data["news_general"] = json_decode($news_general, true); $news_list = $cache->index($c, "news_list"); $data["news_list"] = json_decode($news_list); /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); $news_files = $cache->index($c, "news_files"); $data['news_files'] = json_decode($news_files); $news_documents = $cache->index($c, "news_documents"); $data['news_documents'] = json_decode($news_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $db_count = new db_count(); $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=2'); @(include $c["website.directory"] . "/news_inside.php"); }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); $text_documents = $cache->index($c, "text_documents"); $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $s = filter_input(INPUT_GET, "s"); if (isset($s) && !empty($s)) { $s = strip_tags($s); $s = str_replace("\\", "", $s); $s = str_replace("..", "", $s); $s = str_replace("-", "", $s); $model_template_search = new model_template_search(); $data["result"] = $model_template_search->studio404_search($c, $s); } else { $data["result"] = array(); } @(include $c["website.directory"] . "/search.php"); }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); // echo "<pre>"; // print_r($data["text_general"]); // echo "</pre>"; // if($data["text_general"][0]["redirectlink"]!="false"){ // redirect::url($data["text_general"][0]["redirectlink"]); // exit(); // } $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); $text_documents = $cache->index($c, "text_documents"); $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* website left menu */ $left_menu = $cache->index($c, "left_menu"); $left_menu = json_decode($left_menu); $data["left_menu"] = $model_template_main_menu->left($left_menu); /* breadcrups */ $breadcrups = $cache->index($c, "breadcrups"); $data["breadcrups"] = json_decode($breadcrups); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); @(include $c["website.directory"] . "/text.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $homepage_general = $cache->index($c, "homepage_general"); $data["homepage_general"] = json_decode($homepage_general); $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); $text_documents = $cache->index($c, "text_documents"); $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); if (Input::method("GET", "search")) { $sql = 'SELECT `idx`,`cid`,`title`,`url` FROM `studio404_components_inside` WHERE `cid` IN (8,9) AND `title` LIKE "%' . Input::method("GET", "search") . '%" AND `lang`=:lang AND `status`!=:status ORDER BY `title` ASC LIMIT 25'; $prepare = $conn->prepare($sql); $prepare->execute(array(":lang" => LANG_ID, ":status" => 1)); $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } else { $data["fetch"] = array(); } $include = WEB_DIR . "/keywords.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c) { $conn = $this->conn($c); // connection if (empty(Input::method("GET", "idx"))) { redirect::url(WEBSITE . LANG . "/welcomesystem"); } $cache = new cache(); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $catalog_general = $cache->index($c, "catalog_general"); $data["catalog_general"] = json_decode($catalog_general, true); $catalog_table_list = $cache->index($c, "catalog_table_list"); $data["catalog_table_list"] = json_decode($catalog_table_list, true); $catalogitems = $cache->index($c, "catalogitems"); $data["catalogitems"] = json_decode($catalogitems, true); $sql2 = 'SELECT COUNT(`studio404_module_item`.`idx`) AS allitems FROM `studio404_module_item` WHERE FIND_IN_SET(' . Input::method("GET", "idx") . ', `studio404_module_item`.`cataloglist`) AND `studio404_module_item`.`lang`=:lang AND `studio404_module_item`.`visibility`!=:visibility AND `studio404_module_item`.`status`!=:status'; $prepare2 = $conn->prepare($sql2); $prepare2->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1)); $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC); @(include $c["website.directory"] . "/catalog.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $include = WEB_DIR . "/welcome.php"; if (file_exists($include)) { $cache = new cache(); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); @(include $include); } else { $controller = new error_page(); } }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $catalog_general = $cache->index($c, "catalog_general"); $data["catalog_general"] = json_decode($catalog_general, true); $catalogitemsnovisiable = $cache->index($c, "catalogitemsnovisiable"); $data["catalogitems"] = json_decode($catalogitemsnovisiable, true); $sql2 = 'SELECT COUNT(`studio404_module_item`.`idx`) AS allitems FROM `studio404_module_item` WHERE `studio404_module_item`.`lang`=:lang AND `studio404_module_item`.`visibility`=:visibility AND `studio404_module_item`.`status`!=:status'; $prepare2 = $conn->prepare($sql2); $prepare2->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1)); $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC); $include = WEB_DIR . "/nebarTvismicema.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); /* sector */ $sector = $cache->index($c, "sector"); $data["sector"] = json_decode($sector); /* sub sector */ $subsector = $cache->index($c, "subsector"); $data["subsector"] = json_decode($subsector); /* products */ $products = $cache->index($c, "products"); $data["products"] = json_decode($products); /* countries */ $countries = $cache->index($c, "countries"); $data["countries"] = json_decode($countries); /* certificates */ $certificates = $cache->index($c, "certificates"); $data["certificates"] = json_decode($certificates); $db_count = new db_count(); if (Input::method("GET", "view") == "companies" or empty(Input::method("GET", "view"))) { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'companies'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "desc" ? "DESC" : 'ASC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_products"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_exportmarkets"] = Input::method("GET", "exportmarkets") ? Input::method("GET", "exportmarkets") : ''; $data["get_certificate"] = Input::method("GET", "certificate") ? Input::method("GET", "certificate") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_users', ' `status`!=1 AND `user_type`="website" AND (`company_type`="manufacturer" OR `company_type`="serviceprovider")'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_users`.`id` DESC'; $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_users`.`sub_sector_id`) AND ' : ''; $products = $data["get_products"] && is_numeric($data["get_products"]) ? ' FIND_IN_SET(' . $data["get_products"] . ',`studio404_users`.`products`) AND ' : ''; $exportmarkets = $data["get_exportmarkets"] && is_numeric($data["get_exportmarkets"]) ? ' FIND_IN_SET(' . $data["get_exportmarkets"] . ',`studio404_users`.`export_markets_id`) AND ' : ''; $certificates = $data["get_certificate"] && is_numeric($data["get_certificate"]) ? ' FIND_IN_SET(' . $data["get_certificate"] . ',`studio404_users`.`certificates`) AND ' : ''; if (!empty($data["get_search"])) { $searchPages = 'SELECT `idx` FROM `studio404_pages` WHERE `title` LIKE "%?%" AND `slug` LIKE "selectoption%" AND `status`!=1'; $prepareSearch = $conn->prepare($searchPages); // $searchQuery = urldecode($data["get_search"]); $searchQuery = str_replace(array('"', '.'), array('', ''), $data["get_search"]); $prepareSearch->execute(array($searchQuery)); $s = ''; if ($prepareSearch->rowCount() > 0) { $fetchPages = $prepareSearch->fetchAll(PDO::FETCH_ASSOC); foreach ($fetchPages as $value) { $s .= ' OR ( FIND_IN_SET("' . $value['idx'] . '",`sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`sub_sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`products`) OR FIND_IN_SET("' . $value['idx'] . '",`export_markets_id`) OR FIND_IN_SET("' . $value['idx'] . '",`certificates`) ) '; } } if ($s != '') { $search = '(`studio404_users`.`id`="' . $searchQuery . '" OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" ' . $s . ' OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") ' . $s . ') AND '; } else { $search = '`studio404_users`.`id`="' . $searchQuery . '" OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") AND '; } } else { $search = ""; } if (Input::method("GET", "csv")) { $sql = 'SELECT `studio404_users`.`id` AS su_id, `studio404_users`.`username` AS su_username, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_users`.`sub_sector_id`) AS su_sub_sector_title, `studio404_users`.`namelname` AS su_namelname, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_users`.`products`) AS su_products, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_users`.`export_markets_id`) AS su_exportmarkets, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_users`.`certificates`) AS su_certificates FROM `studio404_users` WHERE `studio404_users`.`user_type`=:user_type AND `studio404_users`.`allow`!=:one AND `studio404_users`.`namelname`<>"" AND `studio404_users`.`picture`<>"" AND `studio404_users`.`sector_id`<>"" AND `studio404_users`.`sub_sector_id`<>"" AND `studio404_users`.`products`<>"" AND ' . $subsectors . ' ' . $products . ' ' . $exportmarkets . ' ' . $certificates . ' ' . $search . ' (`studio404_users`.`company_type`=:manufacturer OR `studio404_users`.`company_type`=:serviceprovider) AND `studio404_users`.`status`!=:one ' . $orderBy . ''; } else { $sql = 'SELECT `studio404_users`.`id` AS su_id, `studio404_users`.`username` AS su_username, `studio404_users`.`sub_sector_id` AS su_sub_sector_id, `studio404_users`.`namelname` AS su_namelname, `studio404_users`.`picture` AS su_picture, `studio404_users`.`products` AS su_products, `studio404_users`.`export_markets_id` AS su_export_markets_id, `studio404_users`.`certificates` AS su_certificates, `studio404_users`.`company_type` AS su_companytype FROM `studio404_users` WHERE `studio404_users`.`user_type`=:user_type AND `studio404_users`.`allow`!=:one AND `studio404_users`.`namelname`<>"" AND `studio404_users`.`picture`<>"" AND `studio404_users`.`sector_id`<>"" AND `studio404_users`.`sub_sector_id`<>"" AND `studio404_users`.`products`<>"" AND ' . $subsectors . ' ' . $products . ' ' . $exportmarkets . ' ' . $certificates . ' ' . $search . ' (`studio404_users`.`company_type`=:manufacturer OR `studio404_users`.`company_type`=:serviceprovider) AND `studio404_users`.`status`!=:one ' . $orderBy . ' ' . $limit . ' '; } $prepare = $conn->prepare($sql); $prepare->execute(array(":manufacturer" => 'manufacturer', ":serviceprovider" => 'serviceprovider', ":user_type" => 'website', ":one" => 1)); if ($prepare->rowCount() > 0) { if (Input::method("GET", "csv")) { // Create array $filename = "userstable.csv"; $list = array(); // Append results to array array_push($list, array("ID", "EMAIL", "Subsector", "Company Name", "Product", "Export market", "certificate")); while ($row = $prepare->fetch(PDO::FETCH_ASSOC)) { array_push($list, array_values($row)); } // Output array into CSV file $fp = fopen('php://output', 'w'); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="' . $filename . '"'); foreach ($list as $ferow) { fputcsv($fp, $ferow); } exit; } $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } else { $data["fetch"] = array(); } } if (Input::method("GET", "view") == "products") { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'companies'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "asc" ? "ASC" : 'DESC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_products"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=3'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_module_item`.`date` ' . urlencode($data["get_sort"]); $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_module_item`.`sub_sector_id`) AND ' : ''; $products = $data["get_products"] && is_numeric($data["get_products"]) ? ' FIND_IN_SET(' . $data["get_products"] . ',`studio404_module_item`.`products`) AND ' : ''; if (!empty($data["get_search"])) { $searchQuery = str_replace(array('"', '.'), array('', ''), $data["get_search"]); $searchPages = 'SELECT `idx` FROM `studio404_pages` WHERE `title` LIKE "%?%" AND `slug` LIKE "selectoption%" AND `status`!=1'; $prepareSearch = $conn->prepare($searchPages); $prepareSearch->execute(array($searchQuery)); $s = ''; if ($prepareSearch->rowCount() > 0) { $fetchPages = $prepareSearch->fetchAll(PDO::FETCH_ASSOC); foreach ($fetchPages as $value) { $s .= ' OR ( FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`sub_sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`products`) ) '; } } if ($s != '') { $search = '( `studio404_module_item`.`id`="' . $searchQuery . '" OR `studio404_module_item`.`title` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`title` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`title`) AGAINST ("' . $searchQuery . '") OR `studio404_module_item`.`long_description` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`long_description` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`long_description`) AGAINST ("' . $searchQuery . '") OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") ' . $s . ' ) AND '; //OR MATCH(`studio404_users`.`namelname`) AGAINST ("'.$data["get_search"].'") } else { $search = '( `studio404_module_item`.`id`="' . $searchQuery . '" OR `studio404_module_item`.`title` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`title` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`title`) AGAINST ("' . $searchQuery . '") OR `studio404_module_item`.`long_description` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`long_description` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`long_description`) AGAINST ("' . $searchQuery . '") OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") ) AND '; } } else { $search = ""; } //echo $search; if (Input::method("GET", "csv")) { $sql = 'SELECT `studio404_module_item`.`title`, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`sub_sector_id`) AS su_sector, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`hscode`) AS su_hscode, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`products`) AS su_products, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_users`.`namelname` AS users_name, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=3 AND ' . $subsectors . ' ' . $products . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one AND `studio404_users`.`allow`!=:one '; } else { $sql = 'SELECT `studio404_module_item`.`id`, `studio404_module_item`.`idx`, `studio404_module_item`.`title`, `studio404_module_item`.`picture`, `studio404_module_item`.`sub_sector_id`, `studio404_module_item`.`hscode`, `studio404_module_item`.`products`, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_module_item`.`long_description`, `studio404_users`.`id` AS users_id, `studio404_users`.`namelname` AS users_name, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=3 AND ' . $subsectors . ' ' . $products . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one AND `studio404_users`.`allow`!=:one ' . $orderBy . ' ' . $limit . ' '; } $prepare = $conn->prepare($sql); $prepare->execute(array(":two" => 2, ":one" => 1)); if ($prepare->rowCount() > 0) { if (Input::method("GET", "csv")) { // Create array $filename = "producttable.csv"; $list = array(); // Append results to array array_push($list, array("Title", "SubSector", "HScode", "Product", "Shelf life", "Packaging", "Awards", "Username", "Users Company Type")); while ($row = $prepare->fetch(PDO::FETCH_ASSOC)) { array_push($list, array_values($row)); } // Output array into CSV file $fp = fopen('php://output', 'w'); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="' . $filename . '"'); foreach ($list as $ferow) { fputcsv($fp, $ferow); } exit; } $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } else { $data["fetch"] = array(); } } if (Input::method("GET", "view") == "services") { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'services'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "asc" ? "ASC" : 'DESC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_services"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=4'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_module_item`.`date` ' . urlencode($data["get_sort"]); $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_module_item`.`sub_sector_id`) AND ' : ''; $services = $data["get_services"] && is_numeric($data["get_services"]) ? ' FIND_IN_SET(' . $data["get_services"] . ',`studio404_module_item`.`products`) AND ' : ''; if (!empty($data["get_search"])) { $searchQuery = str_replace(array('"', '.'), array('', ''), $data["get_search"]); $searchPages = 'SELECT `idx` FROM `studio404_pages` WHERE `title` LIKE "%?%" AND `slug` LIKE "selectoption%" AND `status`!=1'; $prepareSearch = $conn->prepare($searchPages); $prepareSearch->execute(array($searchQuery)); $s = ''; if ($prepareSearch->rowCount() > 0) { $fetchPages = $prepareSearch->fetchAll(PDO::FETCH_ASSOC); foreach ($fetchPages as $value) { $s .= ' OR ( FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`sub_sector_id`) OR FIND_IN_SET("' . $value['idx'] . '",`studio404_module_item`.`products`) ) '; } } if ($s != '') { $search = '( `studio404_module_item`.`id`="' . $searchQuery . '" OR `studio404_module_item`.`title` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`title` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`title`) AGAINST ("' . $searchQuery . '") OR `studio404_module_item`.`long_description` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`long_description` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`long_description`) AGAINST ("' . $searchQuery . '") OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") ' . $s . ' ) AND '; //$search = (!empty($data["get_search"])) ? '`studio404_module_item`.`title` LIKE "%'.$data["get_search"].'%" AND ' : ''; } else { $search = '( `studio404_module_item`.`id`="' . $searchQuery . '" OR `studio404_module_item`.`title` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`title` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`title`) AGAINST ("' . $searchQuery . '") OR `studio404_module_item`.`long_description` LIKE "' . $searchQuery . '%" OR `studio404_module_item`.`long_description` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_module_item`.`long_description`) AGAINST ("' . $searchQuery . '") OR `studio404_users`.`namelname` LIKE "' . $searchQuery . '%" OR `studio404_users`.`namelname` LIKE "%' . $searchQuery . '" OR MATCH(`studio404_users`.`namelname`) AGAINST ("' . $searchQuery . '") ) AND'; } } else { $search = ""; } //echo $search; //$search = (!empty($data["get_search"])) ? '`studio404_module_item`.`long_description` LIKE "%'.$data["get_search"].'%" AND ' : ''; if (Input::method("GET", "csv")) { $sql = 'SELECT `studio404_module_item`.`title`, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`sub_sector_id`) AS su_sector, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`hscode`) AS su_hscode, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`products`) AS su_products, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_users`.`namelname` AS users_name, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=4 AND ' . $subsectors . ' ' . $services . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one AND `studio404_users`.`allow`!=:one '; } else { $sql = 'SELECT `studio404_module_item`.`id`, `studio404_module_item`.`idx`, `studio404_module_item`.`title`, `studio404_module_item`.`picture`, `studio404_module_item`.`sub_sector_id`, `studio404_module_item`.`hscode`, `studio404_module_item`.`products`, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_module_item`.`long_description`, `studio404_users`.`id` AS users_id, `studio404_users`.`namelname` AS users_name, `studio404_users`.`picture` AS users_picture, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=4 AND ' . $subsectors . ' ' . $services . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one AND `studio404_users`.`allow`!=:one ' . $orderBy . ' ' . $limit . ' '; } $prepare = $conn->prepare($sql); $prepare->execute(array(":two" => 2, ":one" => 1)); if ($prepare->rowCount() > 0) { if (Input::method("GET", "csv")) { // Create array $filename = "servicetable.csv"; $list = array(); // Append results to array array_push($list, array("Title", "SubSector", "HScode", "Product", "Shelf life", "Packaging", "Awards", "Username", "Users Company Type")); while ($row = $prepare->fetch(PDO::FETCH_ASSOC)) { array_push($list, array_values($row)); } // Output array into CSV file $fp = fopen('php://output', 'w'); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="' . $filename . '"'); foreach ($list as $ferow) { fputcsv($fp, $ferow); } exit; } $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } else { $data["fetch"] = array(); } } @(include $c["website.directory"] . "/exportcatalog.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $welcomepage_categories = $cache->index($c, "welcomepage_categories"); $data["welcomepage_categories"] = json_decode($welcomepage_categories, true); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id'; $prepare = $conn->prepare($sql); $prepare->execute(array(":id" => $_SESSION["batumi_id"])); if ($prepare->rowCount() > 0) { $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $data["userdata"] = $fetch; } else { redirect::url(WEBSITE); } $form = $cache->index($c, "form"); $data["form"] = json_decode($form, true); if (Input::method("POST", "file")) { $model_admin_selectLanguage = new model_admin_selectLanguage(); $lang_query = $model_admin_selectLanguage->select_languages($c); for ($input_file_count = 0; $input_file_count < count($_FILES["file"]["name"]); $input_file_count++) { foreach ($_FILES["file"]["name"][$input_file_count] as $key => $value) { if ($value != "") { $gallery_idx = Input::method("POST", "gallery_idx_post"); $insert_admin = $_SESSION["batumi_id"]; $filenumber = $_POST['filenumber']; $filenumber = $filenumber[$input_file_count]; $inputname = Input::method("POST", "form-name-" . $filenumber); $attach = Input::method("POST", "form-attach-" . $filenumber); $important = Input::method("POST", "form-important-" . $filenumber); $multiple = Input::method("POST", "form-multiple-" . $filenumber); $format = explode(",", Input::method("POST", "form-format-" . $filenumber)); //$format = end($format); $filename = $_FILES["file"]["name"][$input_file_count][$key]; $filesize = $_FILES["file"]["size"][$input_file_count][$key]; $filetype_arr = explode(".", $filename); $filetype = end($filetype_arr); if (in_array($filetype, $format)) { $sqlm = 'SELECT MAX(`idx`)+1 AS maxid FROM `studio404_gallery_file`'; $querym = $conn->query($sqlm); $rowm = $querym->fetch(PDO::FETCH_ASSOC); $max_idx = $rowm['maxid'] ? $rowm['maxid'] : 1; $sql_max_posm = 'SELECT MAX(`position`)+1 AS maxpos FROM `studio404_gallery_file` WHERE `status`!=:status'; $preparem = $conn->prepare($sql_max_posm); $preparem->execute(array(":status" => 1)); $row2m = $preparem->fetch(PDO::FETCH_ASSOC); $max_pos = $row2m['maxpos'] ? $row2m['maxpos'] : 1; $filename_new = $filetype_arr[0] . md5(sha1(time())) . "." . $filetype; $target_file = DIR . "files/document/" . $filename_new; if (move_uploaded_file($_FILES["file"]["tmp_name"][$input_file_count][$key], $target_file)) { foreach ($lang_query as $lang_row) { $insert_into_gallery = 'INSERT INTO `studio404_gallery_file` SET `idx`=:idx, `date`=:date, `gallery_idx`=:gallery_idx, `file`=:file, `fileinputname`=:fileinputname, `media_type`=:media_type, `title`=:title, `description`=:description, `filesize`=:filesize, `insert_admin`=:insert_admin, `position`=:position, `lang`=:lang'; $prepare_insert = $conn->prepare($insert_into_gallery); $prepare_insert->execute(array(":idx" => $max_idx, ":date" => time(), ":gallery_idx" => $gallery_idx, ":file" => $filename_new, ":fileinputname" => $inputname, ":media_type" => $filetype, ":title" => "Not Defined", ":description" => "Not Defined", ":filesize" => $filesize, ":insert_admin" => $insert_admin, ":position" => $max_pos, ":lang" => $lang_row["id"])); } } } } } } } if (Input::method("POST", "close_after_add")) { $parent = Input::method("GET", "parent"); $back = Input::method("GET", "back"); redirect::url(WEBSITE . LANG . "/" . $back . "?idx=" . $parent); } $include = WEB_DIR . "/monacemisdamateba.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }
public function template($c) { $conn = $this->conn($c); // connection // upload function $model_template_upload_user_logo = new model_template_upload_user_logo(); $upload = $model_template_upload_user_logo->upload($c); $sectors_subsectors_products = new sectors_subsectors_products(); $data["sectors"] = $sectors_subsectors_products->sectors($c); $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); $text_documents = $cache->index($c, "text_documents"); $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* sector */ $sector = $cache->index($c, "sector"); $data["sector"] = json_decode($sector); /* countries */ $countries = $cache->index($c, "countries"); $data["countries"] = json_decode($countries); /* certificates */ $certificates = $cache->index($c, "certificates"); $data["certificates"] = json_decode($certificates); /* Company size */ $companysize = $cache->index($c, "companysize"); $data["companysize"] = json_decode($companysize); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); if (!isset($_SESSION["user_data"]["companyname"]) && isset($_SESSION["tradewithgeorgia_username"])) { $sql = 'SELECT * FROM `studio404_users` WHERE `id`=:companyId AND `username`=:username AND `status`!=:one'; $prepare = $conn->prepare($sql); $prepare->execute(array(":username" => $_SESSION["tradewithgeorgia_username"], ":companyId" => $_SESSION["tradewithgeorgia_user_id"], ":one" => 1)); $fetch = $prepare->fetch(PDO::FETCH_ASSOC); $_SESSION["user_data"]["id"] = $fetch["id"]; // * $_SESSION["user_data"]["allow"] = $fetch["allow"]; // * $_SESSION["user_data"]["picture"] = $fetch["picture"]; // * $_SESSION["user_data"]["companyname"] = $fetch["namelname"]; // * $_SESSION["user_data"]["sector"] = $fetch["sector_id"]; // * $_SESSION["user_data"]["subsector"] = $fetch["sub_sector_id"]; // * $_SESSION["user_data"]["establishedin"] = $fetch["established_in"]; $_SESSION["user_data"]["productioncapasity"] = $fetch["production_capacity"]; $_SESSION["user_data"]["address"] = $fetch["address"]; $_SESSION["user_data"]["mobiles"] = $fetch["mobile"]; // * $_SESSION["user_data"]["numemploy"] = $fetch["number_of_employes"]; $_SESSION["user_data"]["certificates"] = $fetch["certificates"]; $_SESSION["user_data"]["contactpersones"] = $fetch["contact_person"]; $_SESSION["user_data"]["officephone"] = $fetch["office_phone"]; $_SESSION["user_data"]["companysize"] = $fetch["company_size"]; $_SESSION["user_data"]["webaddress"] = $fetch["web_address"]; $_SESSION["user_data"]["ad_position1"] = $fetch["ad_position1"]; // * $_SESSION["user_data"]["ad_email1"] = $fetch["ad_email1"]; //* $_SESSION["user_data"]["ad_person2"] = $fetch["ad_person2"]; $_SESSION["user_data"]["ad_position2"] = $fetch["ad_person2"]; $_SESSION["user_data"]["ad_mobile2"] = $fetch["ad_mobile2"]; $_SESSION["user_data"]["ad_email2"] = $fetch["ad_email2"]; $_SESSION["user_data"]["ad_upload_catalog"] = $fetch["ad_upload_catalog"]; $_SESSION["user_data"]["contactemail"] = $fetch["email"]; // * $_SESSION["user_data"]["about"] = $fetch["about"]; // * $_SESSION["user_data"]["products"] = $fetch["products"]; $_SESSION["user_data"]["exportmarkets"] = $fetch["export_markets_id"]; } // calculate $data["calculate"] = calculate::filled($_SESSION["user_data"]); $pre = 100 - $data["calculate"]["tocomplete"]; $calculate = new calculate(); $calculate->updatedata($c, $_SESSION["user_data"]["id"], $pre); // select products $products_sql = 'SELECT `studio404_module_item`.`idx`, `studio404_module_item`.`title`, `studio404_module_item`.`picture`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_module_item`.`production_capacity`, `studio404_module_item`.`long_description`, `studio404_module_item`.`productanalisis`, `studio404_module_item`.`admin_com`, `studio404_module_item`.`visibility`, `studio404_pages`.`title` AS hs_title FROM `studio404_module_item`, `studio404_pages` WHERE `studio404_module_item`.`insert_admin`=:insert_admin AND `studio404_module_item`.`module_idx`=:module_idx AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`hscode`=`studio404_pages`.`idx` AND `studio404_pages`.`status`!=:one ORDER BY `studio404_module_item`.`date` DESC LIMIT 5'; $prepare_product = $conn->prepare($products_sql); $prepare_product->execute(array(":insert_admin" => $_SESSION["tradewithgeorgia_user_id"], ":module_idx" => 3, ":one" => 1)); $data["myproducts"] = $prepare_product->fetchAll(PDO::FETCH_ASSOC); $db_count = new db_count(); $session_user_id = (int) $_SESSION["tradewithgeorgia_user_id"]; $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `module_idx`=3 AND `insert_admin`=' . $session_user_id); @(include $c["website.directory"] . "/profileproducts.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); /* contact_page_data */ $contact_page_data = $cache->index($c, "contact_page_data"); $data["contact_data"] = json_decode($contact_page_data, true); /* sector */ $sector = $cache->index($c, "sector"); $data["sector"] = json_decode($sector); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : ''; $data["get_type"] = Input::method("GET", "type") ? urlencode(Input::method("GET", "type")) : ''; $data["get_sector"] = Input::method("GET", "sector") ? Input::method("GET", "sector") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $db_count = new db_count(); $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=5'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_module_item`.`date` DESC'; $sector = $data["get_sector"] && is_numeric($data["get_sector"]) ? ' FIND_IN_SET(' . $data["get_sector"] . ',`studio404_module_item`.`sector_id`) AND ' : ''; $ctype = $data["get_type"] ? '`studio404_users`.`company_type`="' . $data["get_type"] . '" AND ' : ''; $type = $data["get_view"] ? '`studio404_module_item`.`type`="' . $data["get_view"] . '" AND ' : ''; $search = !empty($data["get_search"]) ? '`studio404_module_item`.`title` LIKE "%' . $data["get_search"] . '%" AND ' : ''; try { $sql = 'SELECT `studio404_module_item`.`id`, `studio404_module_item`.`idx`, `studio404_module_item`.`date`, `studio404_module_item`.`title`, `studio404_module_item`.`type`, `studio404_module_item`.`long_description`, `studio404_users`.`id` AS users_id, `studio404_users`.`namelname` AS users_name, `studio404_users`.`company_type` AS su_companytype, (SELECT `title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`sector_id` AND `lang`=:lang) AS sector_name FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=5 AND ' . $sector . ' ' . $type . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND ' . $ctype . ' `studio404_users`.`status`!=:one ' . $orderBy . ' ' . $limit . ' '; // echo $sql; $prepare = $conn->prepare($sql); $prepare->execute(array(":lang" => LANG_ID, ":two" => 2, ":one" => 1)); $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $redirect = new redirect(); $redirect->go(WEBSITE); die; } @(include $c["website.directory"] . "/businessportal.php"); }
public function template($c) { $conn = $this->conn($c); // connection $cache = new cache(); $text_general = $cache->index($c, "text_general"); $data["text_general"] = json_decode($text_general, true); $text_files = $cache->index($c, "text_files"); $data["text_files"] = json_decode($text_files); // $text_documents = $cache->index($c,"text_documents"); // $data["text_documents"] = json_decode($text_documents); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); /* sector */ $sector = $cache->index($c, "sector"); $data["sector"] = json_decode($sector); /* sub sector */ $subsector = $cache->index($c, "subsector"); $data["subsector"] = json_decode($subsector); /* products */ $products = $cache->index($c, "products"); $data["products"] = json_decode($products); /* countries */ $countries = $cache->index($c, "countries"); $data["countries"] = json_decode($countries); /* certificates */ $certificates = $cache->index($c, "certificates"); $data["certificates"] = json_decode($certificates); $db_count = new db_count(); if (Input::method("GET", "view") == "companies" or empty(Input::method("GET", "view"))) { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'companies'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "desc" ? "DESC" : 'ASC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_products"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_exportmarkets"] = Input::method("GET", "exportmarkets") ? Input::method("GET", "exportmarkets") : ''; $data["get_certificate"] = Input::method("GET", "certificate") ? Input::method("GET", "certificate") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_users', ' `status`!=1 AND `user_type`="website" AND (`company_type`="manufacturer" OR `company_type`="serviceprovider")'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_users`.`id` DESC'; $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_users`.`sub_sector_id`) AND ' : ''; $products = $data["get_products"] && is_numeric($data["get_products"]) ? ' FIND_IN_SET(' . $data["get_products"] . ',`studio404_users`.`products`) AND ' : ''; $exportmarkets = $data["get_exportmarkets"] && is_numeric($data["get_exportmarkets"]) ? ' FIND_IN_SET(' . $data["get_exportmarkets"] . ',`studio404_users`.`export_markets_id`) AND ' : ''; $certificates = $data["get_certificate"] && is_numeric($data["get_certificate"]) ? ' FIND_IN_SET(' . $data["get_certificate"] . ',`studio404_users`.`certificates`) AND ' : ''; $search = !empty($data["get_search"]) ? '`studio404_users`.`namelname` LIKE "%' . $data["get_search"] . '%" AND ' : ''; $sql = 'SELECT `studio404_users`.`id` AS su_id, `studio404_users`.`username` AS su_username, `studio404_users`.`sub_sector_id` AS su_sub_sector_id, `studio404_users`.`namelname` AS su_namelname, `studio404_users`.`picture` AS su_picture, `studio404_users`.`products` AS su_products, `studio404_users`.`export_markets_id` AS su_export_markets_id, `studio404_users`.`certificates` AS su_certificates, `studio404_users`.`company_type` AS su_companytype FROM `studio404_users` WHERE `studio404_users`.`user_type`=:user_type AND `studio404_users`.`allow`!=:one AND ' . $subsectors . ' ' . $products . ' ' . $exportmarkets . ' ' . $certificates . ' ' . $search . ' (`studio404_users`.`company_type`=:manufacturer OR `studio404_users`.`company_type`=:serviceprovider) AND `studio404_users`.`status`!=:one ' . $orderBy . ' ' . $limit . ' '; $prepare = $conn->prepare($sql); $prepare->execute(array(":manufacturer" => 'manufacturer', ":serviceprovider" => 'serviceprovider', ":user_type" => 'website', ":one" => 1)); $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } if (Input::method("GET", "view") == "products") { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'companies'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "asc" ? "ASC" : 'DESC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_products"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=3'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_module_item`.`date` ' . urlencode($data["get_sort"]); $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_module_item`.`sub_sector_id`) AND ' : ''; $products = $data["get_products"] && is_numeric($data["get_products"]) ? ' FIND_IN_SET(' . $data["get_products"] . ',`studio404_module_item`.`products`) AND ' : ''; $search = !empty($data["get_search"]) ? '`studio404_module_item`.`title` LIKE "%' . $data["get_search"] . '%" AND ' : ''; $sql = 'SELECT `studio404_module_item`.`id`, `studio404_module_item`.`idx`, `studio404_module_item`.`title`, `studio404_module_item`.`picture`, `studio404_module_item`.`sub_sector_id`, `studio404_module_item`.`hscode`, `studio404_module_item`.`products`, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_module_item`.`long_description`, `studio404_users`.`id` AS users_id, `studio404_users`.`namelname` AS users_name, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=3 AND ' . $subsectors . ' ' . $products . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one ' . $orderBy . ' ' . $limit . ' '; $prepare = $conn->prepare($sql); $prepare->execute(array(":two" => 2, ":one" => 1)); $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } if (Input::method("GET", "view") == "services") { $data["get_view"] = Input::method("GET", "view") ? Input::method("GET", "view") : 'services'; $data["get_sort"] = Input::method("GET", "sort") && Input::method("GET", "sort") == "asc" ? "ASC" : 'DESC'; $data["get_subsector"] = Input::method("GET", "subsector") ? urlencode(Input::method("GET", "subsector")) : ''; $data["get_services"] = Input::method("GET", "products") ? Input::method("GET", "products") : ''; $data["get_search"] = Input::method("GET", "search") ? Input::method("GET", "search") : ''; $data["get_pn"] = Input::method("GET", "pn") ? Input::method("GET", "pn") : 1; $data["get_token"] = Input::method("GET", "token") ? Input::method("GET", "token") : ''; $data["count"] = $db_count->retrieve($c, 'studio404_module_item', ' `status`!=1 AND `visibility`=2 AND `module_idx`=4'); $limit = ' LIMIT ' . ($data["get_pn"] - 1) * 10 . ', 10'; $orderBy = ' ORDER BY `studio404_module_item`.`date` ' . urlencode($data["get_sort"]); $subsectors = $data["get_subsector"] && is_numeric($data["get_subsector"]) ? ' FIND_IN_SET(' . $data["get_subsector"] . ',`studio404_module_item`.`sub_sector_id`) AND ' : ''; $services = $data["get_services"] && is_numeric($data["get_services"]) ? ' FIND_IN_SET(' . $data["get_services"] . ',`studio404_module_item`.`products`) AND ' : ''; $search = !empty($data["get_search"]) ? '`studio404_module_item`.`long_description` LIKE "%' . $data["get_search"] . '%" AND ' : ''; $sql = 'SELECT `studio404_module_item`.`id`, `studio404_module_item`.`idx`, `studio404_module_item`.`title`, `studio404_module_item`.`picture`, `studio404_module_item`.`sub_sector_id`, `studio404_module_item`.`hscode`, `studio404_module_item`.`products`, `studio404_module_item`.`shelf_life`, `studio404_module_item`.`packaging`, `studio404_module_item`.`awards`, `studio404_module_item`.`long_description`, `studio404_users`.`id` AS users_id, `studio404_users`.`namelname` AS users_name, `studio404_users`.`picture` AS users_picture, `studio404_users`.`company_type` AS su_companytype FROM `studio404_module_item`, `studio404_users` WHERE `studio404_module_item`.`module_idx`=4 AND ' . $subsectors . ' ' . $services . ' ' . $search . ' `studio404_module_item`.`visibility`=:two AND `studio404_module_item`.`status`!=:one AND `studio404_module_item`.`insert_admin`=`studio404_users`.`id` AND `studio404_users`.`status`!=:one ' . $orderBy . ' ' . $limit . ' '; $prepare = $conn->prepare($sql); $prepare->execute(array(":two" => 2, ":one" => 1)); $data["fetch"] = $prepare->fetchAll(PDO::FETCH_ASSOC); } @(include $c["website.directory"] . "/exportcatalog.php"); }
public function template($c, $page) { $conn = $this->conn($c); // connection $cache = new cache(); $homepage_general = $cache->index($c, "homepage_general"); $data["homepage_general"] = json_decode($homepage_general); $data["homepage_files"] = $cache->index($c, "homepage_files"); /* languages */ $languages = $cache->index($c, "languages"); $data["languages"] = json_decode($languages); /* language variables */ $language_data = $cache->index($c, "language_data"); $language_data = json_decode($language_data); $model_template_makevars = new model_template_makevars(); $data["language_data"] = $model_template_makevars->vars($language_data); /* website menu header & footer */ $menu_array = $cache->index($c, "main_menu"); $menu_array = json_decode($menu_array); if ($menu_array) { $model_template_main_menu = new model_template_main_menu(); $data["main_menu"] = $model_template_main_menu->nav($menu_array, "header"); $data["footer_menu"] = $model_template_main_menu->nav($menu_array, "footer"); } /* components */ $components = $cache->index($c, "components"); $data["components"] = json_decode($components); $select = 'SELECT * FROM `studio404_users_pass_recover` WHERE `hash`=:hash AND `status`!=1'; $prepare = $conn->prepare($select); $prepare->execute(array(":hash" => Input::method("GET", "token"))); if ($prepare->rowCount() > 0) { $fetchme = $prepare->fetch(PDO::FETCH_ASSOC); $data["recover_id"] = $fetchme["id"]; $data["recover_username"] = $fetchme["usersemail"]; $data["newpassword"] = $fetchme["temp"]; $data["newpassword_md5"] = md5($fetchme["temp"]); //update password $update = 'UPDATE `studio404_users` SET `password`=:newpassword WHERE `username`=:username AND `status`!=1'; $pre_update = $conn->prepare($update); $pre_update->execute(array(":newpassword" => $data["newpassword_md5"], ":username" => $data["recover_username"])); // update recover $update2 = 'UPDATE `studio404_users_pass_recover` SET `status`=1 WHERE `id`=:id'; $pre_update2 = $conn->prepare($update2); $pre_update2->execute(array(":id" => $data["recover_id"])); if (LANG == "ge") { $data["users_message"] = '<strong>მომხმარებლის სახელი: </strong> ' . $data["recover_username"] . '<br />'; $data["users_message"] .= '<strong>დროებითი პაროლი: </strong> ' . $data["newpassword"] . '<br />'; } else { $data["users_message"] = '<strong>Username: </strong> ' . $data["recover_username"] . '<br />'; $data["users_message"] .= '<strong>Temporary Password: </strong> ' . $data["newpassword"] . '<br />'; } } else { redirect::url(WEBSITE . LANG . "/page404"); } $include = WEB_DIR . "/temporarypassword.php"; if (file_exists($include)) { @(include $include); } else { $controller = new error_page(); } }