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