function update($post_category_name, $post_category_description, $post_category_level, $post_category_order, $post_active, $post_visibility, $post_lang_code, $post_id_param)
{
$conn = connDB();
$sql = "UPDATE tbl_category_lang set `category_name` = '{$post_category_name}', \n `category_description` = '{$post_category_description}', \n\t\t\t\t\t\t\t\t\t\t `category_level` = '{$post_category_level}', \n\t\t\t\t\t\t\t\t\t\t `category_order` = '{$post_category_order}', \n\t\t\t\t\t\t\t\t\t\t `active` = '{$post_active}', \n\t\t\t\t\t\t\t\t\t\t `visibility` = '{$post_visibility}', \n\t\t\t\t\t\t\t\t\t\t `language_code` = '{$post_lang_code}'\n\t\t WHERE `id_param` = '{$post_id_param}'\n\t\t\t";
$query = mysql_query($sql, $conn) or die(mysql_error());
return $result;
}
function listCategoryColor($level, $parent, $current_category, $data)
{
$conn = connDB();
$get_data = mysql_query("SELECT * from tbl_tag AS cat INNER JOIN tbl_tag_relation AS cat_rel ON cat.category_id = cat_rel.category_child\n\t WHERE cat.category_level = '{$level}' AND cat_rel.category_parent = '{$parent}' ORDER BY category_order", $conn);
if (mysql_num_rows($get_data) != null && mysql_num_rows($get_data) != 0) {
for ($counter = 1; $counter <= mysql_num_rows($get_data); $counter++) {
$get_data_array = mysql_fetch_array($get_data);
$new_level = $level * 1 + 1;
$new_parent = $get_data_array["category_id"];
$check = get_colored($get_data_array['category_id'], $data);
echo '<div class="col-xs-9 ';
if ($level !== 1) {
echo 'hidden';
}
echo ' ">';
echo '<input type="checkbox" ';
if ($check['rows'] > 0) {
echo 'checked="checked" ';
}
echo 'class="form-control' . $level . '" data-level="' . $level . '" id="option_level_' . $level . '"value="' . $new_parent . '" style="margin-bottom:10px;" name="tag_id[]">';
echo ' ';
for ($i = 0; $i < $level; $i++) {
echo '-- ';
}
echo $get_data_array["category_name"];
echo '</div>';
listCategoryColor($new_level, $new_parent, $current_category, $data);
}
}
}
function update_sizefit()
{
$conn = connDB();
$product_category = $_POST["product_category"];
$product_size_type_id = $_POST["size_type_id"];
$product_name = $_POST["product_name"];
$type_name = $_POST["type_name"];
//array
$type_sizefit = $_POST["type_sizefit"];
//array
$product_id = $_POST["product_id"];
if ($product_id == '') {
//get the new product id
$get_id = mysql_query("\n\t\t\t\t SELECT * from tbl_product\n\t\t\t\t WHERE product_category = '{$product_category}' AND product_name = '{$product_name}' AND product_size_type_id = '{$product_size_type_id}'\n\t\t\t\t ORDER BY id DESC\n\t\t\t\t ", $conn);
if (mysql_num_rows($get_id) != null) {
$get_id_array = mysql_fetch_array($get_id);
$product_id = $get_id_array["id"];
}
}
//!product types
for ($i = 1; $type_name[$i] != null; $i++) {
echo $sql = "\n\t\t\t\t UPDATE tbl_product_type\n\t\t\t\t SET type_sizefit = '{$type_sizefit[$i]}'\n\t\t\t\t WHERE type_name = '{$type_name[$i]}' AND product_id='{$product_id}'\n\t\t\t\t ";
mysql_query($sql, $conn);
}
}
function get_product_id_how($post_product_alias)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_product WHERE `product_alias` = '{$post_product_alias}'";
$query = mysql_query($sql, $conn) or die(mysql_error());
$result = mysql_fetch_array($query);
return $result;
}
function get_order_gallery()
{
$conn = connDB();
$sql = "SELECT * FROM `tbl_gallery` ORDER BY `order` DESC LIMIT 1";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_filtered($post_product_id, $post_filter_id)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_filter_item WHERE `filter_param` = '{$post_filter_id}' AND `product_param` = '{$post_product_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_how($post_product_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_product_custom WHERE `product_id` = '{$post_product_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function breadcrumbs_get_user_name($post_user_alias)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_user WHERE `user_alias` = '{$post_user_alias}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function delete_inspiration($post_ins_id)
{
$conn = connDB();
$sql = "DELETE FROM tbl_inspiration_image WHERE `inspiration_image_id` = '{$post_ins_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_default($post_category_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_news_category WHERE `category_id` = '{$post_category_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function count_filter($post_filter_name)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_filter_sub WHERE `filter_name` = '{$post_filter_name}' ";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_product_id_how()
{
$conn = connDB();
$sql = "SELECT MAX(id) as product_id FROM tbl_product";
$query = mysql_query($sql, $conn) or die(mysql_error());
$result = mysql_fetch_array($query);
return $result;
}
function getRecipe($post_recipe_name, $post_recipe_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_recipes WHERE `recipe_name` = '{$post_recipe_name}' AND `recipe_id` = '{$post_recipe_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function custom_get_files($post_product_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_product_files WHERE `product_id` = '{$post_product_id}'";
$query = mysql_query($sql, $conn) or die(mysql_error());
$result = mysql_fetch_array($query);
return $result;
}
function insert_wishlist($ajx_user,$date,$ajx_type,$ajx_stock,$ajx_qty){
$conn = connDB();
$sql = "INSERT INTO tbl_wishlist(user_id,wishlist_date,type_id,stock_name,item_quantity)
VALUES ('$ajx_user','$date','$ajx_type','$ajx_stock','$ajx_qty')";
$query = mysql_query($sql, $conn);
}
function get_category_lang($post_id_param, $post_lang_code)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_category_lang WHERE `id_param` = '{$post_id_param}' AND `language_code` = '{$post_lang_code}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_admin_password_validation($password, $admin_id)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_admin WHERE password = '******' AND id = '{$admin_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function count_shipping_rate($country, $province)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_courier_rate WHERE `courier_name` = '{$courier}' AND `active_status` = '{$status}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_stock($stock_id){
$conn = connDB();
$sql = "SELECT * FROM tbl_product_stock WHERE `stock_id`= '$stock_id'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_username($post_username)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_admin WHERE `username` = '{$post_username}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function countCategory()
{
$conn = connDB();
$sql = "SELECT \n cat.category_id, cat.category_name, cat.category_active, cat.category_visibility,\n\t\t\t COUNT(rec.recipe_id) AS total_recipes\n\t\t\t FROM tbl_recipes_category AS cat LEFT JOIN tbl_recipes AS rec ON cat.category_id = rec.category_recipes ORDER BY category_name";
$query = mysql_query($sql, $conn);
$result = mysql_num_rows($query);
return $result;
}
function get_customer_global($get_user_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_user WHERE `user_id` = '{$get_user_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_inspirations($post_category_id)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_inspiration where `category` = '{$post_category_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function count_job($post_category_id)
{
$conn = connDB();
$sql = "SELECT COUNT(*) AS rows FROM tbl_career WHERE `category` = '{$post_category_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_detail($post_career_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_career WHERE `career_id` = '{$post_career_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function get_record_inspirations($search_query, $sort_by, $first_record, $query_per_page, $post_column_name, $post_opt_name, $post_record_name)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_inspiration AS ins LEFT JOIN tbl_inspiration_image AS img ON ins.inspiration_id = img.param_inspiration_id\n LEFT JOIN tbl_inspiration_featured AS feat ON ins.inspiration_id = feat.param_inspiration_id\n WHERE {$search_query} AND {$post_column_name} {$post_opt_name} '{$post_record_name}'\n\t\t\t GROUP BY inspiration_id\n\t\t\t ORDER BY {$sort_by}\n\t\t\t ";
$query = mysql_query($sql, $conn);
$full_order['total_query'] = mysql_num_rows($query);
$full_order['total_page'] = ceil($full_order['total_query'] / $query_per_page);
return $full_order;
}
function get_full_courier($search, $sort_by, $first_record, $query_per_page)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_courier\n WHERE {$search}\n\t\t\t ORDER BY {$sort_by}\n\t\t\t LIMIT {$first_record}, {$query_per_page}\n\t\t\t";
$query = mysql_query($sql, $conn);
$full_order['total_query'] = mysql_num_rows($query);
$full_order['total_page'] = ceil($full_order['total_query'] / $query_per_page);
//
return $full_order;
}
function get_full_recipes($search, $field, $cat, $sort_by, $first_record, $query_per_page)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_recipes\n\t\t WHERE {$search} AND `{$field}` = '{$cat}'\n\t\t ORDER BY {$sort_by}";
$query = mysql_query($sql, $conn);
$full_product['total_query'] = mysql_num_rows($query);
$full_product['total_page'] = ceil($full_product['total_query'] / $query_per_page);
//
return $full_product;
}
function get_languages()
{
$conn = connDB();
$sql = "SELECT * FROM tbl_language";
$query = mysql_query($sql, $conn);
$row = array();
while ($result = mysql_fetch_array($query)) {
array_push($row, $result);
}
return $row;
}
function get_filter()
{
$conn = connDB();
$sql = "SELECT * FROM tbl_filter_sub WHERE `visibility` = '1' ORDER BY filter_name";
$query = mysql_query($sql, $conn);
$row = array();
while ($result = mysql_fetch_array($query)) {
array_push($row, $result);
}
return $row;
}
