$photornd=$photornd+1;
}
}
}
$tp_index-> newBlock ("tp_photo_table");
$tp_index-> assign ( "tp_photo_table" , $form->tablegrid($photoshow, 3, "97%", 30, "ffffff", "center $tr_mouse", " align=center cellpadding=3'", "top style='border: 496eb5 1px dotted;'") ); // 訂單日期
$tp_index-> newBlock ( "tp_p4_02" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=7771&cateid=".$_GET['cateid']."&cateid_k=".$_GET['cateid_k'],count($filelist),'','',$msnum,0,'',9) );
}
function u_p2_4_old() {
global $tp_index;
global $link;
$query_product = "select * from info
where infocate=15";
//echo $query_product;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
$photolist="";
$tp_index-> newBlock ( "tp_2_4" ); // 瀏覽 block
$tp_index-> assign ( "title" , ($row_product["title"]) ); // s_num
$tp_index-> assign ( "up_date" , ($row_product["up_date"]) ); // s_num
unset($filelist);
$photo_dir = "data/infofile/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$tp_index-> assign ( "file" , $photo_dir."/".$filelist[0] ); // s_num
}
$mnum++;
return;
}
function u_p3_1_2() {
global $tp_index;
global $link;
$linknew=db_connectnew();
if ($_SESSION["muser_id"]==''){
?>
newBlock ( "tp_4_7_1_bigcate" ); // 瀏覽 bloc
$tp_index-> assign ( "bigcate" , $confirmbig[$_GET['cateid']] ); // s_num
// $result_product = mysql_query($query_product);
$mnum = 0;
while (list($fcateno,$snno,$styleno2,$applydate,$actnamebig,$title,$infocate,$confirm_id)=db_fetch_row($querycopy)){
$photolist="";
$tp_index-> newBlock ( "tp_4_7_1" ); // 瀏覽 block
$tp_index-> assign ( "ckind" , $confirmbig[($actnamebig)] ); // s_num
$tp_index-> assign ( "ekind" , $cateinfo[($fcateno)] ); // s_num
$tp_index-> assign ( "snno" , ($snno) ); // s_n
$tp_index-> assign ( "applydate" , $applydate ); // s_n
$tp_index-> assign ( "styleno2" , $styleno2 ); // s_n
$query_productn = "select title from info_k_i where infoid='".$row_product["progress2"]."'";
$result_productn = mysql_query($query_productn);
$row_productn = mysql_fetch_array($result_productn);
//if (($row_product["actnamebig"])==4){
$tp_index-> assign ( "imagelink" , " " );
$tp_index-> assign ( "progress" , $title ); // s_n
$tp_index-> assign ( "confirm_id" , $confirm_id ); // s_n
//}
$tp_index-> assign ( "progressbig" ,$infocate ); // s_n
// $tp_index-> assign ( "link" , "indexmain.php?mmenu=3-1-1-1&fcateno=".$row_product["fcateno"]."&cateid=".$row_product["fcateno"] ); // s_num
}
$mnum++;
return;
}
function u_p3_1_1a() {
global $tp_index;
global $link;
if ($_SESSION["muser_id"]==''){
?>
1";
$confirmbig=infocate_list_confirmbig();
$tp_index-> newBlock ( "tp_4_7_1_bigcate" ); // 瀏覽 bloc
$tp_index-> assign ( "bigcate" , $confirmbig[$_GET['cateid']] ); // s_num
//echo $query_product;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
$photolist="";
$tp_index-> newBlock ( "tp_4_7_1" ); // 瀏覽 block
$tp_index-> assign ( "catename" , ($row_product["catename"]) ); // s_num
$tp_index-> assign ( "up_date" , ($row_product["up_date"]) ); // s_n
$tp_index-> assign ( "link" , "newblue/newline.php?mmenu=3-1-1-1&fcateno=".$row_product["fcateno"]."&cateid=".$row_product["fcateno"] ); // s_num
}
$mnum++;
return;
}
function u_p3_1_1() {
global $tp_index;
global $link;
if ($_SESSION["muser_id"]==''){
?>
1";
$confirmbig=infocate_list_confirmbig();
$tp_index-> newBlock ( "tp_4_7_1_bigcate" ); // 瀏覽 bloc
$tp_index-> assign ( "bigcate" , $confirmbig[$_GET['cateid']] ); // s_num
//echo $query_product;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
$photolist="";
$tp_index-> newBlock ( "tp_4_7_1" ); // 瀏覽 block
$tp_index-> assign ( "catename" , ($row_product["catename"]) ); // s_num
$tp_index-> assign ( "up_date" , ($row_product["up_date"]) ); // s_n
$tp_index-> assign ( "link" , "newblue/newline.php?gfcateno=".$row_product["fcateno"]."&cateid=".$row_product["fcateno"]."&rndcode=".rand(1,800000) ); // s_num
}
$mnum++;
return;
}
function randstr() {
mt_srand((double)microtime()*10000);
for($i=0;$i<5;$i++) {
$x = mt_rand(1,9);
$newpic_name .= ($x%2==0) ? chr(mt_rand(48,57)) : chr(mt_rand(97,122));
}
return $newpic_name;
}
function getSNno($autono){
//echo $autono;
global $link;
//有 bug
//$authnolen=strlen($autono);
// $actauthono=($autono."B".date("Y"));
// $innsalz="select count(*) as pcount from confirm_info where left(styleno1,".($authnolen+5).") like '".$actauthono."'";
// $querylz = db_query($innsalz,$link);
//list($pcount) = db_fetch_row($querylz);
$authnolen=strlen($autono);
// $actauthono=($autono."B".date("Y"));
$actauthono=($autono.(date("Y")-1911));
$innsalz="select max(right(styleno1,4)) as pcount from confirm_info where left(styleno1,".($authnolen+3).") like '".$actauthono."' and stype<>3";
// echo "select max(right(styleno1,4)) as pcount from confirm_info where left(styleno1,".($authnolen+3).") like '".$actauthono."'";
//exit;
$querylz = db_query($innsalz,$link);
list($pcount) = db_fetch_row($querylz);
// return ($autono."B".date("Y").sprintf("%04d",$pcount+1));
return ($autono.(date("Y")-1911).sprintf("%04d",$pcount+1));
}
function getSNno3($autono){
// 全找
global $link;
$innsalz="select styleno1 from confirm_info where snno like '".$autono."'";
$querylz = db_query($innsalz,$link);
list($styleno1) = db_fetch_row($querylz);
$authnolen=strlen($styleno1);
// $innsalz="select max(right(styleno1,1)) as pcount from confirm_info where left(styleno1,".($authnolen+1).") like '".$styleno1."-'";
$innsalz="select count(right(styleno1,IF(length(styleno1)=".($authnolen+3).",2,1))) as pcount from confirm_info where left(styleno1,".($authnolen+1).") like '".$styleno1."-'";
//echo $innsalz;
//exit;
$querylz = db_query($innsalz,$link);
list($pcount) = db_fetch_row($querylz);
//修正
// return ($styleno1."-".sprintf("%02d",$pcount+1));
return ($styleno1."-".($pcount+1));
}
function u_p3_1_1_1_sa() {
global $tp_index;
global $link;
$pdate1array=$_POST['pdate1'];
$pdate2array=$_POST['pdate2'];
$pamount1array=$_POST['pamount1'];
$pamount2array=$_POST['pamount2'];
$paddarray=$_POST['padd'];
if ($_POST['sftype']==2){ // 現有庫存就是申請庫存, 在 MODE=2 時 paomunt2 就是現有庫存, amount1 就是申請庫存量
$pamount2array=$_POST['pamount1'];
}
$pcompanyarray=$_POST['pcompany'];
$psidarray=$_POST['apsid'];
$snno=$_POST['snno'];
$pauthnoarray=$_POST['pauthno'];
$innsalz="select fcateno, venderno, actnameyear, actnamebig ,progress,authno,styleno2 from confirm_info where snno='".$snno."'" ;
$querylz = db_query($innsalz,$link);
list( $fcateno, $venderno, $actnameyear, $actnamebig ,$progress,$authno,$styleno2) = db_fetch_row($querylz);
$innsalz="select member_username from member where member_userid='".$venderno."'" ;
$querylz = db_query($innsalz,$link);
list( $vendername)=db_fetch_row($querylz);
$actnameyear=date("Y");
for ($i=0;($i
'' and actnamebig=1 and (fcateno=26 or fcateno=27) ) order by styleno1";
$result_product = mysql_query($query_data);
while ($row_product = mysql_fetch_array($result_product)){
if ($row_product["fcateno"]=='26') $prename="(HR)";
if ($row_product["fcateno"]=='27') $prename="(FR)";
$tp_index-> newBlock ( "tp_stylenolist" ); // 瀏覽 block
$tp_index-> assign ( "tp_stylenolist.snno" , $row_product["snno"] ); // 產品解說
$tp_index-> assign ( "tp_stylenolist.authno" , $prename." ".$row_product["authno"] ); // 產品解說
}
$tp_index-> newBlock ( "tp_stylenolisttoday" ); // 瀏覽 block
$tp_index-> assign ( "today" , date("Y-m-d") ); // 產品解說
}
function u_p3_1_1_1() {
global $form;
if ($_SESSION["muser_id"]==''){
?>
'' and actnamebig=1 ) order by styleno1";
$query_data="select actnamebig,fcateno,authno,snno from confirm_info where ( (fcateno=".$_REQUEST["fcateno"].") and venderno='".$_SESSION["muser_id"]."' and authno<>'' and actnamebig=1 ) order by styleno1";
$result_product = mysql_query($query_data);
while ($row_product = mysql_fetch_array($result_product)){
$tp_index-> newBlock ( "tp_stylenolist" ); // 瀏覽 block
$tp_index-> assign ( "tp_stylenolist.snno" , $row_product["snno"] ); // 產品解說
$tp_index-> assign ( "tp_stylenolist.authno" , $row_product["authno"] ); // 產品解說
}
//echo $row_product["fcateno"];
// $query_data1="select member_username from member where member_userid='".$_SESSION["muser_id"]."' ";
//echo $query_data1;
// $result_product1 = mysql_query($query_data1);
// $row_product1 = mysql_fetch_array($result_product1);
$tp_index-> newBlock ( "tp_infolist" ); // 瀏覽 block
$tp_index-> assign ( "tp_infolist.venderno" , $infocate_list_vender[$_SESSION["muser_id"]] ); // 產品解說
$tp_index-> assign ( "tp_infolist.catename" , $cateinfo[$_REQUEST["fcateno"]] ); // 產品解說
$tp_index-> assign ( "tp_infolist.totalquota1" , $totalquota1 ); // 產品解說
//$_SESSION["totalquota1"]=(is_numeric($_SESSION["totalquota1"]) ? $totalquota1 : 0 );
$_SESSION["totalquota1"]= $totalquota1;
if ($_REQUEST["fcateno"]=="26"){
$_SESSION["xtype"]=1;
}
if ($_REQUEST["fcateno"]=="27"){
$_SESSION["xtype"]=2;
}
$tp_index-> newBlock ( "tp_infolistx" ); // 瀏覽 block
$tp_index-> assign ( "xtype" , $_SESSION["xtype"] ); // 產品解說
$tp_index-> assign ( "totalquota1" , $_SESSION["totalquota1"] ); // 產品解說
$query_data="select ad1,ad2,ad3 from member where member_userid='".$_SESSION["muser_id"]."' ";
$result_product = mysql_query($query_data);
$row_product = mysql_fetch_array($result_product);
if ($row_product['ad1']<>'') $addressarray[$row_product['ad1']]=$row_product['ad1'];
if ($row_product['ad2']<>'') $addressarray[$row_product['ad2']]=$row_product['ad2'];
if ($row_product['ad3']<>'') $addressarray[$row_product['ad3']]=$row_product['ad3'];
$tp_index-> newBlock ( "tp_addresslist0" ); // 瀏覽 block
$tp_index-> assign ( "address" , $form->select("padd[]","",$addressarray," id='padd[]'") ); // 產品解說
$tp_index-> newBlock ( "tp_addresslist1" ); // 瀏覽 block
$tp_index-> assign ( "address" , $form->select("padd[]","",$addressarray," id='padd[]'") ); // 產品解說
$tp_index-> newBlock ( "tp_addresslist2" ); // 瀏覽 block
$tp_index-> assign ( "address" , $form->select("padd[]","",$addressarray," id='padd[]'") ); // 產品解說
return;
}
function u_p3_1_1_1BAK() {
if ($_SESSION["muser_id"]==''){
?>
newBlock ( "tp_p3_1_9" ); // 瀏覽 block
// $tp_index-> assign ( "companyname" , ($row_data["member_username"]) ); // s_num
// $tp_index-> assign ( "cno" , ($row_data["member_userid"]) ); // s_num
// $tp_index-> assign ( "phone" , ($row_data["phone"]) ); // s_num
// $tp_index-> assign ( "address" , ($row_data["address"]) ); // s_num
// $tp_index-> assign ( "email" , ($row_data["email"]) ); // s_num
// $tp_index-> assign ( "man" , ($row_data["personal"]) ); // s_num
// $xml= str_replace( '{companyname}' , ($row_data["phone"]) , $xml);
$xml= str_replace( '{snno}' , $rndstr , $xml);
$xml= str_replace( '{company}' , ($row_data["member_username"]) , $xml);
$xml= str_replace( '{phone}' , ($row_data["phone"]) , $xml);
$xml= str_replace( '{address}' , ($row_data["address"]) , $xml);
$xml= str_replace( '{fax}' , ($row_data["fax"]) , $xml);
$xml= str_replace( '{email}' , ($row_data["email"]) , $xml);
$xml= str_replace( '{man}' , ($row_data["personal"]) , $xml);
}
////////////////////////////////
$filena= $rndstr .".doc";
$filernd="tempdoc/".$filena;
$file1 = fopen($filernd,"w");
fwrite($file1, $xml);
$tp_index-> newBlock ( "tp_4_7_1" ); // 瀏覽 block
$tp_index-> assign ( "docfile" , $filernd ); // s_num
$tp_index-> assign ( "sn" , $rndstr ); // s_num
$query_data="insert into confirm_info(snno,venderno,fcateno,actnamebig,actnameyear,online,applydate,sip) values('".$rndstr."','".$_SESSION["muser_id"]."','".$_GET['fcateno']."','".$_GET['tempid']."',2009,2,'".date("Y-m-d")."','".$_SERVER["REMOTE_ADDR"]."')" ;
// echo $query_data;
$result_data = mysql_query($query_data);
// $mmax_qty = mysql_num_rows($result_data);
// $row_data = mysql_fetch_array($result_data);
return;
}
function u_p2_3() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
$query_product = "select * from info_i
where infocate=1 and infoid=2662";
$result_product = mysql_query($query_product);
$row_product = mysql_fetch_array($result_product);
$companytitle=$row_product["title"];
$companycateid=$row_product["infoid"];
$query_product = "select * from info_k_i
where infocate=".$companycateid;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
//$tp_index-> newBlock ("tp_p2_list_01");
unset($filelist);
$photolist="";
$tp_index-> newBlock ( "tp_p2_list_01_001" ); // 瀏覽 block
//$tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" , str_replace("\r\n","
",$row_product["content"]) ); // 產品解說
// $tp_index-> assign ( "tp_p2_list_01_001.tp_pd04" , str_replace("\r\n","
",$row_product["title"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" , $row_product["content"] ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd04" , $row_product["title"] ); // 產品解說
/////////////////////////////////////////////////////////////////////////// 取出圖片列表
$photo_dir = "data/info_i/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$photolist = "";
if($filelist) {
foreach($filelist as $key=>$val) {
$link = $photo_dir . "/" . $val;
$photolist .= "
";
}
}
///////////////////////////////////////////////////////////////////////////
$tp_index-> assign ( "tp_p2_list_01_001.photolist" , $photolist ); // 產品圖檔(小)
}
return;
}
function u_p2_5() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
$query_product = "select * from info_i
where infocate=8 and infoid=2665";
$result_product = mysql_query($query_product);
$row_product = mysql_fetch_array($result_product);
$companytitle=$row_product["title"];
$companycateid=$row_product["infoid"];
$query_product = "select * from info_k_i
where infocate=".$companycateid;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
//$tp_index-> newBlock ("tp_p2_list_01");
unset($filelist);
$photolist="";
$tp_index-> newBlock ( "tp_p2_list_01_001" ); // 瀏覽 block
// $tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" , str_replace("\r\n","
",$row_product["content"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" ,$row_product["content"] ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd04" , str_replace("\r\n","
",$row_product["title"]) ); // 產品解說
/////////////////////////////////////////////////////////////////////////// 取出圖片列表
$photo_dir = "data/info_i/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$photolist = "";
$stdwidth=400;
$stdheight=400;
if($filelist) {
foreach($filelist as $key=>$val) {
$link = $photo_dir . "/" . $val;
list($width, $height, $value, $params) = GetImageSize($link);
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
$photolist .= "
";
}
}
///////////////////////////////////////////////////////////////////////////
$tp_index-> assign ( "tp_p2_list_01_001.photolist" , $photolist ); // 產品圖檔(小)
}
return;
}
function u_istem() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
$query_product = "select * from info_i
where infocate=330";
$result_product = mysql_query($query_product);
while ($row_product = mysql_fetch_array($result_product)){;
$companytitle=$row_product["title"];
$companycateid=$row_product["infoid"];
$tp_index-> newBlock ("tp_p2_list_01x");
$tp_index-> assign ( "tp_p2_list_01x.tp_pd04" , str_replace("\r\n","
",$row_product["title"]) ); // 產品解說
$query_product1 = "select * from info_k_i
where infocate=".$companycateid;
$result_product1 = mysql_query($query_product1);
$mnum = 0;
while ($row_product1 = mysql_fetch_array($result_product1)) {
$tp_index-> newBlock ( "tp_p2_list_01_001x" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_list_01_001x.tp_pd09" , str_replace("\r\n","
",$row_product1["content"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001x.tp_pd04" , str_replace("\r\n","
",$row_product1["title"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001x.tp_address" , str_replace("\r\n","
",$row_product1["address"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001x.tp_phone" , str_replace("\r\n","
",$row_product1["phone"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001x.tp_fax" , str_replace("\r\n","
",$row_product1["fax"]) ); // 產品解說
}
}
return;
}
function u_p9_1() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
$query_product = "select * from info_i
where infocate=332";
$result_product = mysql_query($query_product);
while ($row_product = mysql_fetch_array($result_product)){;
$companytitle=$row_product["title"];
$companycateid=$row_product["infoid"];
$tp_index-> newBlock ("tp_p2_list_01");
$tp_index-> assign ( "tp_p2_list_01.tp_pd04" , str_replace("\r\n","
",$row_product["title"]) ); // 產品解說
$query_product1 = "select * from info_k_i
where infocate=".$companycateid;
$result_product1 = mysql_query($query_product1);
$mnum = 0;
while ($row_product1 = mysql_fetch_array($result_product1)) {
$tp_index-> newBlock ( "tp_p2_list_01_001" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" , str_replace("\r\n","
",$row_product1["content"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd04" , str_replace("\r\n","
",$row_product1["title"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_address" , str_replace("\r\n","
",$row_product1["address"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_phone" , str_replace("\r\n","
",$row_product1["phone"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_fax" , str_replace("\r\n","
",$row_product1["fax"]) ); // 產品解說
}
}
return;
}
function u_p2_2() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
$query_product = "select * from info_i
where infocate=1 and infoid=2666";
$result_product = mysql_query($query_product);
$row_product = mysql_fetch_array($result_product);
$companytitle=$row_product["title"];
$companycateid=$row_product["infoid"];
$query_product = "select * from info_k_i
where infocate=".$companycateid;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
//$tp_index-> newBlock ("tp_p2_list_01");
unset($filelist);
$photolist="";
$tp_index-> newBlock ( "tp_p2_list_01_001" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd09" , str_replace("\r\n","
",$row_product["content"]) ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01_001.tp_pd04" , str_replace("\r\n","
",$row_product["title"]) ); // 產品解說
/////////////////////////////////////////////////////////////////////////// 取出圖片列表
$photo_dir = "data/info_i/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$photolist = "";
if($filelist) {
foreach($filelist as $key=>$val) {
$link = $photo_dir . "/" . $val;
$photolist .= "
";
}
}
///////////////////////////////////////////////////////////////////////////
$tp_index-> assign ( "tp_p2_list_01_001.photolist" , $photolist ); // 產品圖檔(小)
}
return;
}
function u_p4_1(){
global $tp_index;
global $link;
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$query_u_p4_1 = "select * from info where infocate=20 order by infoid desc";
$result_u_p4_1 = mysql_query($query_u_p4_1);
$mmax_qty = mysql_num_rows($result_u_p4_1);
$query_u_p4_1 = "select * from info where infocate=20 order by infoid desc limit $msnum,10";
$result_u_p4_1 = mysql_query($query_u_p4_1);
while ($row_u_p4_1 = mysql_fetch_array($result_u_p4_1))
{
$tp_index-> newBlock ( "tp_4_1" ); // 瀏覽 block
$tp_index-> assign ( "title" , mb_substr(($row_u_p4_1["title"]),0,30,"UTF-8") ); // 內容
$tp_index-> assign ( "up_date" , substr($row_u_p4_1["up_date"],0,10) ); // 內容
$tp_index-> assign ( "link" , "indexmain.php?mmenu=4-1-1&sum=".$row_u_p4_1["infoid"] ); // 內容
$tp_index-> assign ( "id" , $row_u_p4_1["infoid"] ); // 內容
$tp_index-> assign ( "content" ,($row_u_p4_1["content"]) ); // 內容
if (!($row_u_p4_1["ititlelink"]==''))
$tp_index-> assign ( "link" , $row_u_p4_1["ititlelink"] ); // 內容
}
$tp_index-> newBlock ( "tp_4_1_page" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=4-1&sname=".$_GET['sname']."&infono=".$_GET['infono']."&search_info=".$search_info2,$mmax_qty,'','',$msnum,0,'',10) );
}
function u_p4_1_com(){
global $tp_index;
global $link;
global $form;
$linknew=db_connectnew();
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
//////////////////////////////公司訊息
$copystr="select sum(money) from coin where venderno='".$_SESSION["muser_id"]."'" ;
$querycopy=db_query($copystr,$linknew);
list($totalmoney)=db_fetch_row($querycopy);
//$query = db_query("select sum(money) as totalmoney from usermesg where snno='".$_SESSION["muser_id"]."' and type=0", $link);
//list($totalmoney) = db_fetch_row($query);
/// $query_productmb = "select sum(money) as totalmoney from usermesg where snno='".$_SESSION["muser_id"]."' and type=0";
// $result_productmb = mysql_query($query_productmb);
// list($totalmoney) = mysql_fetch_row($result_productmb);
$query_productm = "select count(*) from coin
where venderno='".$_SESSION["muser_id"]."' and money>0 order by coin_date desc" ;
$querycopy=db_query($query_productm,$linknew);
list($mnum)=db_fetch_row($querycopy);
//$query_product = "select * from usermesg
// where snno='".$_SESSION["muser_id"]."' and isread=0 order by mesgid desc";
$tp_index-> newBlock ( "tp_4_1_com_num" ); // 瀏覽 block
$tp_index-> assign ( "mnum" , $mnum ); // s_num
$tp_index-> assign ("totalmoney",(is_numeric($totalmoney) ? $totalmoney : 0) );
$query_product = "select venderno, money,coin_date ,meg from coin
where venderno='".$_SESSION["muser_id"]."' and type=1 order by coin_date desc" ;
$querycopy=db_query($query_product,$linknew);
$mailicon=array("1"=>"mail02.gif","0"=>"mail01.gif");
while (list($venderno, $money,$coin_date ,$meg)=db_fetch_row($querycopy)){
$tp_index-> newBlock ( "tp_4_1_msg" ); // 瀏覽 block
$tp_index-> assign ( "title" , $meg ); // s_num
$tp_index-> assign ( "money" , $money ); // s_num
$tp_index-> assign ( "cdate" , $coin_date ); // s_num
// $tp_index-> assign ( "mesgid" , $row_product['mesgid'] ); // s_num
// $tp_index-> assign ( "mailicon" , $mailicon[$row_product['isread']] ); // s_num
if ($row_product['isread']==0) $tp_index-> assign ( "readstatus" , "未讀閱" ); // s_num
if ($row_product['isread']==1) $tp_index-> assign ( "readstatus" , "已讀閱" ); // s_num
$query_product33 = "select * from usermesg
where remesgid='".$row_product['mesgid']."' and type=1 order by mesgid desc";
$result_product33 = mysql_query($query_product33);
while ($row_product33 = mysql_fetch_array($result_product33)) {
$tp_index-> newBlock ( "tp_4_1_msg" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_product33['title'] ); // s_num
$tp_index-> assign ( "cdate" , $row_product33['cdate'] ); // s_num
$tp_index-> assign ( "mesgid" , $row_product33['mesgid'] ); // s_num
$tp_index-> assign ( "mailicon" , $mailicon[$row_product33['isread']] ); // s_num
if ($row_product33['isread']==0) $tp_index-> assign ( "readstatus" , "未讀閱" ); // s_num
if ($row_product33['isread']==1) $tp_index-> assign ( "readstatus" , "已讀閱" ); // s_num
}
}
$tp_index-> newBlock ( "tp_msgapplylink" ); // 瀏覽 block
if ($totalmoney<=0){
$tp_index-> assign ( "msgapplylink" , "'javascript:showmoneymsg();'");
}else{
$tp_index-> assign ( "msgapplylink" , "indexmain.php?mmenu=3-1-1");
}
$tp_index-> newBlock ( "tp_4_1_page_com" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=3-1",$mmax_qty,'','',$msnum,0,'',7) );
//$tp_index-> assign ( "spage" , $form->html_page("indexmain.php",$mmax_qty41,'','',$offset,0,"&mmenu=4-7-1-1&fcateno=".$_REQUEST['fcateno']."&cateid=".$_GET['cateid']."&y=".$_GET['y']."&search_info=".$search_info2.$corders.$akys,$limit) );
}
function u_p1_1_1(){
global $tp_index;
global $link;
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$query_u_p4_1_1 = "select * from info where infoid=".$_GET['sum'];
$result_u_p4_1_1 = mysql_query($query_u_p4_1_1);
while ($row_u_p4_1_1 = mysql_fetch_array($result_u_p4_1_1))
{
$tp_index-> newBlock ( "tp_1_1_1" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_u_p4_1_1["title"] ); // 內容
$tp_index-> assign ( "up_date" , $row_u_p4_1_1["up_date"] ); // 內容
$tp_index-> assign ( "content" , $row_u_p4_1_1["content"] ); // 內容
/////////////////////////////////////////////////////////////////////////// 取出圖片列表
$photo_dir = "data/infohot/" . $row_u_p4_1_1["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$photolist = "";
if($filelist) {
foreach($filelist as $key=>$val) {
$linkv = $photo_dir . "/" . $val;
$photolist .= "
";
}
}
///////////////////////////////////////////////////////////////////////////
$tp_index-> assign ( "photolist" , $photolist ); // 產品圖檔(小)
unset($filelist);
$photo_dir = "data/engineerupfile/" . $row_u_p4_1_1["infoid"] ;
// echo $photo_dir ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$stdwidth=176;
$stdheight=129;
if($filelist) {
foreach($filelist as $key=>$val) {
$link1 = $photo_dir . "/" . $val;
$tp_index-> newBlock ("tp_p2_list_01");
$tp_index-> assign ("tp_p2_list_01.imgpath" , $link1 ); // s_num
$queryimgtext=db_query("select infoimgtextid,imgname,imgnote from infoimgtext where imgname='".$val."' and infoid=".$row_u_p4_1_1["infoid"] , $link);
list($infoimgtextid,$imgname ,$imgnote) = db_fetch_row($queryimgtext);
$tp_index-> assign ("tp_p2_list_01.imgpath1" , end(explode("/",$link1)) ); // s_num
// list($width, $height, $value, $params) = GetImageSize($link1);
// list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
// list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
$tp_index-> assign ("tp_p2_list_01.height" , $height ); // s_num
$tp_index-> assign ("tp_p2_list_01.width" , $width ); // s_num
}
}
}
}
function u_p4_1_1(){
global $tp_index;
global $link;
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$query_u_p4_1_1 = "select * from info where infoid=".$_GET['sum'];
$result_u_p4_1_1 = mysql_query($query_u_p4_1_1);
while ($row_u_p4_1_1 = mysql_fetch_array($result_u_p4_1_1))
{
$tp_index-> newBlock ( "tp_4_1_1" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_u_p4_1_1["title"] ); // 內容
$tp_index-> assign ( "up_date" , $row_u_p4_1_1["up_date"] ); // 內容
$tp_index-> assign ( "content" , $row_u_p4_1_1["content"] ); // 內容
/////////////////////////////////////////////////////////////////////////// 取出圖片列表
$photo_dir = "data/infohot/" . $row_u_p4_1_1["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$photolist = "";
if($filelist) {
foreach($filelist as $key=>$val) {
$linkv = $photo_dir . "/" . $val;
$photolist .= "
";
}
}
///////////////////////////////////////////////////////////////////////////
$tp_index-> assign ( "photolist" , $photolist ); // 產品圖檔(小)
unset($filelist);
$photo_dir = "data/engineerupfile/" . $row_u_p4_1_1["infoid"] ;
// echo $photo_dir ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$stdwidth=171;
$stdheight=129;
if($filelist) {
foreach($filelist as $key=>$val) {
$link1 = $photo_dir . "/" . $val;
$tp_index-> newBlock ("tp_p2_list_01");
$tp_index-> assign ("tp_p2_list_01.imgpath" , $link1 ); // s_num
$queryimgtext=db_query("select infoimgtextid,imgname,imgnote from infoimgtext where imgname='".$val."' and infoid=".$row_u_p4_1_1["infoid"] , $link);
list($infoimgtextid,$imgname ,$imgnote) = db_fetch_row($queryimgtext);
$tp_index-> assign ("tp_p2_list_01.imgtext" , $imgnote ); // s_num
// list($width, $height, $value, $params) = GetImageSize($link1);
// list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
// list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
$tp_index-> assign ("tp_p2_list_01.height" , $height ); // s_num
$tp_index-> assign ("tp_p2_list_01.width" , $width ); // s_num
}
}
}
}
function u_p4_8(){
global $tp_index;
global $link;
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$query_u_p4_8 = "select * from infocateb_qa where cateid<>24 order by cateid";
$result_u_p4_8 = mysql_query($query_u_p4_8);
$mmax_qty = mysql_num_rows($result_u_p4_8);
while ($row_u_p4_8 = mysql_fetch_array($result_u_p4_8))
{
$tp_index-> newBlock ( "tp_4_8_kind" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_u_p4_8["catename"] ); // 內容
$tp_index-> assign ( "id" , $row_u_p4_8["cateid"] ); // 內容
if ($_GET['kind']==$row_u_p4_8["cateid"])
$tp_index-> assign ( "idselect" , "selected" ); // 內容
}
if (!($_REQUEST['kind']=='')){
$kind=$_REQUEST['kind'];}
else{
$kind=1;}
$num=1;
$query_u_p4_q = "select * from infoqa where infocate=$kind order by infoid";
//echo $query_u_p4_q;
$result_u_p4_q = mysql_query($query_u_p4_q);
$mmax_qty = mysql_num_rows($result_u_p4_q);
while ($row_u_p4_q = mysql_fetch_array($result_u_p4_q))
{
$style="";
if ($num%2==0)
$style="bgcolor=#669966";
$tp_index-> newBlock ( "tp_4_8_q" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_u_p4_q["title"] ); // 內容
$tp_index-> assign ( "id" , $row_u_p4_q["id"] ); // 內容
$tp_index-> assign ( "style" , $style ); // 內容
$tp_index-> assign ( "no" , $num ); // 內容
$tp_index-> newBlock ( "tp_4_8_a" ); // 瀏覽 block
$tp_index-> assign ( "title" , $row_u_p4_q["title"] ); // 內容
$tp_index-> assign ( "id" , $row_u_p4_q["id"] ); // 內容
$tp_index-> assign ( "content" , $row_u_p4_q["content"] ); // 內容
$tp_index-> assign ( "style" , $style ); // 內容
$tp_index-> assign ( "no" , $num ); // 內容
$num++;
}
}
function u_p12_1() {
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
global $f_que;
global $f_page;
global $mpd01;
// 沒有傳值，抓第一筆
if(empty($mpd01)) {
$query_product_kind_chk = "select * from products_cate
order by cid
";
$result_product_kind_chk = mysql_query($query_product_kind_chk);
$row_product_kind_chk = mysql_fetch_array($result_product_kind_chk);
$mpd01 = $row_product_kind_chk["cid"];
}
$query_product_kind = "select * from products_cate
order by cid
";
$result_product_kind = mysql_query($query_product_kind);
while($row_product_kind = mysql_fetch_array($result_product_kind)) {
$tp_index-> newBlock ( "tp_p2_kind2" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_kind.tp_pk02" , $row_product_kind["pk02"] ); //
$tp_index-> assign ( "tp_p2_kind.tp_link" , u_showproc().".php?mmenu=2&mpd01=".$row_product_kind["pk01"]."&disb=".$row_product_kind["pk11"] ); //
}
$query_product_kind = "select * from products_cate
where cid='$mpd01'";
$result_product_kind = mysql_query($query_product_kind);
$row_product_kind = mysql_fetch_array($result_product_kind);
$mmaxline = 10;
if ((!($_GET['f_que']=='')) and (!($_GET['linkact']=='1'))) {
$f_que=base64_decode($_GET['f_que']);
}
//echo $f_que;
list($msnum,$mmax_qty)=u_pd_pg_product2(); // 計算頁次
list($msnum,$mmax_qty)=u_pd_pg_product(); // 計算頁次
//echo $msnum.'----';
if(empty($mpd01)) {
$mwhere = " where available='Y' ";
}
else {
if(empty($f_que)) {
$mwhere = " where class_id='$mpd01' and available='Y' ";
}
else {
$mwhere = " where (provider_id like '%$f_que%' or proname like '%$f_que%' or
prodesc like '%$f_que%' or procode like '%$f_que%' or
unit like '%$f_que%' or sellingprice like '%$f_que%' or
prophotos like '%$f_que%' or mat like '%$f_que%' or color like '%$f_que%' ) and available='Y'
";
}
}
if (!($f_que)){
$tp_index-> newBlock ( "tp_p2_thiskind" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_thiskind.thiskind" , $row_product_kind["class_name"] ); // 產品代號
}else{
$tp_index-> newBlock ( "tp_p2_thiskind" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_thiskind.thiskind" , "搜尋: ".$f_que." 結果" ); // 產品代號
}
$query_product = "select * from products
$mwhere
order by procode
limit $msnum,$mmaxline
";
//echo $query_product."
";
$result_product = mysql_query($query_product);
$totalrecnum = mysql_num_rows($result_product); // 目前總筆數
if ($totalrecnum==0){
$tp_index-> newBlock ( "tp_p2_list_01_nopro" ); // 瀏覽 block
}
$mnum = 0;
$tp_index-> newBlock ( "tp_p2_list" ); // 瀏覽 block
while ($row_product = mysql_fetch_array($result_product)) {
$tp_index-> newBlock ( "tp_p2_list_01" ); // 瀏覽 block
$tp_index-> assign ( "tp_p2_list_01.tp_s_num" , $row_product["s_num"] ); // s_num
$tp_index-> assign ( "tp_p2_list_01.tp_pd01" , $row_product["pd01"] ); // 類別代號
$tp_index-> assign ( "tp_p2_list_01.tp_pd02" , $row_product["procode"] ); // 產品代號
$tp_index-> assign ( "tp_p2_list_01.mpd01" , $mpd01 ); // 產品代號
$tp_index-> assign ( "tp_p2_list_01.f_page" , $f_page ); // 產品代號
$tp_index-> assign ( "tp_p2_list_01.tp_pcount" , ($row_product["pageviews"]) ); // 產品代號
$tp_index-> assign ( "tp_p2_list_01.tp_pd03" , $row_product["pd03"] ); // 品牌
$tp_index-> assign ( "tp_p2_list_01.tp_pd04" , StripSlashes($row_product["proname"]) ); // 品名
$tp_index-> assign ( "tp_p2_list_01.tp_pd05" , $row_product["unit"] ); // 規格
$tp_index-> assign ( "tp_p2_list_01.tp_pd06" , $row_product["unit"] ); // 單位
if ($_REQUEST['disb']==''){
$tp_index-> newBlock ( "tp_p2_list_01_01" ); // 瀏覽 block
}
if ($_REQUEST['disb']=='0'){
$tp_index-> newBlock ( "tp_p2_list_01_01" ); // 瀏覽 block
}
if ((u_checkal($row_product["pd02"])=='0') and ($row_product["pk11"])==0) {
$tp_index-> newBlock ( "tp_p2_list_01_01" ); // 瀏覽 block
}
if ($_SESSION["muser_vip"]=='Y'){
$tp_index-> assign ( "tp_p2_list_01.tp_pd07" , number_format($row_product["pd07"]*$row_product["pd24"]*0.1)); // 建議售價
if (!($row_product["pd24"]==10)){
$tp_index-> assign ( "tp_vip" , " " ); // 單位
}
}else{
$tp_index-> assign ( "tp_p2_list_01.tp_pd07" , number_format($row_product["unit"]) ); // 建議售價
}
$tp_index-> assign ( "tp_p2_list_01.tp_pd07_car" , $row_product["pd07"] ); // 建議售價-購物車用
$tp_index-> assign ( "tp_p2_list_01.tp_mat" , $row_product["mat"] ); // 使用方法
$tp_index-> assign ( "tp_p2_list_01.tp_color" , $row_product["color"] ); // 使用方法
$tp_index-> assign ( "tp_p2_list_01.tp_alink" , $row_product["alink"] ); // 使用方法
$tp_index-> assign ( "tp_p2_list_01.tp_unit" , nl2br($row_product["unit"]) ); // 使用方法
$tp_index-> assign ( "tp_p2_list_01.tp_pd08" , $row_product["sellingprice"] ); // 使用方法
$tp_index-> assign ( "tp_p2_list_01.tp_pd09" , $row_product["prodesc"] ); // 產品解說
$tp_index-> assign ( "tp_p2_list_01.tp_pd10" , $row_product["prophotob"] ); // 產品圖檔(小)
if (file_exists($row_product["prophotob"])){
list($width, $height, $value, $params) = GetImageSize(($row_product["prophotob"]));
$stdwidth=150;
$stdheight=800;
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
$tp_index-> assign ( "tp_p2_list_01.x" , $width ); // 品名
$tp_index-> assign ( "tp_p2_list_01.y" , $height ); // 品名
}
$tp_index-> assign ( "tp_p2_list_01.tp_pd10_big" , "bigimg.php?snum=".$row_product["pid"]."&img=".$row_product["prophotob"] ); // 產品圖檔(大)
$tp_index-> assign ( "tp_p2_list_01.tp_pd11" , $row_product["pd11"] ); // 產品圖檔(大)
$tp_index-> assign ( "tp_p2_list_01.tp_pd21" , number_format($row_product["pd21"]) ); // 購買紅利
$tp_index-> assign ( "tp_p2_list_01.tp_pd21_car" , $row_product["pd21"] ); // 購買紅利-購物車用
$tp_index-> assign ( "tp_p2_list_01.tp_pd22" , number_format($row_product["pd22"]) ); // 兌換紅利
$tp_index-> assign ( "tp_p2_list_01.tp_pd23" , $row_product["pd23"] ); // 是否上架
$tp_index-> assign ( "tp_p2_list_01.tp_mpd01" , $mpd01 ); //
$tp_index-> assign ( "tp_p2_list_01.tp_f_page" , $f_page ); //
////////////////////////////////// 首頁隨機產品
$mnum++;
}
return;
}
function u_p7771(){
global $tp_index;
global $form;
$query_photo = "select * from sys_template where funcid=".$_GET['cateid']." and tpl_name='ptpl_talbe_title' order by tplid desc";
$query_photo = "select * from infocate where cateid=".$_GET['cateid'];
//echo $query_photo;
$result_photo = mysql_query($query_photo);
$row_photo = mysql_fetch_array($result_photo);
$tp_index-> newBlock ("tp_ptpl_home_item");
$tp_index-> assign ("home_item",$row_photo["catename"]);
/////////////////////////////////////////////////////
$tp_index-> newBlock ( "tp_pagetitle" ); // 瀏覽 block
//$tp_index-> assign ( "tp_tour1_title.tp_title" , $row_product_kind_chk["title"] ); //
$tp_index-> assign ( "tp_pagetitle.title" , "-".$row_photo["catename"]."-圖片列表" ); //
$bigkind=$row_photo["catename"];
//////////////////////////////////////////////////////
$query_photo = "select * from infocate_k where cateid=".$_GET['cateid']." order by up_date desc";
$result_photo = mysql_query($query_photo);
$cateid=$_GET['cateid'];
$cateid_k=$_GET['cateid_k'];
if(empty($_GET['cateid_k'])) {
$query_product_kind_chk = "select * from infocate_k where cateid=".$_GET['cateid']." order by up_date desc";
$result_product_kind_chk = mysql_query($query_product_kind_chk);
$row_product_kind_chk = mysql_fetch_array($result_product_kind_chk);
$cateid_k = $row_product_kind_chk["cateid_k"];
}
while ($row_photo = mysql_fetch_array($result_photo)) {
$tp_index-> newBlock ("tp_photo_kind_list");
$tp_index-> assign ( "nn1" , "nn1" ); //
if ($row_photo["cateid_k"]==$cateid_k){
$tp_index-> assign ( "tp_strong" , "" ); //
$tp_index-> assign ( "tp_un_strong" , "" ); //
$tp_index-> assign ( "nn1" , "nn118" ); //
$nowkind=$row_photo['catename'];
}
$tp_index-> assign ( "photo_kind_name" , $row_photo['catename'] ); // 訂單日期
$tp_index-> assign ( "photo_kind_link" , "indexmain.php?mmenu=7771&cateid=".$row_photo['cateid']."&cateid_k=".$row_photo['cateid_k'] ); // 訂單日期
}
//////////////////////////////////////////////////////////////////////////
// $query_photo2 = "SELECT info.infoid as minfoid,info.infocate, info_k.title,info_k.infoid, info_k.infocatek FROM info INNER JOIN info_k ON info.infoid = info_k.infocate where info.infocate=$cateid and info_k.infocatek=$cateid_k";
$query_photo2 = "SELECT * FROM info where infocate=$cateid and scate=$cateid_k and cshow=2";
$result_photo2 = mysql_query($query_photo2);
$photornd=0;
//找出工程實績列表
while($row_photo2 = mysql_fetch_array($result_photo2)) {
// echo "ff";
// $query_photo22 = "SELECT * FROM info_k where infocate=".$row_photo2['infoid'];
// $result_photo22 = mysql_query($query_photo22);
$isget=0;
// while($row_photo22 = mysql_fetch_array($result_photo22)){
$photo_dir = "data/engineer/" . $row_photo2["infoid"]."/" ;
//echo $photo_dir;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[$photornd]['filen'] .= $photo_dir.$file;
$filelist[$photornd]['title'] .= $row_photo2["title"];
$filelist[$photornd]['rown'] .= $row_photo2["infoid"];
$filelist[$photornd]['idn'] .= $photornd;
$photornd++;
$isget=1;
if ($isget==1){
break;}
}
}
} //找出工程實績列表結束
//print_r($filelist);
//exit;
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$photornd=0;
if($filelist) {
foreach($filelist as $key=>$val) {
if (($val['idn']>=$msnum) and ($val['idn']<=($msnum+11))){
$link = $val['filen'];
list($width, $height, $value, $params) = GetImageSize($link);
////////////////////////////////////
$stdwidth=200;
$stdheight=150;
//echo $width;
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
// list($width,$height)= htmlresize($width,$height,$stdwidth,$stdheight);
$orgvaltitle=$val["title"];
if (mb_strlen($val["title"], 'UTF-8')>255){
$val["title"]=mb_substr(($val["title"]),0,255,"UTF-8")."..";
}
// width=160 height=120
// $photoshow[$photornd] = "
";
// $photoshow[$photornd] = "
".$row_photo2['title'];
// $photornd=$photornd+1;
// width=160 height=120
$photoshow[$photornd] = "";
// $photoshow[$photornd] = "
".$row_photo2['title'];
$photornd=$photornd+1;
}
}
}
$tp_index-> newBlock ("tp_photo_table");
$tp_index-> assign ( "tp_photo_table" , $form->tablegrid($photoshow, 3, "97%", 210, "ffffff", "center $tr_mouse", " align=center cellpadding=3'", "top style='border: 496eb5 1px dotted;'") ); // 訂單日期
$tp_index-> newBlock ( "tp_p4_02" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=7771&cateid=".$_GET['cateid']."&cateid_k=".$_GET['cateid_k'],count($filelist),'','',$msnum,0,'',9) );
}
function u_p777(){
global $tp_index;
$tablename=$_GET['sname'];
$s1='title';
$s2='infoid';
$s3='up_date';
$s4=$_GET['infono'];
//$search_info=$_REQUEST['search_info'];
if ((($_POST['search_info']))) {
$search_info1=($_POST['search_info']);
$search_info2=base64_encode($_POST['search_info']);
}else{
$search_info1=base64_decode($_GET['search_info']);
$search_info2=($_GET['search_info']);
}
if (($_POST['search_info']=='') and ($_GET['search_info']=='')){
$mwhere=' where infocate='."10".' and cshow=2 ';
}else{
$mwhere=" where infocate=10 and cshow=2 and ((title like '%".$search_info1."%') or (contentnohtml like '%".$search_info1."%')) ";
}
//$mwhere=' where import=1 ';
// $query_photo = "select * from sys_template where funcid=".$s4." and tpl_name='ptpl_talbe_title' order by tplid desc";
// echo $query_photo;
// $result_photo = mysql_query($query_photo);
// $row_photo = mysql_fetch_array($result_photo);
$tp_index-> newBlock ("tp_ptpl_talbe_title");
$tp_index-> assign ("talbe_title",$row_photo["tpl_value"]);
if ($tablename=='photo_group'){
$s1='group_name';
$s2='photo_group_id';
$s3='up_date';
$mwhere='';
}
if ($_GET['offset']==''){
$msnum=0;
}else{
$msnum=$_GET['offset'];
}
$query_photo = "select * from $tablename $mwhere order by up_date desc";
$result_photo = mysql_query($query_photo);
$mmax_qty = mysql_num_rows($result_photo);
$query_photo = "select * from $tablename $mwhere order by up_date desc limit $msnum,10";
$result_photo = mysql_query($query_photo);
while ($row_photo = mysql_fetch_array($result_photo)) {
$mmax_qty--;
$tp_index-> newBlock ("tp_photo_group_list");
$tp_index-> assign ( "photo_group_name" , $row_photo[$s1] ); // 訂單日期
$tp_index-> assign ( "photo_group_no" , $row_photo["importseq"] ); // 訂單日期
$tp_index-> assign ( "photo_group_date" , substr($row_photo[$s3],0,10) ); // 訂單日期
$tp_index-> assign ( "photo_group_link" , "indexmain.php?mmenu=18000&sid=".$row_photo["infoid"]."&cateid=".$row_photo["infocate"]."&imp=1"
); // 連結
}
//if (($_POST['search_info']))
//$search_info=base64_encode($_POST['search_info']);
$tp_index-> newBlock ( "tp_p4_02" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=777&sname=".$_GET['sname']."&infono=".$_GET['infono']."&search_info=".$search_info2,$mmax_qty,'','',$msnum,0,'',10) );
}
function u_p888(){
global $tp_index;
$query_photo = "select * from photo_group order by up_date desc limit 0,10";
$result_photo = mysql_query($query_photo);
while ($row_photo = mysql_fetch_array($result_photo)) {
$tp_index-> newBlock ("tp_photo_group_list");
$tp_index-> assign ( "photo_group_name" , $row_photo["group_name"] ); // 訂單日期
$tp_index-> assign ( "photo_group_no" , $row_photo["photo_group_id"] ); // 訂單日期
$tp_index-> assign ( "photo_group_date" , substr($row_photo["up_date"],0,9) ); // 訂單日期
}
}
function u_p7979() {
global $mtable_photo;
global $mph_path;
global $tp_index;
global $mtable_product;
global $mtable_product_kind;
global $mpd_path;
global $tp_index;
global $f_que;
global $f_page;
global $mpd01;
global $pid;
// list($msnum,$mmax_qty)=u_pd_pg_photo(); // 計算頁次
// list($msnum,$mmax_qty)=u_pd_pg_product(); // 計算頁次
// echo $mmax_qty.'----';
$mwhere = "pd02='".$_GET['pid']."' and d_date='0000-00-00 00:00:00'";
if ($_GET['pid']=="")
{
$tp_index-> newBlock ( "tp_p3_list" );
$tp_index-> newBlock ( "tp_p3_list_01" ); // 瀏覽 block
$tp_index-> assign ( "uname" , $_SESSION["muser_name"] ); // 訂單日期
$tp_index-> assign ( "telno" , $_SESSION["muser_phone"] ); // 訂單日期
$tp_index-> assign ( "email" , $_SESSION["muser_email"] ); // 訂單日期
}
$mmaxline=9;
$query_photo = "select * from $mtable_product
where $mwhere
order by pd02
";
// $query_photo = "select * from $mtable_photo
// where d_date='0000-00-00 00:00:00'
// order by s_num desc
// limit $msnum,8
// ";
//echo $query_photo."
";
$result_photo = mysql_query($query_photo);
$mnum = 0;
$tp_index-> newBlock ( "tp_p3_list" ); // 瀏覽 block
while ($row_photo = mysql_fetch_array($result_photo)) {
// $tp_index-> newBlock ( "tp_p3_list_01" ); // 瀏覽 block
// $tp_index-> assign ( "tp_p3_list_01.tp_s_num" , $row_photo["s_num"] ); // 產品代號
// $tp_index-> assign ( "tp_p3_list_01.tp_ph01" , $row_photo["ph01"] ); // 產品代號
// $tp_index-> assign ( "tp_p3_list_01.tp_ph02" , $row_photo["ph02"] ); // 產品名稱
// $tp_index-> assign ( "tp_p3_list_01.tp_ph03" , $row_photo["ph03"] ); // 圖片說明
// $tp_index-> assign ( "tp_p3_list_01.tp_ph04" , $row_photo["ph04"] ); // 照片檔
// $tp_index-> assign ( "tp_p3_list_01.tp_ph04_link" , $mph_path.$row_photo["ph04"] ); // 檔案名稱連結
// $tp_index-> assign ( "tp_p3_list_01.tp_link" , u_showproc().".php?mmenu=31&ms_num=".$row_photo[s_num] ); // 連結資料
$tp_index-> newBlock ( "tp_p3_list_01" ); // 瀏覽 block
$tp_index-> assign ( "uname" , $_SESSION["muser_name"] ); // 訂單日期
$tp_index-> assign ( "telno" , $_SESSION["muser_phone"] ); // 訂單日期
$tp_index-> assign ( "email" , $_SESSION["muser_email"] ); // 訂單日期
$tp_index-> assign ( "tp_p3_list_01.tp_s_num" , $row_photo["s_num"] ); // s_num
$tp_index-> assign ( "tp_p3_list_01.tp_pd01" , $row_photo["pd01"] ); // 類別代號
$tp_index-> assign ( "tp_p3_list_01.tp_pd02" , $row_photo["pd02"] ); // 產品代號
$tp_index-> assign ( "tp_p3_list_01.tp_pcount" , ($row_photo["pd25"]) ); // 產品代號
$tp_index-> assign ( "tp_p3_list_01.mpd01" , ($_GET["mpd01"]) ); // 產品代號
$tp_index-> assign ( "tp_p3_list_01.tp_pd03" , $$row_photo["pd03"] ); // 品牌
$tp_index-> assign ( "tp_p3_list_01.tp_pd04" , StripSlashes($row_photo["pd04"]) ); // 品名
$tp_index-> assign ( "tp_p3_list_01.tp_pd05" , $row_photo["pd05"] ); // 規格
$tp_index-> assign ( "tp_p3_list_01.tp_pd06" , $row_photo["pd06"] ); // 單位
$tp_index-> assign ( "tp_p3_list_01.tp_pd07" , $row_photo["pd07"] ); // 單位
$tp_index-> assign ( "tp_p3_list_01.tp_pd07_car" , $row_photo["pd07"] );
$tp_index-> assign ( "tp_p3_list_01.tp_pd08" , StripSlashes($row_photo["pd08"]) ); // 使用方法
$tp_index-> assign ( "tp_p3_list_01.tp_pd09" , StripSlashes($row_photo["pd09"]) ); // 產品解說
//$tp_index-> assign ( "tp_p22_list_01.tp_pb10" , $row_product_bonus["pb10"] ); // 產品圖檔(小)
$tp_index-> assign ( "tp_p3_list_01.tp_pd10" , $mpb_path.'s-'.$row_photo["pd10"] ); // 產品圖檔(小)
$tp_index-> assign ( "tp_p3_list_01.tp_pd10_big" , $mpb_path.$row_photo["pd10"] ); // 檔案名稱連結
$tp_index-> assign ( "tp_p3_list_01.tp_pd10_link" , $mpb_path.$row_photo["pd10"] ); // 檔案名稱連結
$tp_index-> assign ( "tp_p3_list_01.tp_pd11" , $row_photo["pd11"] ); // 產品圖檔(大)
$tp_index-> assign ( "tp_p3_list_01.tp_pd11_link" , $mpb_path.$row_photo["pd11"] ); // 檔案名稱連結
$tp_index-> assign ( "tp_p3_list_01.tp_pd21" , $row_photo["pd21"] ); // 購買紅利
$tp_index-> assign ( "tp_p3_list_01.tp_pd22" , number_format($row_photo["pd22"]) ); // 兌換紅利
$tp_index-> assign ( "tp_p3_list_01.tp_pd22_car" , $row_photo["pd22"] ); // 兌換紅利-購物車用
$tp_index-> assign ( "tp_p3_list_01.tp_pd23" , $row_photo["pd23"] ); // 是否上架
$tp_index-> assign ( "tp_p3_list_01.tp_bonus" , $f_bonus ); // 依紅利點查詢紅利獎品
$mnum++;
if($mnum%3==0) { // 換下一行
$tp_index-> newBlock ( "tp_p3_list" ); // 瀏覽 block
}
}
//ECHO ($mnum)."G";
//ECHO ($mnum%3);
for($i=1;$i<(4-($mnum%3));$i++){
$tp_index-> newBlock ( "tp_p3_list_02" ); // 瀏覽 block
}
;
return;
}
//////////////////////
//////////////////////////
function u_p922() {
global $tp_index;
$tp_index-> newBlock ( "tp_p6_in_01" ); // 瀏覽 block
return;
}
//////////////////////////////////////////////////////
function function_result($query) {
$sql_table = "twcityor_macrocosm";
//echo $sql_table;
//mysql_connect("localhost","twcityor_macro","18143260");
mysql_connect("localhost","hengyi","H18143260i");
//mysql_connect("localhost","root","");
mysql_select_db($sql_table);
$result = mysql_query($query);
$row_nums = @mysql_num_rows($result);
$field_nums = @mysql_num_fields($result);
if($row_nums==0) {
return $result;
} else {
return $result;
}
}
function u_p101() {
if ($_SESSION["muser_id"]=="" )
{
?>
newBlock ( "tp_out_01_01" ); // 輸出瀏覽畫面
$tp_index-> assign ( "tp_om01" ,$row[foid] ); // 首筆
$tp_index-> assign ( "tp_om02" , $row[up_date] ); // 首筆
if ($row['orderstatus']==1) { $orderstatus="新訂單";}
if ($row['orderstatus']==2) { $orderstatus="訂單接受";}
if ($row['orderstatus']==3) { $orderstatus="訂單完成";}
if ($row['orderstatus']==4) { $orderstatus="訂單取消";}
if ($row['orderstatus']=='') { $orderstatus="訂單錯誤";}
$tp_index-> assign ( "tp_om09" , $orderstatus ); // 首筆
$tp_index-> assign ( "tp_om08" , $row[amount] ); // 首筆
$tp_index-> assign ( "tp_om06" , $row[freight] ); // 首筆
$array_proid = explode(",",$row[pro_id]);
$array_pice = explode(",",$row[price]);
$array_nums = explode(",",$row[qty]);
$array_unit = explode(",",$row[unit]);
$i = 1; $sub_total= 0;
for($j=0; $j newBlock ("tp_out_01_01_01"); // 輸出瀏覽畫面
// $tp_index-> assign ("tp_class" , $mclass); // class
$query_proname="select proname from products where procode='$array_proid[$j]' ";
list($proname) = mysql_fetch_row(function_result($query_proname));
$tp_index-> assign ("tp_od02" , $array_proid[$j]); // class
$tp_index-> assign ("tp_od04" , $proname); // class
$tp_index-> assign ("tp_od05" , $array_pice[$j]); // class
$tp_index-> assign ("tp_od06" , $array_nums[$j]); // class
$tp_index-> assign ("tp_od07" , $array_unit[$j]); // class
$tp_index-> assign ("tp_od09" , ($array_pice[$j] * $array_nums[$j])); // class
$i++;
}
}
// exit;
$tp_index-> newBlock ( "tp_p4_02" ); // 瀏覽 block
$tp_index-> assign ( "spage" , html_page("indexmain.php?mmenu=101",$mmax_qty,'','',$msnum,0,'',8) );
}
/////////////////////////////////////////////////
/////////////////////////////////////////////////////
function u_p10111111() {
if ($_SESSION["muser_id"]=="" )
{
?>
";
$result_order_main = mysql_query($query_order_main);
$row_order_main = mysql_fetch_array($result_order_main);
if($vsel=='4'||$vsel=='51') { // 瀏覽 or 查詢
}
else {
$tp_index-> newBlock ( "tp_in_01" ); // 輸入畫面-確定按鈕
}
if ($row_order_main["om11"]==1){
$mmb111 = "郵政劃撥"; // 付款法
$sel1="selected";
}
if ($row_order_main["om11"]==2){
$mmb111 = "電匯"; // 付款法
$sel2="selected";
}
if ($row_order_main["om11"]==3){
$mmb111= "貨到付款"; // 付款法
$sel3="selected";
}
$tp_index-> assign ( "tp_in_01.tp_width1" , "15%" ); //
$tp_index-> assign ( "tp_in_01.tp_width2" , "85%" ); //
$tp_index-> assign ( "tp_in_01.tp_action" , u_showproc().".php?msel=".$vsel."1" ); // form action
$tp_index-> assign ( "tp_in_01.tp_date" , date("Ymd") ); // 公佈欄日期
$tp_index-> assign ( "tp_in_01.tp_s_num" , $row_order_main["s_num"] ); // 流水號
$tp_index-> assign ( "tp_in_01.tp_om01" , $row_order_main["om01"] ); // 訂單編號
$tp_index-> assign ( "tp_in_01.tp_om02" , $row_order_main["om02"] ); // 訂單日期
$tp_index-> assign ( "tp_in_01.tp_om03" , $row_order_main["om03"] ); // 會員帳號
$tp_index-> assign ( "tp_in_01.tp_om04" , $row_order_main["om04"] ); // 會員姓名
$tp_index-> assign ( "tp_in_01.tp_om05" , $row_order_main["om05"] ); // 總數量
$tp_index-> assign ( "tp_in_01.tp_om06" , $row_order_main["om06"] ); // 運費
$tp_index-> assign ( "tp_in_01.tp_om07" , $row_order_main["om07"] ); // 折扣
$tp_index-> assign ( "tp_in_01.tp_om08" , $row_order_main["om08"] ); // 總金額
$tp_index-> assign ( "tp_in_01.tp_om09" , $row_order_main["om09"] ); // 狀態
$tp_index-> assign ( "tp_in_01.tp_oom09" , $row_order_main["om09"] ); // 狀態-紀錄修改前的資料
$tp_index-> assign ( "tp_in_01.tp_om10" , $row_order_main["om10"] ); // 備註
$tp_index-> assign ( "sel1" , $sel1 ); // 付款法
$tp_index-> assign ( "sel2" , $sel2 ); // 付款法
$tp_index-> assign ( "sel3" , $sel3 ); // 付款法
if($vsel==1||$vsel==2||$vsel==3) { // 1=新增、2=修改、3=刪除
$tp_index-> newBlock ( "tp_in_01_01" ); // 輸入畫面-確定按鈕
$tp_index-> assign ( "tp_btn_str" , $vbtn_str ); // 確定 botton 的文字
}
if($vsel=='4'||$vsel=='51') { // 瀏覽 or 查詢
if($vque==NULL) {
$mwhere = "d_date='0000-00-00 00:00:00'";
}
else {
$mwhere = "(om01 like '%$vque%' or om02 like '%$vque%' or
om03 like '%$vque%' or om04 like '%$vque%') and
d_date='0000-00-00 00:00:00'
";
}
if(!empty($f_om09)) {
$mwhere .= "and om09='$f_om09' and d_date='0000-00-00 00:00:00'";
}
if($vque1=='1') {
$mwhere .= " and om09='1' and d_date='0000-00-00 00:00:00'";
}
$mwhere.=" and om03='".$_SESSION["muser_id"]."' ";
$query_order_main1 = "select * from $mtable_order_main
where $mwhere
order by om01 desc
";
// echo $query_order_main1.'
';
$result_order_main = mysql_query($query_order_main1);
$mstock_qty = mysql_num_rows($result_order_main); // 目前總筆數
$msnum = ($f_page*$mmaxline)-$mmaxline; // 起始比數
$mpagetot = floor(((($mmaxline-1)+$mstock_qty)/$mmaxline)); // 求整數，最大頁次
if($f_page==1) { // 首頁，不可再往上
$mup_page = $f_page;
}
else {
$mup_page = $f_page-1;
}
if($f_page==$mpagetot) { // 末頁，不可再往上
$mdn_page = $f_page;
}
else {
$mdn_page = $f_page+1;
}
$query_order_main1 = "select * from $mtable_order_main
where $mwhere
order by om01 desc
limit $msnum,$mmaxline
";
//echo $query_order_main1."
";
$result_order_main1 = mysql_query($query_order_main1);
$mnum = 1;
$tp_index-> newBlock ( "tp_out_01" ); // 輸出瀏覽畫面
$tp_index-> assign ( "tp_top_page" , u_showproc().".php?msel=".$vsel."&f_page=1&f_que=".$vque ); // 首筆
$tp_index-> assign ( "tp_up_page" , u_showproc().".php?msel=".$vsel."&f_page=".$mup_page."&f_que=".$vque ); // 上頁
$tp_index-> assign ( "tp_dn_page" , u_showproc().".php?msel=".$vsel."&f_page=".$mdn_page."&f_que=".$vque ); // 下頁
$tp_index-> assign ( "tp_bot_page" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_que=".$vque ); // 末筆
$tp_index-> assign ( "tp_page" , number_format($f_page) ); // 目前頁次
$tp_index-> assign ( "tp_maxpage" , number_format($mpagetot) ); // 總頁次
$tp_index-> assign ( "tp_reccount" , number_format($mstock_qty) ); // 資料筆數
$tp_index-> assign ( "tp_link_om09_0" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=&f_que=".$vque ); // 0.全部
$tp_index-> assign ( "tp_link_om09_1" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=1&f_que=".$vque ); // 1.處理中
$tp_index-> assign ( "tp_link_om09_2" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=2&f_que=".$vque ); // 2.送貨中
$tp_index-> assign ( "tp_link_om09_3" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=3&f_que=".$vque ); // 3.已完成
$tp_index-> assign ( "tp_link_om09_4" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=4&f_que=".$vque ); // 4.已退貨
$tp_index-> assign ( "tp_link_om09_5" , u_showproc().".php?msel=".$vsel."&f_page=".$mpagetot."&f_om09=5&f_que=".$vque ); // 5.已作廢
$mdetail_cnt = 0; // 單身筆數
if (mysql_num_rows($result_order_main1)==0)
{
$tp_index-> newBlock ( "tp_out_01_019" ); // 輸出瀏覽畫面
}
while ($row_order_main1 = mysql_fetch_array($result_order_main1)) {
$tp_index-> newBlock ( "tp_out_01_01" ); // 輸出瀏覽畫面
// Mark by Tony 主檔用一種顏色
//if($mnum%2==0) {
// $mclass = "value_color";
//}
//else {
// $mclass = "";
//}
$mclass = "value_color";
$tp_index-> assign ( "tp_class" , $mclass ); // class
$tp_index-> assign ( "tp_om01" , $row_order_main1["om01"] ); // 訂單編號
//$tp_index-> assign ( "tp_om02" , $row_order_main1["om02"] ); // 訂單日期
$tp_index-> assign ( "tp_userid" , $_SESSION["muser_id"] ); // 訂單日期
$tp_index-> assign ( "tp_om02" , substr($row_order_main1["om02"],5,5) ); // 訂單日期
$tp_index-> assign ( "tp_om03" , $row_order_main1["om03"] ); // 會員帳號
$tp_index-> assign ( "tp_om04" , $row_order_main1["om04"] ); // 會員姓名
$tp_index-> assign ( "tp_om05" , number_format($row_order_main1["om05"]) ); // 總數量
$tp_index-> assign ( "tp_om06" , number_format($row_order_main1["om06"]) ); // 運費
$tp_index-> assign ( "tp_om07" , number_format($row_order_main1["om07"]) ); // 折扣
$tp_index-> assign ( "tp_om08" , number_format($row_order_main1["om08"]) ); // 總金額
$tp_index-> assign ( "tp_om09" , u_od_statu($row_order_main1["om09"]) ); // 狀態
$tp_index-> assign ( "tp_om10" , $row_order_main1["om10"] ); // 備註
$tp_index-> assign ( "tp_link" , u_showproc().".php?msel=41&ms_num=".$row_order_main1["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
$tp_index-> assign ( "tp_link_upd" , u_showproc().".php?msel=2&ms_num=".$row_order_main1["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
if("1"==$row_order_main1["om09"]) { // 1.處理中，才可以刪除資料
$tp_index-> assign ( "tp_link_del" , u_showproc().".php?msel=3&ms_num=".$row_order_main1["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
}
else {
$tp_index-> assign ( "tp_link_del" , "javascript:alert('狀態不是【1.處理中】，不可以刪除。');" ); // 連結刪除資料
}
$mnum++;
$query_order_detail = "select * from $mtable_order_detail
where od01='$row_order_main1[om01]' and
d_date='0000-00-00 00:00:00'
order by od01
";
//echo $query_order_detail."
";
$result_order_detail = mysql_query($query_order_detail);
$mclass = "value_color";
$mdetail_num = 1; // 單身筆數
while ($row_order_detail = mysql_fetch_array($result_order_detail)) {
$tp_index-> newBlock ( "tp_out_01_01_01" ); // 輸出瀏覽畫面
$tp_index-> assign ( "tp_class" , $mclass ); // class
$tp_index-> assign ( "tp_num" , $mdetail_num ); // 序
$tp_index-> assign ( "tp_od01" , $row_order_detail["od01"] ); // 訂單編號
$tp_index-> assign ( "tp_od02" , $row_order_detail["od02"] ); // 產品代號
$tp_index-> assign ( "tp_od03" , $row_order_detail["od03"] ); // 品牌
$tp_index-> assign ( "tp_od04" , $row_order_detail["od04"] ); // 品名
$tp_index-> assign ( "tp_od05" , number_format($row_order_detail["od05"]) ); // 單價
$tp_index-> assign ( "tp_od06" , number_format($row_order_detail["od06"]) ); // 數量
$tp_index-> assign ( "tp_od07" , $row_order_detail["od07"] ); // 規格
$tp_index-> assign ( "tp_od08" , $row_order_detail["od08"] ); // 單位
$tp_index-> assign ( "tp_od09" , number_format($row_order_detail["od09"]) ); // 小計
$tp_index-> assign ( "tp_od10" , number_format($row_order_detail["od10"]) ); // 紅利
$tp_index-> assign ( "tp_od11" , $row_order_detail["od11"] ); // 備註
$tp_index-> assign ( "tp_link" , "order_detail.php?msel=41&ms_num=".$row_order_detail["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
$tp_index-> assign ( "tp_link_upd" , "order_detail.php?msel=2&ms_num=".$row_order_detail["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
//echo $row_order_main1["om09"].'---';
if("1"==$row_order_main1["om09"]) { // 1.處理中，才可以刪除資料
$tp_index-> assign ( "tp_link_del" , "order_detail.php?msel=3&ms_num=".$row_order_detail["s_num"]."&f_page=".$f_page."&f_que=".$vque ); // 連結修改資料
}
else {
$tp_index-> assign ( "tp_link_del" , "javascript:alert('狀態不是【1.處理中】，不可以刪除。');" ); // 連結刪除資料
}
$mdetail_num++;
$mdetail_cnt++;
}
}
$tp_index-> assign ( "tp_out_01.tp_detail_cnt", number_format($mdetail_cnt) ); // 明細資料筆數
}
return;
}
/////////////////////////////////////////////////
function u_checkal($pid) {
$query_company="SELECT product.*, product_kind.*
FROM product_kind INNER JOIN product ON product_kind.pk01 = product.pd01 where pd02='$pid'
";
//echo $query_company;
$result_company = mysql_query($query_company);
$row_company = mysql_fetch_array($result_company);
return($row_company["pk11"]);
}
function logout()
{
// session_cache_limiter("nocache");
// session_start();
$mbase_path = 'indexmain.php';
include_once($mbase_path.'zi_init.php'); // 共用自訂函數與變數設定
setcookie("member_userid", "");
session_destroy(); // 移除所有 session]
echo "";
}
/////////////////////////////////
function loginprocess(){
global $link;
$msel = $_REQUEST["msel"];
$login_id = $_POST["login_id"];
$login_pw = $_POST["login_pw"];
$query= db_query("select member_userid,member_nickname,mkind from member where member_userid='$login_id' and password='".$login_pw."'", $link);
list ($member_userid, $member_nickname,$mkind) = db_fetch_row($query);
if ($member_userid) {
setcookie("member_userid", $member_userid);
setcookie("member_nickname", $member_nickname);
if ($_SERVER["QUERY_STRING"]) {
$query_string = array ();
foreach ($_GET as $k => $v) {
$query_string[] = "$k=$v";
}
$QUERY_STRING = implode("&", $query_string);
$QUERY_STRING = ($QUERY_STRING) ? "./?$QUERY_STRING" : "./";
}
echo "";
exit;
}
else {
$mgo_url = "../indexmain.php";
$mmsg = '登入失敗!!!請重新登入!!!';
$mmsg_ng_num = '289503';
?>
newBlock ( "tp_p1_bmusic" ); // 瀏覽 block
$tp_index-> assign ( "bmusic" , "images/".$row_company["cp11"] ); //
}
//////////////////////////////////////////////
function u_p6609() {
global $mservermail;
$mservermail="tftf@tftf.com.tw";
$msubject = '意見詢問'; // 標題
$msubject = "=?UTF-8?B?" . base64_encode($msubject) . "?=";
$mexdata = "Content-Type:text/html;charset=utf-8\n";
$mexdata .= "From:".$mservermail."\nReply-To:".$mservermail;
$mbody = '';
$mbody .= '謝謝您的詢問，您的詢問單明細如下..'."\n\n";
// $mbody .= '詢問單編號:'.$mom01."\n";
$mbody .= '公司:'.StripSlashes($_POST["f_mb05222"])."\n";
$mbody .= '職稱:'.StripSlashes($_POST["f_mb052"])."\n";
$mbody .= '您的稱呼:'.StripSlashes($_POST["f_mb02"])."\n";
$mbody .= '電話:'.StripSlashes($_POST["f_mb05"])."\n";
$mbody .= '電子郵件:'.StripSlashes($_POST["f_email"])."\n";
$mbody .= '意見:'.StripSlashes($_POST["f_mb17"])."\n";
//$mto = 'loung-yeen@umail.hinet.net';
//$mto = 'loung-yeen@loungyeen.com.tw;loung-yeen@umail.hinet.net;tftf@tftf.com.tw;ang1l@mail2000.com.tw';
$mto = 'tftf@tftf.com.tw';
$mcar_msg = '謝謝您! 您的意見已送出,請敬待我們回覆!!';
$mgo_url = "indexmain.php";
if(!mail( $mto , $msubject , $mbody , "$mexdata")) {
$mcar_msg = '詢問單送出失敗...請聯絡網管人員!!';
$mgo_url = "indexmain.php";
}
?>
newBlock ( "tp_randhome1" ); // 瀏覽 block
$tp_index-> assign ( "randhome1_link" , u_showproc().".php?mmenu=2&mpd01=".$mpd01."&f_page=1&f_que=".$row_company["pd02"]."&linkact=1" ); //
$tp_index-> assign ( "randhome1_name" , $row_company["pd04"] ); //
$tp_index-> assign ( "randhome1_pic" , $mpb_path.'pd/s-'.$row_company["pd10"] ); //
$tp_index-> assign ( "randhome_alt" , $row_company["pd04"] ); //
$row_company = mysql_fetch_array($result_company);
$tp_index-> newBlock ( "tp_randhome2" ); // 瀏覽 block
$tp_index-> assign ( "randhome1_link" , u_showproc().".php?mmenu=2&mpd01=".$mpd01."&f_page=1&f_que=".$row_company["pd02"]."&linkact=1" ); //
$tp_index-> assign ( "randhome1_name" , $row_company["pd04"] ); //
$tp_index-> assign ( "randhome1_pic" , $mpb_path.'pd/s-'.$row_company["pd10"] ); //
$tp_index-> assign ( "randhome_alt" , $row_company["pd04"] ); //
$row_company = mysql_fetch_array($result_company);
$tp_index-> newBlock ( "tp_randhome3" ); // 瀏覽 block
$tp_index-> assign ( "randhome1_link" , u_showproc().".php?mmenu=2&mpd01=".$mpd01."&f_page=1&f_que=".$row_company["pd02"]."&linkact=1" ); //
$tp_index-> assign ( "randhome1_name" , $row_company["pd04"] ); //
$tp_index-> assign ( "randhome1_pic" , $mpb_path.'pd/s-'.$row_company["pd10"] ); //
$tp_index-> assign ( "randhome_alt" , $row_company["pd04"] ); //
}
////////////////////////////////////////////////////////////////////////////////////
function u_p7724() {
//echo "ggg";
global $mtable_company;
global $mimg_path;
global $tp_index;
global $mtable_product;
global $mpd_path;
$query_company = "select * from $mtable_product where d_date='0000-00-00 00:00:00' order by pd25 desc";
//echo $query_company.'--------------';
$result_company = mysql_query($query_company);
$row_company = mysql_fetch_array($result_company);
$tp_index-> newBlock ( "tp_randhome4" ); // 瀏覽 block
$tp_index-> assign ( "randhome1_link" , u_showproc().".php?mmenu=2&mpd01=".$mpd01."&f_page=1&f_que=".$row_company["pd02"]."&linkact=1" ); //
$tp_index-> assign ( "randhome1_name" , $row_company["pd04"] ); //
$tp_index-> assign ( "randhome1_pic" , $mpb_path.'pd/s-'.$row_company["pd10"] ); //
$tp_index-> assign ( "randhome_alt" , $row_company["pd04"] ); //
$row_company = mysql_fetch_array($result_company);
$tp_index-> newBlock ( "tp_randhome5" ); // 瀏覽 block
$tp_index-> assign ( "randhome1_link" , u_showproc().".php?mmenu=2&mpd01=".$mpd01."&f_page=1&f_que=".$row_company["pd02"]."&linkact=1" ); //
$tp_index-> assign ( "randhome1_name" , $row_company["pd04"] ); //
$tp_index-> assign ( "randhome1_pic" , $mpb_path.'pd/s-'.$row_company["pd10"] ); //
$tp_index-> assign ( "randhome_alt" , $row_company["pd04"] ); //
}
function u_p12_2_2() {
global $tp_index;
global $link;
$query_product = "select * from info
where infocate=46";
//echo $query_product;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
$photolist="";
$tp_index-> newBlock ( "tp_2_4" ); // 瀏覽 block
$tp_index-> assign ( "title" , ($row_product["title"]) ); // s_num
$tp_index-> assign ( "progressday1" , ($row_product["progressday1"]) ); // s_num
$tp_index-> assign ( "recdep" , ($row_product["recdep"]) ); // s_num
$tp_index-> assign ( "recdate" , ($row_product["recdate"]) ); // s_num
$tp_index-> assign ( "addtext1" , ($row_product["addtext1"]) ); // s_num
$tp_index-> assign ( "up_date" , ($row_product["up_date"]) ); // s_num
unset($filelist);
$photo_dir = "data/infofile/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$tp_index-> assign ( "file" , $photo_dir."/".$filelist[0] ); // s_num
}
$mnum++;
return;
}
function u_p12_2_1() {
global $tp_index;
global $link;
$query_product = "select * from info
where infocate=45";
//echo $query_product;
$result_product = mysql_query($query_product);
$mnum = 0;
while ($row_product = mysql_fetch_array($result_product)) {
$photolist="";
$tp_index-> newBlock ( "tp_2_4_1" ); // 瀏覽 block
$tp_index-> assign ( "title" , ($row_product["title"]) ); // s_num
$tp_index-> assign ( "progressday1" , ($row_product["progressday1"]) ); // s_num
$tp_index-> assign ( "recdep" , ($row_product["recdep"]) ); // s_num
$tp_index-> assign ( "recdate" , ($row_product["recdate"]) ); // s_num
$tp_index-> assign ( "addtext1" , ($row_product["addtext1"]) ); // s_num
$tp_index-> assign ( "up_date" , ($row_product["up_date"]) ); // s_num
unset($filelist);
$photo_dir = "data/infofile/" . $row_product["infoid"] ;
$current_dir = @opendir($photo_dir);
while ($file = @readdir($current_dir)) {
if ($file != ".." && $file != "." && $file != "Thumbs.db") {
$filelist[] .= $file;
}
}
$tp_index-> assign ( "file" , $photo_dir."/".$filelist[0] ); // s_num
}
$mnum++;
return;
}
///////////////////////////////////////////////////////////////////////////////////
// **************************************************************************
// 函數名稱: u_p1()
// 函數功能: 關於忠山茗硯藝坊
// 使用方式: u_p1()
// 程式設計: Tony
// 設計日期: 2004.11.07
// **************************************************************************
function u_p_counter() {
global $mtable_company;
global $mimg_path;
global $tp_index;
$query_company = "select * from counter
";
$result_company = mysql_query($query_company);
$row_company = mysql_fetch_array($result_company);
$tp_index-> newBlock ( "tp_counter" ); // 瀏覽 block
$tp_index-> assign ( "count" ,$row_company["count"] ); //
return;
}
function u_p1() {
global $mtable_company;
global $mimg_path;
global $tp_index;
$query_company = "select * from $mtable_company
where s_num = '1'
order by s_num
";
//echo $query_company.'--------------';
$result_company = mysql_query($query_company);
$row_company = mysql_fetch_array($result_company);
$mcp01 = str_replace("\r\n","
",$row_company["cp01"]);
$mcp02 = str_replace("\r\n","
",$row_company["cp02"]);
$mcp03 = str_replace("\r\n","
",$row_company["cp03"]);
$mcp04 = str_replace("\r\n","
",$row_company["cp04"]);
//echo $row_company["cp02"];
$tp_index-> newBlock ( "tp_p1_list" ); // 瀏覽 block
$tp_index-> assign ( "tp_cp01" , StripSlashes($row_company["cp01"]) ); //
$tp_index-> assign ( "tp_cp02" , StripSlashes($mcp02) ); //
$tp_index-> assign ( "tp_cp03" , StripSlashes($mcp03) ); //
$tp_index-> assign ( "tp_cp04" , StripSlashes($mcp04) ); //
$tp_index-> assign ( "tp_cp10" , $mimg_path."s-".$row_company["cp10"] ); // 照片1連結
return;
}
function u_fulltext(){
global $tp_index;
$infoarray=array("15"=>"財務報表","10"=>"最新消息","15"=>"認可基準","37"=>"認可規定","8"=>"業務內容","8"=>"訓練講習","20"=>"設備公告欄","3"=>"訓練講習","4"=>"消防設計監造檢修","77"=>"表格與檔案下載","17"=>"認可基準","332"=>"相關網站","1"=>"組織架構");
$infolinkarray=array("15"=>"財務報表","10"=>"1-1-1","15"=>"認可基準","37"=>"認可規定","8"=>"業務內容","8"=>"訓練講習","20"=>"設備公告欄","3"=>"5-4-1","4"=>"6-1","77"=>"13-1","17"=>"4-4","332"=>"9-1","1"=>"2-1");
//print_r($infoarray);
$keyword= $_POST['keyword'];
$ii=1;
if (mb_strlen($keyword,'UTF-8')<1){
echo "
";
$tp_index-> newBlock ( "tp_fulltext_count" ); // 瀏覽 block
$tp_index-> assign ( "tp_count" , 0 ); // s_num
return;
}
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keyword=mb_str_replace(" "," ",$keyword,"UTF-8");
$keywordarray=explode(" ",$keyword);
// for ($mx=0;$mx".$row_product_kindc['infocate1'].$infoarray[$row_product_kindc['infocate']]."=>".mb_substr($row_product_kindc['title'],0,20,"UTF-8")."=>".mb_substr($row_product_kindc['contentnohtml'],$minpos,38,"UTF-8"));
$fullrow[$ii][1]=mb_str_replace($keyword,"".$keyword."",$fullrow[$ii][1],"UTF-8");
$fullrow[$ii][2]="indexmain.php?mmenu=".$infolinkarray[$row_product_kindc['infocate']]."&sum=".$row_product_kindc["infoid"];
$fullrow[$ii][3]=$row_product_kindc['infocate'];
$ii++;
$spos=$inpos+2;
}
//////////////////////////////////////////////////////
$qstr="(info.contentnohtml like '%".$keywordarray[0]."%' or info.title like '%".$keywordarray[0]."%')";
//}
$query_product_kind_chkc = "select * from info where $qstr order by infocate";
$result_product_kind_chkc = mysql_query($query_product_kind_chkc);
while($row_product_kindc = mysql_fetch_array($result_product_kind_chkc)) {
$spos=0;
$inpos=mb_strpos($row_product_kindc["contentnohtml"],$keyword,$spos,"UTF-8");
$inpos=mb_strpos($row_product_kindc["contentnohtml"],$keyword,$spos,"UTF-8");
if ($inpos<15){
$minpos=0;}
else
{
$minpos=$inpos-15;
}
$fullrow[$ii][1]=($ii.".".$row_product_kindc['infocate1'].$infoarray[$row_product_kindc['infocate']]."=>".mb_substr($row_product_kindc['title'],0,10,"UTF-8")."=>".mb_substr($row_product_kindc['contentnohtml'],$minpos,38,"UTF-8"));
$fullrow[$ii][1]=mb_str_replace($keyword,"".$keyword."",$fullrow[$ii][1],"UTF-8");
$fullrow[$ii][2]="indexmain.php?mmenu=1-1-1&sum=".$row_product_kindc["infoid"];
$fullrow[$ii][3]=$row_product_kindc['infocate'];
$ii++;
$spos=$inpos+2;
}
//////////////////////////////////////////////////////
for ($mx=0;$mx".$row_product_kindc["infocate1"].$infoarray[$row_product_kindc["infocate"]]."=>".mb_substr($row_product_kindc[16],0,10,"UTF-8")."=>".mb_substr($row_product_kindc[10],$minpos,20,"UTF-8"));
$fullrow[$ii][1]=mb_str_replace($keyword,"".$keyword."",$fullrow[$ii][1],"UTF-8");
//if ($row_product_kindc["infocate"]==1)
//$fullrow[$ii][2]="indexmain.php?mmenu=1009";
//if ($row_product_kindc["infocate"]==2)
$fullrow[$ii][2]="indexmain.php?mmenu=".$infolinkarray[$row_product_kindc["infocate"]]."&sid=".$row_product_kindc["infoid"]."&cateid=".$row_product_kindc["infocate"];
//if ($row_product_kindc["infocate"]==3)
// $fullrow[$ii][2]="indexmain.php?mmenu=1819&sid=".$row_product_kindc["infoid"]."&cateid=".$row_product_kindc["infocate"];
$ii++;
$spos=$inpos+2;
// }
}
/////////////////////////////////////////////////////
$tp_index-> newBlock ( "tp_fulltext_count" ); // 瀏覽 block
$tp_index-> assign ( "tp_count" , $ii-1 ); // s_num
for ($vd=1;$vd<=count($fullrow);$vd++){
$tp_index-> newBlock ( "tp_fulltext_list" ); // 瀏覽 block
$tp_index-> assign ( "tp_fulltext" , $fullrow[$vd][1].".." ); // s_num
$tp_index-> assign ( "tp_fulltext_link" , $fullrow[$vd][2] ); // s_num
}
//print_r($fullrow);
}
function u_addposter() {
global $tp_index;
$tp_index-> newBlock ( "tp_p6_in_01" ); // 瀏覽 block
$tp_index-> assign ( "tp_action" , u_showproc().".php?mmenu=611"); // 連結資料
}
?>
|