2015年1月15日 星期四

【PHP】較不常用的 array function 

$array1 = array('a','b','c','a');
$array2 = array('c','A','d','c');

// 相交(比對) Array ( [0] => c [3] => c ) 
$r1 = array_intersect($array2,$array1); 
// 結合 (第一個變數為key 第二個為value) Array ( [a] => c [b] => A [c] => d ) 
$r2 = array_combine($array1,$array2); 
// 出現次數 Array ( [a] => 2 [b] => 1 [c] => 1 )
$r3 = array_count_values($array1); 
// 不同 Array ( [0] => a [1] => b [3] => a )
$r4 = array_diff($array1,$array2); 
// 不同連key都要相同 Array ( [0] => a [1] => b [2] => c [3] => a )
$r5 = array_diff_assoc($array1,$array2); 
// 是否有 1 的 key 值
$r6 = array_key_exists('1',$array1); 
// 列出所有的key Array ( [0] => 0 [1] => 1 [2] => 2 [3] => 3 )
$r7 = array_keys($array2); 
// 結合陣列有相同的key會結合
$r8 = array_merge_recursive($array1,$array2); 
// 亂數抓key
$r9 = array_rand($array1); 
// 將值加入陣列
$r10 = array_push($array1,'d'); 
// 將value傳入function func($a,$b) 可傳多的值
$r11 = array_map("func",$array1,$array2); 
// 將key及value傳入function func($value,$key) 一個變數為key
$r12 = array_walk($array1,"func"); 
// 目前第一個值
$r13 = current($array1); 
// 指到下一個值
$r14 = next($array1); 
// 洗牌
$r15 = shuffle($array1);
張貼者： 於 沒有留言:
標籤：

2015年1月8日 星期四

【Jquery】jQuery TWzipcode 地址縣市選擇


twzipcode 地址選擇縣市郵遞區號工具
方便的工具，不用自己寫ajax 官網
$(function(){
  $('#addr').twzipcode({ // ID 名稱
        countySel: '桃園市', // 城市預設值
        districtSel: '平鎮區', // 地區預設值
        zipcodeSel:'324', // 郵遞區號預設值
        readonly:true,  // 郵遞區號唯獨
        css: ['county', 'district', 'zip'], // 個別的CSS 要另外自己寫
        countyName: 'bill_county', // 城市欄位名稱
        districtName: 'bill_district', // 地區欄位名稱
        zipcodeName: 'bill_zip' // 郵遞區號欄位名稱
  });
});
張貼者： 於 沒有留言:
標籤：

2014年12月18日 星期四

【PHP】PHP寄信 PHPMailer

1.一般寄信
※ $header 詳細說明: 連結

ini_set('SMTP','mail.threewell.com.tw');

$to ="wsxrtgvbuikm@gmail.com"; // 收件者
$subject = "發送測試"; //信件標題
$msg = '<!doctype html><html><head><meta charset="utf-8"></head><body><div style="background-color:#F00;color:#000" align="center">wsxrtgvbuikm@gmail.com</div></body></html>'; // 信件內容

$name = '賴俊銘'; // 寄件人
$sendMail = 'steven@threewell.com.tw'; // 寄件人信箱 要 smtp 允許的信箱

$headers  = "From: ".$name ."<".$sendMail.">". "\r\n"; // 寄件人資料
$headers .= "Content-Type: text/html; charset=utf-8; format=flowed". "\r\n"; // 編碼方式 有用到html要用text/html
$headers .= "MIME-Version: 1.0". "\r\n"; // MIME版本
$headers .= "Content-Transfer-Encoding: 8bit". "\r\n"; // 8位元ASCII碼。
$headers .= "X-Mailer: PHP". "\r\n"; // 哪邊發送的

if(mail($to, $subject, $msg, $headers)):
 echo '發送成功';
else:
 echo '發送失敗';
endif;
2.PHPMailer-master 使用套件
官網下載下載檔案 刪除多於檔案
  
ini_set('SMTP','mail.threewell.com.tw');

require 'PHPMailer-master/PHPMailerAutoload.php';

$mail = new PHPMailer;
$mail->setLanguage('zh'); // 設定語系 沒用的語言可刪掉
$mail->CharSet = 'UTF-8'; // 編碼
$mail->setFrom('steven@threewell.com.tw', '賴俊銘'); // 寄件人信箱及寄件人
$mail->addAddress('wsxrtgvbuikm@gmail.com', 'wsxrtgvbuikm'); // 收件人信箱及收件人
$mail->Subject = '信件標題'; // 標題
$mail->msgHTML('<a href="#">wsxrtgvbuikm</a>中文中文'); // 內容
$mail->addAttachment('HDT8GN.jpg'); // 附件 可多個
$mail->addAttachment('HDT8GN2.jpg');

if (!$mail->send()) {
    echo "寄信錯誤: " . $mail->ErrorInfo;
} else {
    echo "寄信成功";
}
張貼者： 於 沒有留言:
標籤：

2014年12月10日 星期三

【PHP】串接 Yahoo 商城 API


1.API 文件
網址:
http://tw.ews.mall.yahooapis.com/handbook_v2/webservice_guide/index.html
這份文件用google搜尋就可以找到
2.準備
首先要向 yahoo 提出申請 API，申請成功後會拿到 API Key 和 Secret，
API Key 就像帳號一樣，Shared Secret 是將資料編碼。
3.製作簽章及使用API
製作簽章的方法在 Yahoo API 文件就有說明，
直接來實作抓取 Yahoo 商城分類，
在文件中找到 API > Product API > /v1/MallCategory/Get
固定的網址是 http://tw.ews.mall.yahooapis.com/stauth (後面加上功能名稱)
YahooAPI class
/* 
 * @author wsxrtgvbuikm@gmail.com
 * 首先要先 define 以下幾個變數:
 * 1.YAHOO_API_KEY : YAHOO申請的KEY
 * 2.YAHOO_API_SECRET : YAHOO申請的SECRET
 * 3.YAHOO_API_ID : YAHOO的帳號 (測試過其實亂打都過)
 * 4.YAHOO_API_NAME : YAHOO的名稱 (通常是中文)
 * 5.YAHOO_API_URL : http://tw.ews.mall.yahooapis.com/stauth
 */
header("Content-Type: text/html; charset=utf-8");
define('YAHOO_API_KEY','輸入API KEY');
define('YAHOO_API_SECRET','輸入API_SECRET');
define('YAHOO_API_ID','輸入ID');
define('YAHOO_API_NAME','輸入名稱');
define('YAHOO_API_URL','http://tw.ews.mall.yahooapis.com/stauth');

class YahooAPI {
  public function yahoo_api($url,$arr=array(),$other_val=array()){
    $url = YAHOO_API_URL.$url;
    
    $auth_arr = array('ApiKey'=>YAHOO_API_KEY,
                       'TimeStamp'=>time(),
                       'Id'=>YAHOO_API_ID,
                       'Name'=>YAHOO_API_NAME,
                       'Format'=>'json'
                       );
    $request_arr = array_merge($auth_arr,$arr);
    
    // 會有編碼的問題所以用foreach
    //$request = urldecode(http_build_query($request_arr));

    $request = '';
    foreach($request_arr as $key=>$val){
      $request .= $key.'='.$val.'&';
    }
    $request = substr($request,0,-1);
    // $request用SECRET sha1加密
    $signature = hash_hmac('sha1',$request,YAHOO_API_SECRET);
    $request_arr['Signature'] = $signature;
    
    // 加入其他參數像是上傳圖片就不包含在加密範圍
    $request_arr = array_merge($request_arr,$other_val);
    
    $this->request = $request_arr;
    
    $r = $this->curl_file_get_contents($url,$request_arr);
    $arr = json_decode($r,true);
    
    return $arr;
  }  

  public function curl_file_get_contents($url,$request){
    $ch = curl_init();
    $timeout = 5; 
    
    $cookie = "cookieLangId=zh_tw;";
    curl_setopt ($ch, CURLOPT_COOKIE, $cookie);
    
    curl_setopt($ch, CURLOPT_ENCODING, "UTF-8");
    
    curl_setopt ($ch, CURLOPT_URL, $url);
    curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
    curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    curl_setopt ($ch, CURLOPT_POST, true); // 啟用POST
    curl_setopt ($ch, CURLOPT_POSTFIELDS, $request); 
    curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, true);
    
    $r = curl_exec($ch);
    
    curl_close($ch);
  
    return $r;
  }
}
取得分類
include("YahooAPI.php");
$Yahoo = new YahooAPI();

// 取得 YAHOO 商城分類
$url = '/v1/MallCategory/Get';
$arr = array('CategoryId'=>$CategoryId);
$r = $Yahoo->yahoo_api($url,$arr);
print_r($r);
上傳商品範例
在文件上有標記(Require)一定要填，
有些是要用API先去查代碼，其他(Optional)沒有傳值就不要出現不然會失敗.. 
$url = '/v2/Product/SubmitMain';
$arr = array('SaleType'=>'Normal', // 商品銷售方式
          'SaleTypeInfo'=>'Normal', // 商品銷售資訊
          'ProductName'=>$rs['NAME'], // 商品名稱
          'MallCategoryId'=>$rs['YAHOO_CAT'], // 商城商品分類代號
          'StoreCategoryId'=>$rs['YAHOO_STORE_CAT'], // 商品歸類
          'MarketPrice'=>$rs['MARKET_PRICE'], // 商品市價
          'SalePrice'=>$rs['PRICE'], // 網路價
          'CostPrice'=>$rs['COST'], // 成本價
          'MaxBuyNum'=>$rs['LIMIT_NUM'], // 最高購買數量
          'ShortDescription'=>$rs['DESC'], // 商品簡述
          'LongDescription'=>$rs['CONTENT'], // 商品介紹
          'PayTypeId'=>'1', // 付款方式代號
          'PayTypeId'=>'2', // 付款方式代號
          'PayTypeId'=>'4', // 付款方式代號
          'PayTypeId'=>'8', // 付款方式代號
          'PayTypeId'=>'9', // 付款方式代號
          'PayTypeId'=>'10', // 付款方式代號
          'ShippingId'=>'1', // 物流方式代號
          'ShippingId'=>'2', // 物流方式代號
          'IsTaxFree'=>'0', // 此商品是否為免稅商品
          'SpecTypeDimension'=>'0', // 商品規格
          'CustomizedMainProductId'=>$rs['PRODUCT_ID'], // 商品主貨號
          'Stock'=>$rs['STOCK'], // 商品庫存量 
          'SaftyStock'=>$rs['SAFYSTOCK'], // 商品庫存最低警告量
             
           );
$return = $Yahoo->yahoo_api($url,$arr);
上傳圖片
$url = '/v1/Product/UploadImage';
$arr = array('ProductId'=>$productId, // 商品ID
             'MainImage'=>'ImageFile1', // 第一張圖 可一次傳多張
             'Purge'=>'true' // 是否保留原圖
             );
             
// 商品圖系統路徑 - 因為這個不加入簽章所以要另外放
// 前面加上@ CURL 就會當成檔案上傳
$request_arr['ImageFile1'] = '@'.HTTP_REAL_PATH.$rs['IMAGE'];
$return = $this->yahoo_api($url,$arr,$request_arr);
張貼者： 於
標籤：

2014年11月11日 星期二

【PHP】phpExcel範例 

require_once("PHPExcel.php");
 $objPHPExcel = new PHPExcel();
 $objPHPExcel->getProperties()->setTitle(" List");
 $objPHPExcel->getProperties()->setCategory(" List");
 $objPHPExcel->setActiveSheetIndex(0);
 
 $objPHPExcel->getActiveSheet()->setCellValue('A1', '商品編號');
 $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(13);
 $objPHPExcel->getActiveSheet()->setCellValue('B1', '商品名稱');
 $objPHPExcel->getActiveSheet()->setCellValue('C1', '醒目標題');
 $objPHPExcel->getActiveSheet()->setCellValue('D1', '頁面標題');
 $objPHPExcel->getActiveSheet()->setCellValue('E1', '頁面關鍵字');
 $objPHPExcel->getActiveSheet()->setCellValue('F1', '頁面描述');
 $objPHPExcel->getActiveSheet()->setCellValue('G1', '中類屬性');
 $objPHPExcel->getActiveSheet()->setCellValue('H1', '小類屬性');
 $objPHPExcel->getActiveSheet()->setCellValue('I1', '市價');
 $objPHPExcel->getActiveSheet()->setCellValue('J1', '售價');
 $objPHPExcel->getActiveSheet()->setCellValue('K1', '成本');
 $objPHPExcel->getActiveSheet()->setCellValue('L1', '庫存數');
 $objPHPExcel->getActiveSheet()->setCellValue('M1', '安全庫存數');
 $objPHPExcel->getActiveSheet()->setCellValue('N1', '上架日');
 $objPHPExcel->getActiveSheet()->setCellValue('O1', '下架日');
 $objPHPExcel->getActiveSheet()->setCellValue('P1', '商品介紹');
 $objPHPExcel->getActiveSheet()->setCellValue('Q1', '功能一標題');
 $objPHPExcel->getActiveSheet()->setCellValue('R1', '功能一內容');
 $objPHPExcel->getActiveSheet()->setCellValue('S1', '功能二標題');
 $objPHPExcel->getActiveSheet()->setCellValue('T1', '功能二內容');
 $objPHPExcel->getActiveSheet()->setCellValue('U1', '功能三標題');
 $objPHPExcel->getActiveSheet()->setCellValue('V1', '功能三內容');
 $objPHPExcel->getActiveSheet()->setCellValue('W1', '功能四標題');
 $objPHPExcel->getActiveSheet()->setCellValue('X1', '功能四內容');
 $objPHPExcel->getActiveSheet()->setCellValue('Y1', '功能五標題');
 $objPHPExcel->getActiveSheet()->setCellValue('Z1', '功能五內容');
 $objPHPExcel->getActiveSheet()->setCellValue('AA1', '功能六標題');
 $objPHPExcel->getActiveSheet()->setCellValue('AB1', '功能六內容');
 $objPHPExcel->getActiveSheet()->setCellValue('AC1', '功能七標題');
 $objPHPExcel->getActiveSheet()->setCellValue('AD1', '功能七內容');
 $objPHPExcel->getActiveSheet()->setCellValue('AE1', '功能八標題');
 $objPHPExcel->getActiveSheet()->setCellValue('AF1', '功能八內容');
 $objPHPExcel->getActiveSheet()->setCellValue('AG1', '商品圖片');

 $i = 1;
 foreach($datas['data'] as $rs)
 {
  $i++;
  $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $a);
  $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $b);
  $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $c);
  $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $d);
  $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $e);
  $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $f);
  $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $g);
  $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $h);
  $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $i);
  $objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $j);
  $objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $k);
  $objPHPExcel->getActiveSheet()->setCellValue('L'.$i, $l);
  $objPHPExcel->getActiveSheet()->setCellValue('M'.$i, $m);
  $objPHPExcel->getActiveSheet()->setCellValue('N'.$i, $n);
  $objPHPExcel->getActiveSheet()->setCellValue('O'.$i, $o;
  $objPHPExcel->getActiveSheet()->setCellValue('P'.$i, $p);
  $objPHPExcel->getActiveSheet()->setCellValue('Q'.$i, $q);
  $objPHPExcel->getActiveSheet()->setCellValue('R'.$i, $r);
  $objPHPExcel->getActiveSheet()->setCellValue('S'.$i, $s);
  $objPHPExcel->getActiveSheet()->setCellValue('T'.$i, $t);
  $objPHPExcel->getActiveSheet()->setCellValue('U'.$i, $u);
  $objPHPExcel->getActiveSheet()->setCellValue('V'.$i, $v);
  $objPHPExcel->getActiveSheet()->setCellValue('W'.$i, $w);
  $objPHPExcel->getActiveSheet()->setCellValue('X'.$i, $x);
  $objPHPExcel->getActiveSheet()->setCellValue('Y'.$i, $y);
  $objPHPExcel->getActiveSheet()->setCellValue('Z'.$i, $z);
  $objPHPExcel->getActiveSheet()->setCellValue('AA'.$i, $aa);
  $objPHPExcel->getActiveSheet()->setCellValue('AB'.$i, $ab);
  $objPHPExcel->getActiveSheet()->setCellValue('AC'.$i, $ac);
  $objPHPExcel->getActiveSheet()->setCellValue('AD'.$i, $ad);
  $objPHPExcel->getActiveSheet()->setCellValue('AE'.$i, $ae);
  $objPHPExcel->getActiveSheet()->setCellValue('AF'.$i, $af);
  $objPHPExcel->getActiveSheet()->setCellValue('AG'.$i, $ag);
 }


 // OUTPUT
 header('Content-Type: application/vnd.ms-excel');
 header('Content-Disposition: attachment;filename="output'.date("YmdHis").'.xls"');
 header('Cache-Control: max-age=0');
 
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
 $objWriter->save('php://output');







實用筆記整理

error_reporting(E_ALL);
date_default_timezone_set(‘Asia/Taipei’);
/** PHPExcel */
require_once ‘Classes/PHPExcel.php';
// 新增Excel物件
$objPHPExcel = new PHPExcel();
// 設定屬性
$objPHPExcel->getProperties()->setCreator(“PHP")
->setLastModifiedBy(“PHP")
->setTitle(“Title")
->setSubject(“Subject")
->setDescription(“Description")
->setKeywords(“Keywords")
->setCategory(“Category");
//設定操作中的工作表
$objPHPExcel->setActiveSheetIndex(0);
//將工作表命名
$objPHPExcel->getActiveSheet(0)->setTitle(‘第一張表’);
//合併儲存格
$objPHPExcel->getActiveSheet(0)->mergeCells(‘A1:D2′);
//儲存格內容
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A1′,’PHPEXCEL TEST’); //合併後的儲存格，設定時指定左上角那個。
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D3′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C4′,’test’);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘D4′,’test’);
//設定背景顏色單色
$objPHPExcel->getActiveSheet(0)->getStyle(‘A3:D3′)->applyFromArray(
array(‘fill’     => array(
‘type’ => PHPExcel_Style_Fill::FILL_SOLID,
‘color’ => array(‘argb’ => ‘D1EEEE’)
),
)
);
//設定漸層背景顏色雙色(灰/白)   經測試，Excel2007才有漸層
$objPHPExcel->getActiveSheet(0)->getStyle(‘A1:D2′)->applyFromArray(
array(
‘font’   => array(‘bold’ => true,
‘size’ => ’24’),
‘alignment’ => array(‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER),
‘borders’  => array(‘top’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘fill’   => array(‘type’ => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR,
‘rotation’   => 90,
‘startcolor’ => array(‘rgb’ => ‘DCDCDC’),
‘endcolor’   => array(‘rgb’ => ‘FFFFFF’))
));
//框線 方法一：使用 setBorderStyle() 函數
$objPHPExcel->getActiveSheet(0)->getStyle(‘A5′)->getBorders()->getTop()  ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B5′)->getBorders()->getBottom() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C5′)->getBorders()->getleft() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘D5′)->getBorders()->getright() ->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A7:C10′)->getBorders()->getAllborders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//框線 方法二：使用applyFromArray()函數
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’),
),
),
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
//框線 方法三：使用物件 + applyFromArray()函數
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, ‘E7:G10′);
//斜線  方法一
$styleArray = array(‘borders’ => array(‘diagonal’ => array(‘style’ => PHPExcel_Style_Border::BORDER_THICK,
‘color’ => array(‘argb’ => ‘FFFF0000′),
),
‘diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_UP
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_DOWN
//’diagonaldirection’ => PHPExcel_Style_Borders::DIAGONAL_BOTH
),
);
$objPHPExcel->getActiveSheet()->getStyle(“E1″)->applyFromArray($styleArray);
//斜線  方法二
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->getDiagonal()->applyFromArray(array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘FFFF0000′)
)
);
$objPHPExcel->getActiveSheet()->getStyle(‘F1′)->getBorders()->setDiagonalDirection(PHPExcel_Style_Borders::DIAGONAL_DOWN);
/*
註：
PHPExcel_Style_Borders::DIAGONAL_UP
PHPExcel_Style_Borders::DIAGONAL_DOWN
PHPExcel_Style_Borders::DIAGONAL_BOTH
*/
//設定一個範圍後套用相同格式
$objPHPExcel->getActiveSheet(0)->mergeCells(‘E12:F13′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘E12′,"Hello \n World");
$style_obj = new PHPExcel_Style();
$style_array = array( ‘borders’ => array(‘allborders’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)),
‘alignment’ => array(‘wrap’=> true,
‘horizontal’ => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
‘vertical’ => PHPExcel_Style_Alignment::VERTICAL_CENTER
),
‘font’ => array(‘size’ => ‘8’)
);
$style_obj->applyFromArray($style_array);
$objPHPExcel->getActiveSheet(0)->setSharedStyle($style_obj, “E12:G14″);
//設定字型(粗細、顏色)  也可參照上面的方法，用陣列的方式設定。
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setName(‘Candara’);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setSize(16);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE); //藍色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //紅色
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getFont()->getColor()->setARGB(‘FF0000′); //紅色
$objPHPExcel->getActiveSheet(0)->setCellValue(‘G2′, ‘2008-12-31′);
$objPHPExcel->getActiveSheet(0)->getStyle(‘G2′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);
/*
註：這裡有列出可用英文單字表示的顏色，並不多。
COLOR_BLACK
COLOR_BLUE
COLOR_DARKBLUE
COLOR_DARKGREEN
COLOR_DARKRED
COLOR_DARKYELLOW
COLOR_GREEN
COLOR_RED
COLOR_WHITE
COLOR_YELLOW
*/
//使用函數
$objPHPExcel->getActiveSheet(0)->setCellValue(‘A5′,’3′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘B5′,’4′);
$objPHPExcel->getActiveSheet(0)->setCellValue(‘C5′, ‘=SUM(A5:B5)’);
//設定A3內容為00123，並指定為文字型態。這樣在顯示的時候不會自動把0去掉。$objPHPExcel->getActiveSheet(0)->getCell(“A4″)->setValueExplicit(‘00123′, PHPExcel_Cell_DataType::TYPE_STRING);
//分離儲存格
//$objActSheet->unmergeCells(‘B1:C22′);
//設定欄寬
$objPHPExcel->getActiveSheet(0)->getColumnDimension(‘A’)->setWidth(20);
//設定欄寬(自動欄寬)
//$objPHPExcel->getActiveSheet(0)->getColumnDimension(“A")->setAutoSize(true);
//設定高度
$objPHPExcel->getActiveSheet(0)->getRowDimension(‘1′)->setRowHeight(150);
//下底線
$objPHPExcel->getActiveSheet(0)->getStyle(“D3″)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
//旋轉文字
$objPHPExcel->getActiveSheet(0)->getStyle(‘A4′)->getAlignment()->setTextRotation(-90);
//對齊  //注意是 setVertiacl 還是 setHorizontal
$objPHPExcel->getActiveSheet(0)->getStyle(‘B4′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet(0)->getStyle(‘C4′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
/*
VERTICAL_CENTER 垂直置中
VERTICAL_TOP
HORIZONTAL_CENTER
HORIZONTAL_RIGHT
HORIZONTAL_LEFT
HORIZONTAL_JUSTIFY
*/
//add comment ———————————————–
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setAuthor(‘PHPExcel’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment1 comment1 comment1 ‘);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setWidth(‘200pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setHeight(‘100pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->setMarginLeft(‘150pt’);
$objPHPExcel->getActiveSheet()->getComment(‘A6′)->getFillColor()->setRGB(‘dea66e’); //背景顏色
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment(‘A6′)->getText()->createTextRun(‘comment2 comment2 comment2 ‘);
$objCommentRichText->getFont()->setBold(true); //文字加粗
$objCommentRichText->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); //文字顏色
———————————————————————————–
———————————————————————————–
// 設定格式：使用物件的方式
$style_obj = new PHPExcel_Style();
$styleArray = array(‘borders’ => array(‘left’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THICK),
‘top’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘right’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN),
‘bottom’=> array(‘style’ => PHPExcel_Style_Border::BORDER_THIN)
));
$style_obj->applyFromArray($styleArray);
$letter = PHPExcel_Cell::stringFromColumnIndex(0); //A
$cellname1 = $letter.’1′; // A1
$cellname2 = $letter.7;  // A7
$cell_range = “$cellname1:$cellname2″;
$sheet->setSharedStyle($style_obj, “$cell_range");
// 設定格式：使用陣列
$styleArray = array(
‘borders’ => array(
‘allborders’ => array(
‘style’ => PHPExcel_Style_Border::BORDER_THIN,
‘color’ => array(‘argb’ => ‘000000’)
),
),
‘font’   => array(‘bold’ => true,
‘size’ => ’12’,
‘color’ => array(‘argb’ => ‘FF0000′)
)
);
$objPHPExcel->getActiveSheet(0)->getStyle(‘A12:C15′)->applyFromArray($styleArray);
// 註解
$comment = “This is comment";
$sheet->getComment(“F1″)->getFillColor()->setRGB(‘FFFAD9′); //背景顏色
$sheet->getComment(“F1″)->setWidth(‘320pt’);
$objCommentRichText = $sheet->getComment(“F1″)->getText()->createTextRun(“$comment");
$objCommentRichText->getFont()->getColor()->setRGB(‘008080′); //文字顏色
$objCommentRichText->getFont()->setBold(true); //文字加粗
———————————————————————————–
// 設定其它工作表
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle(‘第二張表’);
$objPHPExcel->getActiveSheet()->setCellValue(‘A3′,"test1″);
$objPHPExcel->getActiveSheet()->setCellValue(‘B3′,’test2′);
$objPHPExcel->setActiveSheetIndex(0);
//若要在 2003 跟 2007 之間切換，選然下面兩段其中一段即可。
//Excel 2007
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’);
header(‘Content-Disposition: attachment;filename="01simple.xlsx"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007′);
/*
//Excel 2003
header(‘Content-Type: application/vnd.ms-excel’);
header(‘Content-Disposition: attachment;filename="01simple.xls"‘);
header(‘Cache-Control: max-age=0′);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5′); //Excel 2003 = Excel 5
*/
//========================================================
$objWriter->save(‘php://output’);
exit;
張貼者： 於 沒有留言:
標籤：

2014年11月3日 星期一

【jquery】post 使用 json 傳值

post 使用 json 傳值
js
$.post("userorder_v2.php",{mod:'detail',orderid:$orderid},function ($data){
// 判斷CSS是否要隱藏
for($key in $data.data){
  if (!$data.data[$key]){
    $("#ar-"+$key).hide();
  }else{
    $("#ar-"+$key).show();
  }
  
  $thisValue = $(".od-" + $key);

  // 加上另外的處理
  if ($thisValue.hasClass("plus")){ // +
    $data.data[$key] = '+'+$data.data[$key];
  }else if ($thisValue.hasClass("less")){
    $data.data[$key] = '-'+$data.data[$key];
  }
  
  // 將值放入對應的CSS中
  $thisValue.html($data.data[$key]);
}
},"json");
HTML:

<table border="0" cellspacing="2" cellpadding="5" width="760">
	<tr>
		<th colspan="4" align="center">訂單資料</th>
	</tr>
	<tbody>
	<tr>
		<td width="100" align="center">訂單編號</td>
		<td width="200" class="od-orderid"></td>
		<td width="100" align="center">付款方式</td>
		<td class="od-payWayName"></td>
	</tr>
	<tr>
		<td align="center">訂單金額</td>
		<td class="od-order_total"></td>
		<td align="center">取貨方式</td>
		<td class="od-get_goods_name"></td>
	</tr>
	<tr>
		<td align="center">訂單日期</td>
		<td class="od-order_time"></td>
		<td align="center"><span id="ar-identity">訂購身分</span></td>
		<td class="od-identity"></td>
	</tr>
	<tr>
		<td align="center">訂單狀態</td>
		<td colspan="3" class="od-shipName"></td>
	</tr>
	<tr>
		<td align="center">收貨地址</td>
		<td colspan="3" class="od-address"></td>
	</tr>
	<tr>
		<td align="center">gt;備註</td>
		<td colspan="3" class="od-comp_note"></td>
	</tr>
	</tbody>
</table>
張貼者： 於 沒有留言:
標籤：

2014年10月8日 星期三

【CSS】顯示表格空白(empty-cells)、框線合併(border-collapse)

empty-cells
empty-cells:show -> 顯示空白表格
empty-cells:hide -> 不顯示空白表格 - 預設
empty-cells:inherit -> 繼承父屬性
1 2
3
border-collapse
border-collapse:collapse -> 框限線會合併
border-collapse:separate -> 框線分開
1 2
3 
<style>
#wsxrtgvbuikm14010082 .t1{
	color:#1A6811;
	font-family: "微軟正黑體";
	font-size:24px;
	padding: 0 10px;
}

#wsxrtgvbuikm14010082 .t2{
	color:#1F1C97;
	font-family: "微軟正黑體";
	font-size:16px;
	padding: 0 10px;
	margin-top:8px;
	margin-bottom:8px;
}

#wsxrtgvbuikm14010082 .t3{
	color:#000;
	font-family: "微軟正黑體";
	font-size:16px;
	padding: 0 5px;	
}

#wsxrtgvbuikm14010082 .table-1 {
	width:300px;
	margin-left:10px;
}

#wsxrtgvbuikm14010082 .table-1 td{
	border:1px solid #0088dd;
	padding:15px;
	empty-cells:hide;
	
}

#wsxrtgvbuikm14010082 .table-2 {
	width:300px;
	border-collapse:collapse;
	margin-left:10px;
}

#wsxrtgvbuikm14010082 .table-2 td{
	border:1px solid #0088dd;
	padding:15px;
	empty-cells:hide;
	
}
</style>
<div id="wsxrtgvbuikm14010082">
  <div class="t1">empty-cells</div>
  <div class="t2">empty-cells:show -> 顯示空白表格</div>
  <div class="t2">empty-cells:hide -> 不顯示空白表格 - 預設</div>
  <div class="t2">empty-cells:inherit -> 繼承父屬性</div>
  <div>
    <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table-1">
      <tr>
        <td>1</td>
        <td>2</td>
      </tr>
      <tr>
        <td>3</td>
        <td></td>
      </tr>
    </table>
  </div>
  
  <div class="t1" style="margin-top:30px;">border-collapse</div>
  <div class="t2">border-collapse:collapse -> 框限線會合併</div>
  <div class="t2">border-collapse:separate -> 框線分開</div>
  <div>
    <table width="100%" border="1" cellspacing="0" cellpadding="0" class="table-2">
      <tr>
        <td>1</td>
        <td>2</td>
      </tr>
      <tr>
        <td>3</td>
        <td></td>
      </tr>
    </table>
  </div>
張貼者： 於 沒有留言:
標籤：

【CSS】list-style-position

項目符號的位置:list-style-position
list-style-position:outside -> 不縮排
list-style-position:inherit -> 如果有第二排會縮排 預設值
  • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
  • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
  • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
    • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
    • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
    • SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC
      
// CSS
.demo{
 width:300px;
 margin:0px;
 padding-left:30px;
 list-style-position:inside;
}

.demo li{
 margin-top:10px;
 list-style:circle;
}

ul.demo2{ /* 一定要用ul的樣子 */
 width:300px;
 list-style-position:outside;
 margin:0px;
 padding-left:30px;
 padding-top:30px;
}

.demo2 li{
 margin-top:10px;
 list-style:circle;
}

// HTML
<div class="demo">
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
</div>

<ul class="demo2">
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
  <li>SELECT TOP 20 text FROM sys.dm_exec_query_stats as qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st ORDER BY qs.creation_time DESC</li>
</ul>
    張貼者： 於 沒有留言:
    標籤： ,

    2014年9月17日 星期三

    【SQL】if else


    基本
    PHP
       if ($score >= 90)
     $str = 'A';
    elseif ($score >= 70 && $score < 90) 
     $str = 'B';
    elseif ($score >= 60 && $score < 70) 
     $str = 'C';  
    else{
     $str = 'D';  
    }
    SQL
       CASE  
     WHEN score >= 90 THEN 'A'
      WHEN score >= 90 THEN 'B'
      WHEN score >= 90 THEN 'C'
      ELSE 'D'
    END AS str
    欄位值
    Name Answer
    張一 1
    王二 2
    李三 3 

        SELECT Name, 
     case Answer
       when 1 then '喜歡'
       when 2 then '不喜歡'
       when 3 then '一般'
      END
    FROM table;
    
    OR
    
    SELECT Name, 
     case
       when Answer=1 then '喜歡'
       when Answer=2 then '不喜歡'
       when Answer=3 then '一般'
      END AS Answer
      FROM table;
    張貼者： 於 沒有留言:
    標籤： ,

    2014年8月27日 星期三

    【MySQL】LIKE 搜尋


    一、一般
    1.name LIKE '豬%' -> 找豬開頭的文字後面不論字數，例如:豬八戒、豬頭
    2.name LIKE '%豬%' -> 只有出現豬就算找到，如豬、神豬、豬頭
    3.name LIKE '豬_' -> 限定字數只找豬開頭兩個字，底線在那邊就一定要有字
    4.name LIKE '%豬%戒%' -> 只要字串包含順序有豬跟界就符合
    二、應用搜尋
    
// 將字切開並加上%
$arr = $this->utf8_str_split($keywords);
$keywordSplit = implode('%',$arr);

// 這樣比 '%$keywords%' 搜尋到更多結果
$sql = "SELECT * FROM user WHERE name LIKE '%$keywordSplit%'";  
$rs = $pdo->query($sql);

// 用UTF8切文字  
function utf8_str_split($str, $split_len = 1){
 if (!preg_match('/^[0-9]+$/', $split_len) || $split_len < 1)
   return FALSE;

 $len = mb_strlen($str, 'UTF-8');
 if ($len <= $split_len)
   return array($str);

 preg_match_all('/.{'.$split_len.'}|[^\x00]{1,'.$split_len.'}$/us', $str, $ar);

 return $ar[0];
}
    張貼者： 於 沒有留言:
    標籤： ,
    訂閱： 意見 (Atom)