public static function test_sqlite3_json_smartgrid($ofs, $sortby, $sortdir, $sorttype, $src = '')
{
//--
$db = new SmartTestSQLite3Model();
$model = $db->getConnection();
//--
//--
$data = array();
$data['status'] = 'OK';
$data['crrOffset'] = (int) $ofs;
$data['itemsPerPage'] = 25;
$data['sortBy'] = (string) $sortby;
$data['sortDir'] = (string) $sortdir;
$data['sortType'] = (string) $sorttype;
$data['filter'] = array('src' => (string) $src);
//--
if ((string) strtoupper((string) $sortdir) == 'DESC') {
$syntax_sort_dir = 'DESC';
} else {
$syntax_sort_dir = 'ASC';
}
//end if else
$syntax_sort_mode = '';
switch ((string) $sortby) {
case 'iso':
$syntax_sort_mode = ' ORDER BY iso ' . $syntax_sort_dir;
break;
case 'name':
$syntax_sort_mode = ' ORDER BY name ' . $syntax_sort_dir;
break;
case 'iso3':
$syntax_sort_mode = ' ORDER BY iso3 ' . $syntax_sort_dir;
break;
case 'numcode':
$syntax_sort_mode = ' ORDER BY numcode ' . $syntax_sort_dir;
break;
default:
$syntax_sort_mode = '';
}
//end switch
//--
$where = '';
if ((string) $src != '') {
if (is_numeric($src)) {
$where = $model->prepare_param_query(' WHERE numcode = ?', array((int) $src));
} elseif (strlen((string) $src) == 2) {
$where = $model->prepare_param_query(' WHERE iso = ?', array(SmartUnicode::str_toupper($src)));
} elseif (strlen((string) $src) == 3) {
$where = $model->prepare_param_query(' WHERE iso3 = ?', array(SmartUnicode::str_toupper($src)));
} else {
$where = $model->prepare_param_query(' WHERE name LIKE ?', array($src . '%'));
}
//end if else
}
//end if
$data['totalRows'] = $model->count_data('SELECT COUNT(1) FROM sample_countries' . $where);
$data['rowsList'] = $model->read_adata('SELECT iso, name, iso3, numcode FROM sample_countries' . $where . $syntax_sort_mode . ' LIMIT ' . (int) $data['itemsPerPage'] . ' OFFSET ' . (int) $data['crrOffset']);
//--
unset($db);
// close
//--
//--
return Smart::json_encode((array) $data);
//--
}
private function _putcmd($cmd, $arg = '')
{
//--
if ((string) $arg != '') {
$cmd = $cmd . ' ' . $arg;
}
//end if
//--
if (!$this->_sock) {
$this->_debug_print('ERROR: CMD command failed: ' . $cmd . "\n");
return false;
}
//end if
//--
@fwrite($this->_sock, $cmd . "\r\n");
//--
if ($this->debug_level == 'full') {
//--
if (SmartUnicode::str_toupper(substr($cmd, 0, 5)) == 'PASS ') {
$this->_debug_print('# ' . 'PASS ********' . "\n");
} elseif (SmartUnicode::str_toupper(substr($cmd, 0, 6)) == 'ADMIN ') {
$this->_debug_print('# ' . 'ADMIN ********' . "\n");
} else {
$this->_debug_print('# ' . $cmd . "\n");
}
//end if else
//--
}
//end if
//--
return true;
//--
}
public function add_attachment($message, $name = '', $ctype = '', $disp = 'attachment', $cid = '', $realattachment = 'no')
{
//--
switch (strtolower($ctype)) {
//-- text parts
case 'text/plain':
case 'text/html':
//--
if ((string) $disp != 'attachment') {
$disp = 'inline';
// default
}
//end if
//--
$encode = 'base64';
// quoted-printable
//--
if ((string) $disp == 'inline') {
$charset = SmartUnicode::str_toupper(trim($this->charset));
}
//end if
//--
break;
//-- email messages
//-- email messages
case 'message/rfc822':
case 'message/partial':
case 'partial/message':
// fake type to avoid Google and Yahoo to show the Un-Encoded part
//-- OLD method :: rewrite type to avoid conflicts (gmail, yahoo, thunderbird)
//$ctype = 'partial/message';
//$encode = 'base64';
//$disp = 'attachment';
//-- NEW Method (tested with Thunderbird and GMail)
$ctype = 'message/rfc822';
$encode = '7bit';
// this is known to work with Thunderbird and GMail
//$encode = 'base64'; this does not work with Thunderbird ...
$disp = 'inline';
//--
$name = 'forwarded_message_' . date('YmdHis') . '_' . Smart::random_number(10000, 99999) . '.eml';
$filename = $name;
//--
break;
//-- the rest ...
//-- the rest ...
default:
//--
if ((string) $ctype == '') {
$ctype = 'application/octet-stream';
}
//end if
//--
$encode = 'base64';
//--
if ((string) $ctype == 'image' or (string) $ctype == 'image/jpeg' or (string) $ctype == 'image/jpg' or (string) $ctype == 'image/png' or (string) $ctype == 'image/gif') {
if ((string) $disp != 'inline') {
$disp = 'attachment';
// default
}
//end if
} else {
$disp = 'attachment';
}
//end if else
//--
$filename = $name;
//--
}
//end switch
//--
if ((string) $realattachment == 'yes') {
// real attachments
$this->atts[] = array('ctype' => $ctype, 'message' => $message, 'charset' => $charset, 'encode' => $encode, 'disp' => $disp, 'name' => $name, 'filename' => $filename, 'cid' => $cid);
} else {
$this->parts[] = array('ctype' => $ctype, 'message' => $message, 'charset' => $charset, 'encode' => $encode, 'disp' => $disp, 'name' => $name, 'filename' => $filename, 'cid' => $cid);
}
//end if else
//--
}
