Skip to content

Instantly share code, notes, and snippets.

View leonguyen's full-sized avatar

Nam Nguyen leonguyen

View GitHub Profile
@leonguyen
leonguyen / gist:9284221
Created March 1, 2014 02:41
ad_user update
exports.update = function(req, res){
var chk = req.body.chkId;
var sel = req.body.selUpd;
for(i=0; i<chk.length; i++){
if(sel == 'del'){
_this._delete(chk[i]);
req.flash('success_msg', 'The data has been deleted.');
res.redirect('/' + control + '/');
} else {
_this._status(chk[i],(sel == 'ena' ? 1 : 0));
@leonguyen
leonguyen / gist:9284199
Created March 1, 2014 02:39
ad_user status
exports.status = function(req, res) {
if(req.params.id!=1&&(req.params.id!=req.session.uId)){
_this._status(req.params.id, req.params.st);
req.flash('success_msg', 'The changes have been saved.');
res.redirect('/' + control + '/');
} else {
req.flash('error_msg', 'The data can not change.');
res.redirect('/' + control + '/');
}
};
@leonguyen
leonguyen / gist:9284147
Created March 1, 2014 02:35
ad_user delete
exports.delete = function(req, res) {
if(req.params.id!=1&&(req.params.id!=req.session.uId)){
_this._delete(req.params.id);
req.flash('success_msg', 'The data has been deleted.');
res.redirect('/' + control + '/');
} else {
req.flash('error_msg', 'The data can not delete.');
res.redirect('/' + control + '/');
}
};
@leonguyen
leonguyen / gist:9284129
Last active August 29, 2015 13:56
ad_user save
exports.save = function(req, res) {
var id = req.body.hdId;
var save = req.body.hdSave;
//Upload
var imgPath = req.files.fiAva.path;
var imgName = req.files.fiAva.name!=''?(Date.now() + '_' + req.files.fiAva.name):'';
fs.readFile(imgPath, function(err, data){
if(req.files.fiAva.name){
var newPath = "./public/uploads/" + imgName;
fs.writeFile(newPath, data, function(err){
@leonguyen
leonguyen / gist:9284064
Created March 1, 2014 02:27
ad_user check
exports.chkName = function(req, res) {
var id = req.params.id; //console.log(id);
if(id==0){
var query = conn.query("SELECT * FROM `" + prefix + "user`" + " WHERE uName=" + conn.escape(req.body.txtName), function(err, rows){
if(err) { console.log(query.sql); console.log(err);}
if(rows.length==0){
res.send('1');
} else {
res.send('{ "error": "The Username is exist." }');
}
@leonguyen
leonguyen / gist:9284040
Created March 1, 2014 02:26
ad_user edit
exports.edit = function(req, res) {
var id = req.params.id;
var query = conn.query("SELECT * FROM `" + prefix + "user`" + " WHERE uId=" + conn.escape(id), function(err, rows){
if(err) { console.log(query.sql); console.log(err);}
var query = conn.query(sqlLstComp, function(err, lstComp){
if(err) { console.log(query.sql); console.log(err);}
var query = conn.query(sqlLstBr, function(err, lstBr){
if(err) { console.log(query.sql); console.log(err);}
var query = conn.query(sqlLstRl, function(err, lstRl){
if(err) { console.log(query.sql); console.log(err);}
@leonguyen
leonguyen / gist:9284018
Created March 1, 2014 02:24
ad_user create
exports.create = function(req, res){
var query = conn.query(sqlLstComp, function(err, lstComp){
if(err) { console.log(query.sql); console.log(err);}
var query = conn.query(sqlLstBr, function(err, lstBr){
if(err) { console.log(query.sql); console.log(err);}
res.render(control + '/frm', {
title: 'User',
control: control,
lstComp: lstComp,
lstBr: lstBr,
@leonguyen
leonguyen / gist:9283878
Created March 1, 2014 02:14
ad_user get list, search
exports.index = function(req, res) {
delete req.session.search;
_this._showlist(req, res);
};
exports.search = function(req, res) {
search['per_page'] = req.body.selLimit?req.body.selLimit:10;
search['name'] = req.body.txtName?req.body.txtName:'';
search['status'] = req.body.selStatus?req.body.selStatus:'';
req.session.search = search;
@leonguyen
leonguyen / gist:9283866
Created March 1, 2014 02:12
ad_user header
var _this = this,
prefix = cfg.db.prefix,
prefixDt = cfg.db.prefixDt,
control = 'ad_user';
var search = {
per_page: '10',
name: '',
status: '',
sort: '',
};
@leonguyen
leonguyen / gist:9283519
Created March 1, 2014 01:37
ad_user Save
/*
* GET admin user page.
*/
var _this = this,
prefix = cfg.db.prefix,
prefixDt = cfg.db.prefixDt,
control = 'ad_user';
var search = {
per_page: '10',