This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
namespace App; | |
use Illuminate\Database\Eloquent\Model; | |
class Clientsoftwaremap extends Model | |
{ | |
/** | |
* 與模型關聯的資料表 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
JQuery 外掛:https://www.jstree.com/ | |
利用 npm bower 下載原始碼,或是整包 zip 下載解壓縮放至於 bower_components 管理。 | |
引入 CSS | |
<link rel="stylesheet" href="bower_components/jstree/dist/themes/default/style.min.css" /> | |
引入 Js | |
<script src="bower_components/jstree/dist/jstree.min.js"></script> | |
目的:以 Ajax 方式,讀取檔案樹子節點。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
資料如下 | |
group_id | group_name | parent_group_id | |
1 | admin | NULL | |
2 | test | NULL | |
3 | A | 1 | |
4 | a1 | 3 | |
5 | t1 | 2 | |
6 | me | 1 | |
// Get All group data |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--------------------------------- | |
輸出欄位的 distinct 值 | |
(1) $output = DB::table('table_name')->distinct()->get(array('column_name')) ; | |
(2) $output = DB::table('table_name')->select([DB::row('DISTINCT(column_name)'), 'some_col as new_col'])->distinct()->get(); | |
備註:輸出欄位為 new_col | |
--------------------------------- | |
where 的 AND 和 OR 寫法 | |
select id,mode FROM table_name WHERE id = 1 AND (mode = 1 OR mode = 3) | |
$data = DB::table('table_name')->where('id','=',1)->where(function ($query) { | |
$query->where('mode','=',1)->orWhere('mode','=',3) ; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
交易函數可以使用一個變數 | |
DB::transaction(function ($param) use ($param) { | |
$output = DB::table($param)->get(); | |
}) ; | |
以下範例是錯誤的 | |
DB::transaction(function ($p1,$p2,$p3) use ($p1,$p2,$p3) { | |
...code... | |
}) ; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[成功] | |
filter是要過濾的字串開頭 | |
var regrule = new RegExp('^'+filter, "g") ; | |
string.match(regrule) ; | |
[錯誤] | |
string.match(/^filter/) ; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
剛開始接觸 Laravel,第一個卡關的地方是路由的 post 設定,仔細研究官網文件後,終於成功了。 | |
以下提供 form post 及 ajax post 範例: | |
路由設定 | |
Route::post('testpost/', 'UserController@testpost'); | |
(1) form 表單 post | |
送出一個名字欄位至 testpost/ 頁面,因為 Laravel 為了防止跨網站的 post 請求, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
這兩個函數皆能走訪陣列所有元素 | |
(範例 1) JQuery 的物件,所以只能用 $.each(array, callback(index,element))。 | |
var arr = [] ; | |
var li = $("#id option") ; // 取出所有 option element | |
$.each(li, function(index, element){ | |
arr.push(element.innerHTML) ; // or element.outerText | |
}) ; | |
範例 1 備註: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Skype 4.3] | |
32 bits | |
sudo apt-get install gdebi | |
wget download.skype.com/linux/skype-ubuntu-precise_4.3.0.37-1_i386.deb | |
sudo gdebi skype-ubuntu-precise_4.3.0.37-1_i386.deb | |
64 bits | |
sudo dpkg --add-architecture i386 | |
sudo apt-get update | |
sudo apt-get install gdebi |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1.先至官方網站下載 iso 檔 | |
正體站:http://www.ubuntu-tw.org/modules/tinyd0/ (如果不行則去英文官方網站下載) | |
2.下載 Universal USB Installer (UUI) | |
http://www.pendrivelinux.com/universal-usb-installer-easy-as-1-2-3/#button | |
3.參考 UUI 步驟:http://www.ubuntu.com/download/desktop/create-a-usb-stick-on-windows | |
(1)先插入隨身碟 | |
(2)選擇 ubuntu -> 選擇 iso 檔 -> 選擇隨身碟槽 -> create |
NewerOlder