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, $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) { $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"); }