Monthly Archives: July 2013

Split Chinese String

$cell = mb_substr(strip_tags($cell),0,30,"UTF-8");

1	$cell = mb_substr(strip_tags($cell),0,30,"UTF-8");

http://blog.xuite.net/chenbruse/bruse/13351768-%E8%A7%A3%E6%B1%BAPHP+substr%E5%88%87%E5%89%B2%E4%B8%AD%E6%96%87%E5%AD%97%E5%95%8F%E9%A1%8C

curl – Send session cookies

$strCookie = &#39;PHPSESSID=&#39; . $_COOKIE['PHPSESSID'] . &#39;; path=/&#39;;
session_write_close();

$request = array(
	//CURLOPT_HTTPHEADER =&gt; array(&#39;Content-type: application/x-www-form-urlencoded&#39;), 
    //CURLOPT_POST =&gt; false, 
	CURLOPT_USERAGENT =&gt; &#39;Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17&#39;, 
	CURLOPT_AUTOREFERER =&gt; true, 
	CURLOPT_FOLLOWLOCATION =&gt; true, 
	CURLOPT_SSL_VERIFYPEER =&gt; false, 
    CURLOPT_POSTFIELDS =&gt; http_build_query($params), 
	CURLOPT_COOKIE =&gt; $strCookie, 
    CURLOPT_RETURNTRANSFER =&gt; false //Important!
);

$strCookie = 'PHPSESSID=' . $_COOKIE['PHPSESSID'] . '; path=/';

session_write_close();

$request = array(

//CURLOPT_HTTPHEADER => array('Content-type: application/x-www-form-urlencoded'),

//CURLOPT_POST => false,

CURLOPT_USERAGENT => 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17',

CURLOPT_AUTOREFERER => true,

CURLOPT_FOLLOWLOCATION => true,

CURLOPT_SSL_VERIFYPEER => false,

CURLOPT_POSTFIELDS => http_build_query($params),

CURLOPT_COOKIE => $strCookie,

CURLOPT_RETURNTRANSFER => false //Important!

);

http://www.smooka.com/blog/2009/07/24/maintaining-php-session-when-using-curl/

Table Example

<table id="data_table" class="table">
	<thead>
		<tr>
			<th></th>
			<th></th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td></td>
			<td></td>
		</tr>
	</tbody>
</table>

<thead>

<tr>

</tr>

</thead>

<tbody>

<tr>

</tr>

</tbody>

</table>

Get Current File Name

basename($_SERVER['PHP_SELF']);

1	basename($_SERVER['PHP_SELF']);

This works even in included page

“use” operator

The use operator is for giving aliases to names of classes

jQuery Form Plugin Example (Deprecated)

Official Site: http://malsup.com/jquery/form/

Notices:

If ajaxForm() or ajaxSubmit() not working:
Check if include jQuery twice
Disable browser validation:
Add “novalidate” in <form>

Form HTML:

<form id="register_form" name="register_form" action="<?=base_url()?>index.php/api/member/register" method="post"  enctype="multipart/form-data" novalidate>
    Name: <input type="text" name="name" /> 
    Comment: <textarea name="comment"></textarea> 
    <input type="submit" value="Submit Comment" /> 
</form>

<form id="register_form" name="register_form" action="<?=base_url()?>index.php/api/member/register" method="post" enctype="multipart/form-data" novalidate>

Name: <input type="text" name="name" />

Comment: <textarea name="comment"></textarea>

</form>

Javascript:

$(document).ready(function(){
    form_funs.init();

});

var form_funs = {
    get_form: function(){
        return $('#register_form');
    },
    init: function(){
        var wrap = this;
        var $form = wrap.get_form();
        var $select_field = $form.find('.file_field');
        var $select_button = $form.find('.select_button');

        wrap.init_form();

        $select_button.on('click', function(e){
            e.preventDefault();
            $select_field.trigger('click');
        });
    },
    init_form: function(){
        var wrap = this;
        var $form = wrap.get_form();
        var $submit_button = $form.find('.bt_submit');

        $submit_button.on('click', function(e){
            e.preventDefault();
            $form.submit();
        });

        $form.submit(function() { 
            $(this).ajaxSubmit({
                beforeSubmit: function(arr, $form, options) {
                    var result = wrap.validate(arr, $form);
                    return result;
                }, 
                data: {

                }, 
                success: function(data, statusText, xhr, $form) { 
                    if(data.status == 'success'){
                        window.location.href = base_url + 'index.php/competition/upload';
                    }else{
                        alert(data.message);
                    }
                }, 
                error: function(){
                    alert("ERROR");
                }
            }); 
     
            return false; 
        });
    }, 
    validate: function(arr, $form){
        var wrap = this;

        for(var i = 0; i < arr.length; i++){
            var obj = arr[i];
            if(obj.type == 'textarea'){
                var $e = $('#' + obj.name);
                if($e.hasClass('ckeditor') == true){
                    //arr[i].value = get_cke(obj.name);
                }
            }

            if(obj.required == true && (obj.value == null || obj.value == '')){
                var $field = $('input[name="' + obj.name + '"]');
                var label = $field.attr('title');

                if(typeof label == 'undefined' || label == null){
                    alert('Please enter all fields.');
                }else{
                    alert('Please enter ' + label);
                }
                
                $field.focus();
                return false;
            }
        }

        if(wrap.validate_password() == false){
            return false;
        }

        return true;
    }, 
    validate_password: function(){
        var wrap = this;
        var $form = wrap.get_form();
        var $pw1 = $form.find('input[name="passwd"]');
        var $pw2 = $form.find('input[name="confirm_passwd"]');
        var length_limit = 5;

        if($pw1.val().length < length_limit){
            alert('密碼長度至少要5個字元');
            $pw1.focus();
            return false;
        }

        if($pw1.val() != $pw2.val()){
            alert('請確認輸入相同的密碼');
            $pw2.focus();
            return false;
        }

        return true;
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

$(document).ready(function(){

form_funs.init();

});

var form_funs = {

get_form: function(){

return $('#register_form');

init: function(){

var wrap = this;

var $form = wrap.get_form();

var $select_field = $form.find('.file_field');

var $select_button = $form.find('.select_button');

wrap.init_form();

$select_button.on('click', function(e){

e.preventDefault();

$select_field.trigger('click');

});

init_form: function(){

var wrap = this;

var $form = wrap.get_form();

var $submit_button = $form.find('.bt_submit');

$submit_button.on('click', function(e){

e.preventDefault();

$form.submit();

});

$form.submit(function() {

$(this).ajaxSubmit({

beforeSubmit: function(arr, $form, options) {

var result = wrap.validate(arr, $form);

return result;

data: {

success: function(data, statusText, xhr, $form) {

if(data.status == 'success'){

window.location.href = base_url + 'index.php/competition/upload';

}else{

alert(data.message);

}

error: function(){

alert("ERROR");

}

});

return false;

});

validate: function(arr, $form){

var wrap = this;

for(var i = 0; i < arr.length; i++){

var obj = arr[i];

if(obj.type == 'textarea'){

var $e = $('#' + obj.name);

if($e.hasClass('ckeditor') == true){

//arr[i].value = get_cke(obj.name);

}

if(obj.required == true && (obj.value == null || obj.value == '')){

var $field = $('input[name="' + obj.name + '"]');

var label = $field.attr('title');

if(typeof label == 'undefined' || label == null){

alert('Please enter all fields.');

}else{

alert('Please enter ' + label);

}

$field.focus();

return false;

}

if(wrap.validate_password() == false){

return false;

}

return true;

validate_password: function(){

var wrap = this;

var $form = wrap.get_form();

var $pw1 = $form.find('input[name="passwd"]');

var $pw2 = $form.find('input[name="confirm_passwd"]');

var length_limit = 5;

if($pw1.val().length < length_limit){

alert('密碼長度至少要5個字元');

$pw1.focus();

return false;

}

if($pw1.val() != $pw2.val()){

alert('請確認輸入相同的密碼');

$pw2.focus();

return false;

}

return true;

}

IPN Listener

&lt;?php
require_once(&#39;../includes/init_page_public.php&#39;);

//Error log
error_reporting(E_ALL);
set_error_handler(&#39;error_handler&#39;);
 
function error_handler($no, $msg, $filename, $line){
	$p = &#39;werror_log.txt&#39;;
	$handle = fopen($p, &#39;w+&#39;);

   	$err = &quot;File name: &quot; . $filename . &quot;&lt;br/&gt;&quot; . 
		&quot;Line: &quot; . $line . &quot;&lt;br/&gt;&quot; . 
		&quot;Message: &quot; . $msg . &quot;&lt;br/&gt;&quot;;
	//echo $err;
	fwrite($handle, $err . PHP_EOL);
    exit();
}

//Process log
$p = &#39;ipn_log.txt&#39;;
$handle = fopen($p, &#39;w+&#39;);
wlog(&#39;Log file created&#39;);

function wlog($msg){
	global $handle;
	fwrite($handle, $msg . PHP_EOL);
}


// Read the post from PayPal and add &#39;cmd&#39; 
$req = &#39;cmd=_notify-validate&#39;; 
$header = &#39;&#39;;

if(function_exists(&#39;get_magic_quotes_gpc&#39;)) 
{  
	$get_magic_quotes_exists = true; 
} 

$params = $_POST;
foreach ($params as $key =&gt; $value) 
// Handle escape characters, which depends on setting of magic quotes 
{  
	if($get_magic_quotes_exists == true &amp;&amp; get_magic_quotes_gpc() == 1){  
		$value = urlencode(stripslashes($value)); 
	} else { 
		$value = urlencode($value); 
	} 
	$req .= &quot;&amp;$key=$value&quot;;
} 
wlog($req); 

// Post back to PayPal to validate 
//$paypal = &#39;www.paypal.com&#39;;
$paypal = &#39;www.sandbox.paypal.com&#39;;

$header .= &quot;POST /cgi-bin/webscr HTTP/1.0\r\n&quot;; 
$header .= &quot;Host: &quot; . $paypal . &quot;\r\n&quot;;
$header .= &quot;Content-Type: application/x-www-form-urlencoded\r\n&quot;; 
$header .= &quot;Content-Length: &quot; . strlen($req) . &quot;\r\n\r\n&quot;; 
$fp = fsockopen (&#39;ssl://&#39; . $paypal, 443, $errno, $errstr, 30);
wlog($errstr);
 
// Process validation from PayPal 
// TODO: This sample does not test the HTTP response code. All 
// HTTP response codes must be handles or you should use an HTTP 
// library, such as cUrl 
 
if (!$fp) { // HTTP ERROR 
	wlog(&#39;Paypal IPN Listener - HTTP Error&#39;);
} else { 
	// NO HTTP ERROR 
	fputs ($fp, $header . $req); 
	wlog($errstr);

	while (!feof($fp)) { 
		$res = fgets ($fp, 1024); 
		wlog($res);

		if (strcmp ($res, &quot;VERIFIED&quot;) == 0 &amp;&amp; strcmp ($params["payment_status"], &quot;Completed&quot;) == 0) { 
			wlog(&quot;response verified&quot;);
			// TODO: 
			// Check the payment_status is Completed 
			// Check that txn_id has not been previously processed 
			// Check that receiver_email is your Primary PayPal email 
			// Check that payment_amount/payment_currency are correct 
			// Process payment 

			/* If &#39;VERIFIED&#39;, send an email of IPN variables and values to the 
			specified email address 
			foreach ($_POST as $key =&gt; $value){ 
				$emailtext .= $key . &quot; = &quot; .$value .&quot;\n\n&quot;; 
			} */


			//Check receiver email
			//if(strcmp ($params["receiver_email"], &quot;rex@wikirex.com&quot;) &lt;&gt; 0){
			//	wlog(&quot;Receiver email is not valid&quot;);
			//	break;
			//}

			//Check transaction id
			//if(strlen($err) == 0 &amp;&amp; txnExists($params["txn_id"]) == true){
			//	$err = &quot;Transaction ID: &quot; . $params["txn_id"] . &quot; exists already&quot;;
			//	break;
			//}

			//Check payment gross according to product ID
			//if($err == &quot;&quot; &amp;&amp; checkGross($productID, $_POST["mc_gross"], $_POST["mc_currency"], $_POST["exchange_rate"]) == false){
			//	$err = &quot;Payment gross amount is not equivalent to the setting of this product: &quot; . $_POST["txn_id"];
			//}

			$sql = &quot;INSERT INTO `orders` (`payment_vender`, `account_id`, `product_id`, 
`payment_status`, `product_name`, `receiver_id`, `receiver_email`, `transaction_id`, `transaction_type`, 
`invoice_number`, `item_name`, `item_number`, `quantity`, `charset`, `currency`, `exchange_rate`, `fee`, 
`gross`, `country`, `payer_email`, `payment_date`, `created_time`, `updated_time`) VALUES (&quot; . 
				$db-&gt;formatSQLInput(1) . &quot;, &quot; . 
				$db-&gt;formatSQLInput(0) . &quot;, &quot; . 
				$db-&gt;formatSQLInput(0) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['payment_status']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput(&#39;Test&#39;) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['receiver_id']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['receiver_email']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['txn_id']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['txn_type']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['invoice']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['item_name']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['item_number']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['quantity']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($util-&gt;out($params, &#39;charset&#39;, &#39;UTF-8&#39;)) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($util-&gt;out($params, &#39;mc_currency&#39;, &#39;USD&#39;)) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($util-&gt;out($params, &#39;exchange_rate&#39;, &#39;&#39;)) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['mc_fee']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['mc_gross']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['residence_country']) . &quot;, &quot; . 
				$db-&gt;formatSQLInput($params['payer_email']) . &quot;, &quot; . 
				$db-&gt;format_sql_date($params['payment_date']) . &quot;, &quot; . 
				$db-&gt;format_sql_date(NULL, true) . &quot;, &quot; . 
				$db-&gt;format_sql_date(NULL, true) . &quot; &quot; . 
				&quot;)&quot;;
			wlog($sql);

			$rs = $db-&gt;query($sql);
		} else if (strcmp ($res, &quot;INVALID&quot;) == 0) { 
			//If &#39;INVALID&#39;, send an email. TODO: Log for manual investigation. 
			$values = &#39;response: INVALID&#39;;
			wlog($values);
		}
	} 
}

fclose($fp);


if($err == &quot;&quot;){
	wlog(&quot;Store Listener - Completed&quot;, &quot;Transaction&quot;);
}else{
	wlog(&quot;Store Listener - Error&quot;);
}
?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

<?php

require_once('../includes/init_page_public.php');

//Error log

error_reporting(E_ALL);

set_error_handler('error_handler');

function error_handler($no, $msg, $filename, $line){

$p = 'werror_log.txt';

$handle = fopen($p, 'w+');

$err = "File name: " . $filename . "<br/>" .

"Line: " . $line . "<br/>" .

"Message: " . $msg . "<br/>";

//echo $err;

fwrite($handle, $err . PHP_EOL);

exit();

}

//Process log

$p = 'ipn_log.txt';

$handle = fopen($p, 'w+');

wlog('Log file created');

function wlog($msg){

global $handle;

fwrite($handle, $msg . PHP_EOL);

}

// Read the post from PayPal and add 'cmd'

$req = 'cmd=_notify-validate';

$header = '';

if(function_exists('get_magic_quotes_gpc'))

{

$get_magic_quotes_exists = true;

}

$params = $_POST;

foreach ($params as $key => $value)

// Handle escape characters, which depends on setting of magic quotes

{

if($get_magic_quotes_exists == true && get_magic_quotes_gpc() == 1){

$value = urlencode(stripslashes($value));

} else {

$value = urlencode($value);

}

$req .= "&$key=$value";

}

wlog($req);

// Post back to PayPal to validate

//$paypal = 'www.paypal.com';

$paypal = 'www.sandbox.paypal.com';

$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";

$header .= "Host: " . $paypal . "\r\n";

$header .= "Content-Type: application/x-www-form-urlencoded\r\n";

$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";

$fp = fsockopen ('ssl://' . $paypal, 443, $errno, $errstr, 30);

wlog($errstr);

// Process validation from PayPal

// TODO: This sample does not test the HTTP response code. All

// HTTP response codes must be handles or you should use an HTTP

// library, such as cUrl

if (!$fp) { // HTTP ERROR

wlog('Paypal IPN Listener - HTTP Error');

} else {

// NO HTTP ERROR

fputs ($fp, $header . $req);

wlog($errstr);

while (!feof($fp)) {

$res = fgets ($fp, 1024);

wlog($res);

if (strcmp ($res, "VERIFIED") == 0 && strcmp ($params["payment_status"], "Completed") == 0) {

wlog("response verified");

// TODO:

// Check the payment_status is Completed

// Check that txn_id has not been previously processed

// Check that receiver_email is your Primary PayPal email

// Check that payment_amount/payment_currency are correct

// Process payment

/* If 'VERIFIED', send an email of IPN variables and values to the

specified email address

foreach ($_POST as $key => $value){

$emailtext .= $key . " = " .$value ."\n\n";

} */

//Check receiver email

//if(strcmp ($params["receiver_email"], "[email protected]") <> 0){

// wlog("Receiver email is not valid");

// break;

//}

//Check transaction id

//if(strlen($err) == 0 && txnExists($params["txn_id"]) == true){

// $err = "Transaction ID: " . $params["txn_id"] . " exists already";

// break;

//}

//Check payment gross according to product ID

//if($err == "" && checkGross($productID, $_POST["mc_gross"], $_POST["mc_currency"], $_POST["exchange_rate"]) == false){

// $err = "Payment gross amount is not equivalent to the setting of this product: " . $_POST["txn_id"];

//}

$sql = "INSERT INTO `orders` (`payment_vender`, `account_id`, `product_id`,

`payment_status`, `product_name`, `receiver_id`, `receiver_email`, `transaction_id`, `transaction_type`,

`invoice_number`, `item_name`, `item_number`, `quantity`, `charset`, `currency`, `exchange_rate`, `fee`,

`gross`, `country`, `payer_email`, `payment_date`, `created_time`, `updated_time`) VALUES (" .

$db->formatSQLInput(1) . ", " .

$db->formatSQLInput(0) . ", " .

$db->formatSQLInput($params['payment_status']) . ", " .

$db->formatSQLInput('Test') . ", " .

$db->formatSQLInput($params['receiver_id']) . ", " .

$db->formatSQLInput($params['receiver_email']) . ", " .

$db->formatSQLInput($params['txn_id']) . ", " .

$db->formatSQLInput($params['txn_type']) . ", " .

$db->formatSQLInput($params['invoice']) . ", " .

$db->formatSQLInput($params['item_name']) . ", " .

$db->formatSQLInput($params['item_number']) . ", " .

$db->formatSQLInput($params['quantity']) . ", " .

$db->formatSQLInput($util->out($params, 'charset', 'UTF-8')) . ", " .

$db->formatSQLInput($util->out($params, 'mc_currency', 'USD')) . ", " .

$db->formatSQLInput($util->out($params, 'exchange_rate', '')) . ", " .

$db->formatSQLInput($params['mc_fee']) . ", " .

$db->formatSQLInput($params['mc_gross']) . ", " .

$db->formatSQLInput($params['residence_country']) . ", " .

$db->formatSQLInput($params['payer_email']) . ", " .

$db->format_sql_date($params['payment_date']) . ", " .

$db->format_sql_date(NULL, true) . ", " .

$db->format_sql_date(NULL, true) . " " .

")";

wlog($sql);

$rs = $db->query($sql);

} else if (strcmp ($res, "INVALID") == 0) {

//If 'INVALID', send an email. TODO: Log for manual investigation.

$values = 'response: INVALID';

wlog($values);

}

fclose($fp);

if($err == ""){

wlog("Store Listener - Completed", "Transaction");

}else{

wlog("Store Listener - Error");

}

Reference:

Convert Objects to JSON

var versions = [];
var version = {};

version.folder = &#39;banners&#39;;
version.width = 1000;
version.height = 600;
version.crop = &#39;true&#39;;
version.root = &#39;true&#39;;

versions.push(version);
console.log(JSON.stringify(versions));
// [{"folder":"banners","width":1000,"height":600,"crop":"true","root":"true"}]

var versions = [];

var version = {};

version.folder = 'banners';

version.width = 1000;

version.height = 600;

version.crop = 'true';

version.root = 'true';

versions.push(version);

console.log(JSON.stringify(versions));

// [{"folder":"banners","width":1000,"height":600,"crop":"true","root":"true"}]

Usage of jQuery Datatable

Hide ID column but still able to get item ID:

Use CSS instead of “columnDefs”:

Reference:

http://stackoverflow.com/questions/14372655/jquery-datatables-hide-column-without-removing-it-from-dom

CSS:

#film_table tr.row_selected td{background:#CCC;}

1	#film_table tr.row_selected td{background:#CCC;}

var cat_id = 1;
var d_table = null;
var order = [[ 6, "asc" ], [ 5, "" ]];
var selected_id = 0;

var datatable = {
    init: function(){
        var wrap = this;
        d_table = $('#datatable').dataTable( {
            'pageLength': 20, //20 items per page
            "lengthMenu": [[20, 50, -1], [20, 50, "All"]], 
            "ajax": {
				'url': '<?=base_url()?>index.php/admin/page/all/' + cat_id, 
				'data': function(d){
					d.param = 'value';
				}
			},
            "order": order, 
            "columnDefs": [
                {
                    "targets": [ 6 ],
                    "visible": false,
                    "searchable": false, 
                    "orderable": false, 
                    "className": "class_name"
                }
            ], 
            'fnServerParams': function(aoData){
                //Append extra parameters
                //console.log(aoData);
                aoData.push({
                    'name': 'countries', 
                    'value': $('#country').val()
                });
            }, 
			//This callback will be triggered multiple times
			"drawCallback": function( settings ) {
                var api = this.api();
                wrap.loaded(settings);
            }, 
			//This callback will be triggered only once
            "fnInitComplete": function(oSettings, json) {
              console.log('fnInitComplete');
              console.log($('#datatable input[name="users"]').size());
            }
        });

        $('#datatable tbody').on( 'click', 'tr', function () {
            if ( $(this).hasClass('selected') ) {
                $(this).removeClass('selected');
            }else {
                d_table.$('tr.selected').removeClass('selected');
                $(this).addClass('selected');
            }

            //console.log( table.row( this ).data() );
            selected_id = wrap.get_id($(this));
            $('#item_id').val(selected_id);
        });

        $('#datatable tbody').on( 'click', '.edit_item', function (e) {
            e.preventDefault();
            window.location.href = '<?=base_url()?>index.php/admin/page/edit/' + cat_id + '/' + selected_id;
        });

        $('#datatable tbody').on( 'click', '.sort_up', function (e) {
            e.preventDefault();
            var cat_id = $('#cat_id').val();
            wrap.sort(cat_id, selected_id, 'up');
        });

        $('#datatable tbody').on( 'click', '.sort_down', function (e) {
            e.preventDefault();
            var cat_id = $('#cat_id').val();
            wrap.sort(cat_id, selected_id, 'down');
        });
    }, 
    loaded: function(oSettings){
        //Table loaded
		var wrap = datatable;
        var $table = $('#datatable');

        $table.find('tbody tr').unbind().on( 'click', function () {
            if ( $(this).hasClass('selected') ) {
                $(this).removeClass('selected');
            }else {
                d_table.$('tr.selected').removeClass('selected');
                $(this).addClass('selected');
            }

            //console.log( table.row( this ).data() );
            selected_id = wrap.get_id($(this));
            $('#item_id').val(selected_id);
        });

        $table.find('.edit_item').unbind().on( 'click', function (e) {
            e.preventDefault();
            window.location.href = '<?=base_url()?>index.php/admin/product/edit/' + cat_id + '/' + selected_id;
        });
    }, 
    get_id: function($row){
        return $row.find('>td:first').text();
    }, 
    refresh: function(){
        var wrap = this;
        d_table.fnDestroy();
        wrap.init();
    },  
    delete_item: function(){
        var wrap = this;
        var params = {
            id: selected_id
        }

        $.ajax('<?=base_url()?>index.php/admin/page/delete', {
            type: 'POST', 
            data: params, 
            success: function(data, textStatus, jqXHR){
                //console.log(data);
                if(typeof data.err_code == 'undefined'){
                    show_msg('Error', data);
                }else if(data.err_code == 0){
                    //show_msg('Info', 'Item has been deleted');
                    window.location.reload();
                }else{
                    show_error(data.err_code, data.err);
                }
            },
            error: function(jqXHR, textStatus, errorThrown){
                alert('Error:' + jqXHR.responseText);
                wrapper.refresh_tree();
            }
        });
    }, 
    sort: function(cat_id, selected_id, direction){
        var wrap = this;
        var params = {
            cat_id: cat_id, 
            id: selected_id, 
            direction: direction, 
            sort_direction: 'desc'
        }

        $.ajax('<?=base_url()?>index.php/admin/page/sort', {
            type: 'POST', 
            data: params, 
            success: function(data, textStatus, jqXHR){
                //console.log(data.err_code == 0 && err == '');
                //return;
                if(typeof data.err_code == 'undefined'){
                    show_msg('Error', data);
                }else if(data.err_code == 0 && data.err == ''){
                    //console.log(wrap);
                    //window.location.reload();
                    wrap.refresh();
                }else{
                    show_error(data.err_code, data.err);
                }
            },
            error: function(jqXHR, textStatus, errorThrown){
                alert('Error:' + jqXHR.responseText);
            }
        });
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

var cat_id = 1;

var d_table = null;

var order = [[ 6, "asc" ], [ 5, "" ]];

var selected_id = 0;

var datatable = {

init: function(){

var wrap = this;

d_table = $('#datatable').dataTable( {

'pageLength': 20, //20 items per page

"lengthMenu": [[20, 50, -1], [20, 50, "All"]],

"ajax": {

'url': '<?=base_url()?>index.php/admin/page/all/' + cat_id,

'data': function(d){

d.param = 'value';

}

"order": order,

"columnDefs": [

{

"targets": [ 6 ],

"visible": false,

"searchable": false,

"orderable": false,

"className": "class_name"

}

'fnServerParams': function(aoData){

//Append extra parameters

//console.log(aoData);

aoData.push({

'name': 'countries',

'value': $('#country').val()

});

//This callback will be triggered multiple times

"drawCallback": function( settings ) {

var api = this.api();

wrap.loaded(settings);

//This callback will be triggered only once

"fnInitComplete": function(oSettings, json) {

console.log('fnInitComplete');

console.log($('#datatable input[name="users"]').size());

}

});

$('#datatable tbody').on( 'click', 'tr', function () {

if ( $(this).hasClass('selected') ) {

$(this).removeClass('selected');

}else {

d_table.$('tr.selected').removeClass('selected');

$(this).addClass('selected');

}

//console.log( table.row( this ).data() );

selected_id = wrap.get_id($(this));

$('#item_id').val(selected_id);

});

$('#datatable tbody').on( 'click', '.edit_item', function (e) {

e.preventDefault();

window.location.href = '<?=base_url()?>index.php/admin/page/edit/' + cat_id + '/' + selected_id;

});

$('#datatable tbody').on( 'click', '.sort_up', function (e) {

e.preventDefault();

var cat_id = $('#cat_id').val();

wrap.sort(cat_id, selected_id, 'up');

});

$('#datatable tbody').on( 'click', '.sort_down', function (e) {

e.preventDefault();

var cat_id = $('#cat_id').val();

wrap.sort(cat_id, selected_id, 'down');

});

loaded: function(oSettings){

//Table loaded

var wrap = datatable;

var $table = $('#datatable');

$table.find('tbody tr').unbind().on( 'click', function () {

if ( $(this).hasClass('selected') ) {

$(this).removeClass('selected');

}else {

d_table.$('tr.selected').removeClass('selected');

$(this).addClass('selected');

}

//console.log( table.row( this ).data() );

selected_id = wrap.get_id($(this));

$('#item_id').val(selected_id);

});

$table.find('.edit_item').unbind().on( 'click', function (e) {

e.preventDefault();

window.location.href = '<?=base_url()?>index.php/admin/product/edit/' + cat_id + '/' + selected_id;

});

get_id: function($row){

return $row.find('>td:first').text();

refresh: function(){

var wrap = this;

d_table.fnDestroy();

wrap.init();

delete_item: function(){

var wrap = this;

var params = {

id: selected_id

}

$.ajax('<?=base_url()?>index.php/admin/page/delete', {

type: 'POST',

data: params,

success: function(data, textStatus, jqXHR){

//console.log(data);

if(typeof data.err_code == 'undefined'){

show_msg('Error', data);

}else if(data.err_code == 0){

//show_msg('Info', 'Item has been deleted');

window.location.reload();

}else{

show_error(data.err_code, data.err);

}

error: function(jqXHR, textStatus, errorThrown){

alert('Error:' + jqXHR.responseText);

wrapper.refresh_tree();

}

});

sort: function(cat_id, selected_id, direction){

var wrap = this;

var params = {

cat_id: cat_id,

id: selected_id,

direction: direction,

sort_direction: 'desc'

}

$.ajax('<?=base_url()?>index.php/admin/page/sort', {

type: 'POST',

data: params,

success: function(data, textStatus, jqXHR){

//console.log(data.err_code == 0 && err == '');

//return;

if(typeof data.err_code == 'undefined'){

show_msg('Error', data);

}else if(data.err_code == 0 && data.err == ''){

//console.log(wrap);

//window.location.reload();

wrap.refresh();

}else{

show_error(data.err_code, data.err);

}

error: function(jqXHR, textStatus, errorThrown){

alert('Error:' + jqXHR.responseText);

}

});

}

Localized txt file content:

{
	"sProcessing": "處理中...",
	"sLengthMenu": "_MENU_ &lt;span&gt;筆/頁&lt;/span&gt;",
	"sZeroRecords": "沒有資料.",
	"sInfo": "顯示 &lt;span&gt;_START_&lt;/span&gt; 到 &lt;span&gt;_END_&lt;/span&gt; 共 &lt;span&gt;_TOTAL_&lt;/span&gt; 筆資料",
	"sInfoEmpty": "顯示 &lt;span&gt;0&lt;/span&gt; 到 &lt;span&gt;0&lt;/span&gt; 共 &lt;span&gt;0&lt;/span&gt; 筆資料",
	"sInfoFiltered": "(gefiltert von _MAX_  Einträgen)",
	"sInfoPostFix": "",
	"sSearch": "&lt;span&gt;查詢:&lt;/span&gt; ",
	"sUrl": "",
	"oPaginate": {
		"sFirst":    "第一頁",
		"sPrevious": "上一頁",
		"sNext":     "下一頁",
		"sLast":     "最後一頁"
	}
}

{

"sProcessing": "處理中...",

"sLengthMenu": "_MENU_ <span>筆/頁</span>",

"sZeroRecords": "沒有資料.",

"sInfo": "顯示 <span>_START_</span> 到 <span>_END_</span> 共 <span>_TOTAL_</span> 筆資料",

"sInfoEmpty": "顯示 <span>0</span> 到 <span>0</span> 共 <span>0</span> 筆資料",

"sInfoFiltered": "(gefiltert von _MAX_ Einträgen)",

"sInfoPostFix": "",

"sSearch": "<span>查詢:</span> ",

"sUrl": "",

"oPaginate": {

"sFirst": "第一頁",

"sPrevious": "上一頁",

"sNext": "下一頁",

"sLast": "最後一頁"

}

Reference:

Options: retrieve, destroy
https://datatables.net/manual/tech-notes/3
http://datatables.net/examples/basic_init/hidden_columns.html
Custom HTTP variables:
https://datatables.net/examples/server_side/custom_vars.html

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Monthly Archives: July 2013

Split Chinese String

curl – Send session cookies

Table Example

Get Current File Name

“use” operator

jQuery Form Plugin Example (Deprecated)

Official Site: http://malsup.com/jquery/form/

Notices:

Form HTML:

Javascript:

Click Issue of popover

IPN Listener

Convert Objects to JSON

Usage of jQuery Datatable

Hide ID column but still able to get item ID: