PaymentDao.prototype.createOrderAddress = function(data, cb){
logger.debug("Create order address method call start (createOrderAddress())");
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {
full_name:data.full_name,
mobile_number:data.mobile_number,
address:data.address,
landmark:data.landmark,
gender:data.gender,
order_id:data.order_id,
created_date: date,
edited_date: date,
created_by: data.logged_in_user.user_id,
edited_by: data.logged_in_user.user_id
};
var query = [];
query.push(" INSERT INTO `order_address` SET ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query, [queryData], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("create order address query = " + mySqlQuery.sql);
}
PrescriptionDao.prototype.addPrescription = function (data, cb) {
logger.debug("Add prescription method call start (addPrescription())");
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {};
queryData.user_id = data.logged_in_user.user_id;
queryData.title = data.title;
queryData.relative_path = data.relative_path;
queryData.created_date = date;
queryData.created_by = data.logged_in_user.user_id;
queryData.edited_date = date;
queryData.edited_by = data.logged_in_user.user_id;
var query = [];
query.push(" INSERT INTO user_prescription SET ? ");
query = query.join("");
var mySqlQuery = connection.query(query,[queryData], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("login query = " + mySqlQuery.sql);
}
PaymentDao.prototype.createOrderPayment = function (data, cb) {
logger.debug("order payment create method call start (createOrderPayment())");
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {
order_id: data.order_id,
payment_id: data.payment_id,
transaction_id: data.transaction_id,
amount:data.amount,
created_date: date,
edited_date: date,
created_by: data.logged_in_user.user_id,
edited_by: data.logged_in_user.user_id
};
var query = [];
query.push(" INSERT INTO order_payment SET ? ");
query = query.join("");
var mySqlQuery = connection.query(query,[queryData], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("create order payment query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.getOrderItemStatus = function(data, cb){
logger.debug("Get order item status dao service called (getOrderItemStatus())");
var query = [];
query.push(" select ");
query.push(" oi.id as order_item_id ");
query.push(" ,t.name as test_name ");
query.push(" ,l.id as lab_id ");
query.push(" ,l.name as lab_name ");
query.push(" ,ois.name as test_state ");
query.push(" ,oisc.created_date as test_state_created_date ");
query.push(" from order_item as oi ");
query.push(" inner join `order` as o on o.id = oi.order_id ");
query.push(" inner join test as t on t.id = oi.test_id ");
query.push(" inner join lab as l on l.id = oi.lab_id ");
query.push(" inner join order_item_status_change as oisc on oi.id = oisc.order_item_id and oisc.status_id = oi.status_id ");
query.push(" inner join order_item_status as ois on ois.id = oi.status_id ");
query.push(" where o.user_id = ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query,[data.logged_in_user.user_id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("Get order item status query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.add = function(data, cb){
logger.debug("Create order item dao call start (add())"+JSON.stringify(data));
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {
status_id: data.status_id||1,
test_id: data.test_id,
lab_id: data.lab_id,
order_id: data.order_id,
appointment_date: data.appointment_date,
price: data.price,
created_date: date,
edited_date: date,
created_by: data.logged_in_user.user_id,
edited_by: data.logged_in_user.user_id
};
var query = [];
query.push(" INSERT INTO `order_item` SET ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query, [queryData], function (err, resultSet) {
if (err) {
logger.error("Error in adding item to cart "+err);
return cb(err);
}
logger.debug("Result adding item to cart "+resultSet);
return cb(null, resultSet);
});
logger.debug("create order item query = " + mySqlQuery.sql);
}
PaymentDao.prototype.getList = function (data, cb) {
logger.debug("payment get list method call start (getList())");
var query = [];
query.push(" SELECT * from payment ");
query = query.join("");
var mySqlQuery = connection.query(query, function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("payment get query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.removeOrderItemStatus = function(data, cb){
logger.debug("Remove order item status (removeOrderItemStatus())");
var query = [];
query.push(" Delete from `order_item_status_change` WHERE order_item_id = ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query,[data.id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("remove order item status query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.getOrderPriceFromOrderItem = function(data, cb){
logger.debug("Get order price from order item dao call start (getOrderPriceFromOrderItem())");
var query = [];
query.push(" select sum(price) as total_price from order_item where order_id = ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query, [data.order_id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("get order price query = " + mySqlQuery.sql);
}
PrescriptionDao.prototype.deletePrescription = function(data, cb){
logger.debug("Delete prescription method call start (deletePrescription())");
var query = [];
query.push(" Delete from user_prescription WHERE id = ? ");
query = query.join("");
var mySqlQuery = connection.query(query,[data.id], function (err, resultSet) {
if (err) {
return cb(err);
}
console.log("the result is"+JSON.stringify(resultSet));
return cb(null, resultSet);
});
//logger.debug("delete prescription query = " + mySqlQuery.sql);
}
PrescriptionDao.prototype.getDetail = function (data, cb) {
logger.debug("Get prescription detail method call start (addPriscription())");
var query = [];
query.push(" SELECT id,title,relative_path,feed_back,created_date from user_prescription WHERE id = ? ");
query = query.join("");
var mySqlQuery = connection.query(query,[data.id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("Get detail query = " + mySqlQuery.sql);
}
PrescriptionDao.prototype.getList = function (data, cb) {
logger.debug("Add prescription method call start (addPriscription())");
var query = [];
query.push(" SELECT id,title,relative_path,created_date from user_prescription WHERE user_id = ? ");
if(data.id){
query.push(" AND id = ? ");
}
query = query.join("");
var mySqlQuery = connection.query(query,[data.logged_in_user.user_id, data.id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("login query = " + mySqlQuery.sql);
}
LabDao.prototype.getTestPrice = function (data, cb) {
logger.debug("lab get list method call start (getList())");
var query = [];
query.push(" SELECT lt.price ");
query.push(" FROM lab_test as lt ");
query.push(" INNER JOIN lab as l on l.id = lt.lab_id ");
query.push(" INNER JOIN test as t on t.id = lt.test_id ");
query.push(" WHERE l.id = ? And t.id = ? ")
query = query.join("");
var mySqlQuery = connection.query(query,[data.lab_id, data.test_id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("Get Item Price query = " + mySqlQuery.sql);
}
PaymentDao.prototype.getOrderDetailForPayment = function(data, cb){
logger.debug("Get order detail for payment dao called (getOrderDetailForPayment())"+JSON.stringify(data));
var query = [];
query.push(" SELECT ");
query.push(" `order`.id , `order`.user_id ");
// query.push(" ,`order_price`.payable_amount ");
query.push(" from `order` ");
// query.push(" inner join `order_price` on `order_price`.order_id = `order`.id ");
query.push(" where `order`.id = ? ");/*and user_id = ? ");*/
query = query.join("");
var mySqlQuery = connection.query(query,[data.id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("create order payment query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.updateLab = function(data, cb){
logger.debug("Update order item dao call start (updateLab())"+JSON.stringify(data));
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {
lab_id: data.lab_id,
price: data.price,
edited_date: date,
edited_by: data.logged_in_user.user_id
};
var query = [];
query.push(" UPDATE `order_item` SET ? where id = ?");
query = query.join(" ");
var mySqlQuery = connection.query(query, [queryData,data.id], function (err, resultSet) {
if (err) {
logger.error("Error in adding item to cart "+err);
return cb(err);
}
logger.debug("Result update lab "+JSON.stringify(queryData)+data.id);
return cb(null, resultSet);
});
logger.debug("create order item query = " + mySqlQuery.sql);
}
PaymentDao.prototype.getOrdersPayment = function(data, cb){
logger.debug("Get Order Payment dao call start (getOrdersPayment())");
var query = [];
query.push(" SELECT ");
query.push(" o.id as order_id, o.created_date as order_date ");
query.push(" ,if(o.is_cart = 0,0,1) as is_cart ");
query.push(" ,if(op.id is null,'NOT_PAID','PAID') as payment_status ");
query.push(" ,op.amount as payment_price ");
query.push(" ,p.id as payment_mode ");
query.push(" From `order` as o ");
query.push(" left join order_payment as op on op.order_id = o.id ");
query.push(" left join payment as p on p.id = op.payment_id ")
query.push(" where o.user_id = ? ");
query = query.join("");
var mySqlQuery = connection.query(query,[data.logged_in_user.user_id], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("create order payment query = " + mySqlQuery.sql);
}
OrderItemDao.prototype.addOrderItemStatus = function(data, cb){
logger.debug("Create order item status dao call start (addOrderItemStatus())");
var date = utilDao.getMySqlFormatDateTime(null);
var queryData = {
status_id: data.status_id||1,
order_item_id: data.order_item_id,
created_date: date,
edited_date: date,
created_by: data.logged_in_user.user_id,
edited_by: data.logged_in_user.user_id
};
var query = [];
query.push(" INSERT INTO `order_item_status_change` SET ? ");
query = query.join(" ");
var mySqlQuery = connection.query(query, [queryData], function (err, resultSet) {
if (err) {
return cb(err);
}
return cb(null, resultSet);
});
logger.debug("create order item status query = " + mySqlQuery.sql);
}