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();
}
}
