<?php
/**
 * 小麥雜貨舖 V18.03
 *
 * Copyright (C) 2018, Cloud Lin
 */
header("content-type:text/html;charset=utf-8");
require_once('set.php');
require_once('include_share_block.php');

$obj_prod   = new mysql_page();
$obj_upload = new mysql_page();
$pa         = ($pa)?$pa:"getList";

//********************************
//	課程介紹
//********************************
if($pa=="getList") {
  $array_prod_list = array();
  $query = "select id, name from ".$table_name_prod." where category=1 and pub=1 order by sort desc, id asc";
  $obj_prod->run_mysql_list($query);
  foreach($obj_prod->result_data as $i => $prod) {
    //upload
    $query = "select file_name from ".$table_name_upload." ".
             "where main_str='".$main_str_prod."' and data_id='".$prod["id"]."' order by sort desc, id asc limit 0, 1";
    $upload = $obj_upload->run_mysql_out($query);
    $array_prod_list[$i]["id"]        = $prod["id"];
    $array_prod_list[$i]["name"]      = $prod["name"];
    $array_prod_list[$i]["file1"]     = "upload_files/products/".$upload["file_name"];
  }
  $av["prod_list"] = $array_prod_list;
  //********************************
  //	META區塊
  //********************************
  $av["Html_Title"]      = $av["Html_Title"];
  $av["Host_Img"]        = Host_Name."includes/images/light_logo.png";
  //$host_img_size         = getimagesize($av["Host_Img"]);
  $av["Host_Img_Width"]  = $host_img_size[0];
  $av["Host_Img_Height"] = $host_img_size[1];
  $av["Host_Url"]        = Host_Name."class.php?pa=getList";
  $TPL                   = "class.html";
}elseif($pa=="getItem") {
  $error_url_to = "class.php?pa=getList";
  if(!$prod_id) {
    js_a_l("", $error_url_to);
  }else {
    $query = "select id, name, material, content, pub from ".$table_name_prod." where id='".$prod_id."'";
    $prod  = $obj_prod->run_mysql_out($query);
    if($prod["pub"]!=1) {
      js_a_l("此課程已下架，請重新選擇", $error_url_to);
    }else {
      $prod["url_to"]  = $prod["material"];
      $prod["content"] = html_entity_decode($prod["content"], ENT_QUOTES);
      $av["prod"]      = $prod;
      //圖片列表
      $array_upload_list = array();
      $query = "select file_name from ".$table_name_upload." ".
               "where main_str='".$main_str_prod."' and data_id='".$prod["id"]."' order by sort desc, id asc";
      $obj_upload->run_mysql_list($query);
      foreach($obj_upload->result_data as $i => $upload) {
        $array_upload_list[$i]["file_name"] = "upload_files/products/".$upload["file_name"];
      }
      $av["upload_list"] = $array_upload_list;
      //********************************
      //	META區塊
      //********************************
      $av["Html_Title"]      = $prod["name"]."|".$av["Html_Title"];
      $av["Host_Img"]        = Host_Name."includes/images/light_logo.png";
      //$host_img_size         = getimagesize($av["Host_Img"]);
      $av["Host_Img_Width"]  = $host_img_size[0];
      $av["Host_Img_Height"] = $host_img_size[1];
      $av["Host_Url"]        = Host_Name."class.php?pa=getItem&prod_id=".$prod["id"];
      $TPL                   = "class_cen.html";
    }
  }
}

$obj_prod->run_mysql_close();
$obj_upload->run_mysql_close();
smarty_display($TPL, $av);
?>