function updateMember(member, memberCard, callback) { var sqlArray = []; sqlArray.push(dataUtils.getUpdateSqlOfObjId("tb_member", member)); if (!_.isEmpty(memberCard)) { sqlArray.push(dataUtils.getUpdateSqlOfObjId("tb_memberCard", memberCard)); } dataUtils.batchExecuteSql(sqlArray, callback); }
function rechargeMember(memberCard, rechargeBill, empBonus, callback) { var sqlArray = []; sqlArray.push({statement: "update tb_memberCard set currentMoney = currentMoney + ?,recharge_money = recharge_money + ? where id = ?;", value: [memberCard.rechargeMoney, memberCard.rechargeMoney, memberCard.id]}); sqlArray.push(dataUtils.getInsertSqlOfObj("tb_rechargeMemberBill", rechargeBill)); if (!_.isEmpty(empBonus)) { sqlArray.push(dataUtils.getInsertSqlOfObj("tb_empBonus", empBonus)); } dataUtils.batchExecuteSql(sqlArray, callback); }
function newMember(member, memberCard, rechargeBill, empBonus, callback) { var sqlArray = []; sqlArray.push(dataUtils.getInsertSqlOfObj("tb_member", member)); sqlArray.push(dataUtils.getInsertSqlOfObj("tb_memberCard", memberCard)); sqlArray.push(dataUtils.getInsertSqlOfObj("tb_rechargeMemberBill", rechargeBill)); if (!_.isEmpty(empBonus)) { sqlArray.push(dataUtils.getInsertSqlOfObj("tb_empBonus", empBonus)); } dataUtils.batchExecuteSql(sqlArray, callback); }
/** * 修改打印机信息 */ function updatePrinterInfo(oldId, callback) { var sqlArray = []; printer.id = oldId; printer.use_flag = 1; sqlArray.push(dataUtils.getUpdateSqlOfObjId("tb_printer", printer)); sqlArray.push({ statement: "update tb_printer set use_flag = ? where id != ?;", value: [0, printer.id] }); dataUtils.batchExecuteSql(sqlArray, callback); }
/** * 新增打印机记录 */ function addPrinterInfo(callback) { var sqlArray = []; $scope.printer.id = time;//更新保持模型中的id、 printer.id = time; printer.use_flag = 1; sqlArray.push(dataUtils.getInsertSqlOfObj("tb_printer", printer)); sqlArray.push({ statement: "update tb_printer set use_flag = ? where id != ?;", value: [0, printer.id] }); dataUtils.batchExecuteSql(sqlArray, callback); }
utils.getPicture(sourceType, null, "nailshop", "userImage", function (error, path) { if (error) { utils.log("m-setting store.js getPicture", error); utils.showAreaFailMsg("#m-setting-store-area", "图片保存失败"); return; } var store = {}; store.id = $scope.store.id; store.logo = path; store.modify_date = new Date().getTime(); dataUtils.updateRecordById(CONSTANT.tb_enterprise, store, null, function (error, rowsAffected) { if (error) { utils.showAreaFailMsg("#m-setting-store-area", "图片保存失败"); utils.log("m-setting store.js getPicture", error); return; } record.logo = path; if (oldPath) { utils.deleteFileByPath(oldPath); } $scope.digestScope(); database.updateBackupFlag(store.modify_date, YILOS_NAIL_MODULE.ENTERPRISE, null); utils.showAreaSuccessMsg("#m-setting-store-area", "图片保存成功"); }); });
_.each($scope.temp.delItems, function (item) { sqlArray.push(dataUtils.getDelSqlById(CONSTANT.tb_operateItem, item.id)); });
_.each($scope.temp.addItems, function (item) { item.create_date = modifyDate; sqlArray.push(dataUtils.getInsertSqlOfObj(CONSTANT.tb_operateItem, item, ["id", "name", "enterprise_id", "create_date"])); });
$scope.editInfoSave = function (action) { var updateField = ["id", "modify_date"]; if (!checkInput()) { return; } switch (action) { case "name": updateField.push("name"); break; case "phone": updateField.push("contact_phoneMobile"); break; case "comment": updateField.push("comment"); break; case "hours": updateField.push("hours_begin"); updateField.push("hours_end"); break; case "address": updateField.push("addr_state"); updateField.push("addr_city"); updateField.push("addr_area"); updateField.push("addr_detail"); updateField.push("addr_state_city_area"); updateField.push("location"); $scope.storeTemp.addr_state = $scope.storeTemp.selectedProvince ? $scope.storeTemp.selectedProvince.name : ""; $scope.storeTemp.addr_city = $scope.storeTemp.selectedCity ? $scope.storeTemp.selectedCity.name : ""; $scope.storeTemp.addr_area = $scope.storeTemp.selectedArea ? $scope.storeTemp.selectedArea.name : ""; break; } var sqlArray = []; var modifyDate = new Date().getTime(); var store = { id: $scope.storeTemp.id, logo: $scope.store.logo,//保持log可继续选择 name: $scope.storeTemp.name, contact_phoneMobile: $scope.storeTemp.contact_phoneMobile, addr_state: $scope.storeTemp.addr_state, addr_city: $scope.storeTemp.addr_city, addr_area: $scope.storeTemp.addr_area, addr_detail: $scope.storeTemp.addr_detail, addr_state_city_area: $scope.storeTemp.addr_state_city_area, comment: $scope.storeTemp.comment, hours_begin: $scope.storeTemp.hours_begin, hours_end: $scope.storeTemp.hours_end, modify_date: modifyDate }; if (action === "address") { store.location = YILOS.DOCPATH + YILOS.ENTERPRISEID + "/images/userImage/map_" + YILOS.ENTERPRISEID; } else { store.location = $scope.storeTemp.location; } //修改该经营项目时不需要更新user字段 if (updateField.length !== 2) { var sqlStr = dataUtils.getUpdateSqlOfObjId(CONSTANT.tb_enterprise, store, updateField); sqlArray.push(sqlStr); } if (action == "operate") { //新增经营项目 _.each($scope.temp.addItems, function (item) { item.create_date = modifyDate; sqlArray.push(dataUtils.getInsertSqlOfObj(CONSTANT.tb_operateItem, item, ["id", "name", "enterprise_id", "create_date"])); }); //删除经营项目 _.each($scope.temp.delItems, function (item) { sqlArray.push(dataUtils.getDelSqlById(CONSTANT.tb_operateItem, item.id)); }); } dataUtils.batchExecuteSql(sqlArray, function (error) { if (error) { utils.showAreaFailMsg("#m-setting-store-edit", "修改失败"); utils.log("m-setting store.js editInfoSave", error); return; } $scope.store = store; //将选择的省市区对象继续保留 $scope.store.selectedProvince = $scope.storeTemp.selectedProvince ? $scope.storeTemp.selectedProvince : ""; $scope.store.selectedCity = $scope.storeTemp.selectedCity ? $scope.storeTemp.selectedCity : ""; $scope.store.selectedArea = $scope.storeTemp.selectedArea ? $scope.storeTemp.selectedArea : ""; $scope.store.admin_account = $scope.storeTemp.admin_account; if (action == "operate") { $scope.operateItem = $scope.operateItemTemp; } $scope.temp.addItems = []; $scope.temp.delItems = []; if (action == "address") { //输入地址后直接保存 var address = $scope.storeTemp.addr_state_city_area + $scope.storeTemp.addr_detail; if ($scope.temp.map) { movePointMap(address, function (error) { if (error) { utils.log("m-setting store.js editInfoSave.movePointMap", error); } $scope.downloadStoreLocImg(); }); } else { initMap(address, function (error) { if (error) { utils.log("m-setting store.js editInfoSave.initMap", error); } $scope.downloadStoreLocImg(); }); } } setTimeout(function () { $scope.digestScope(); $scope.cancel(); }, 2000); database.updateBackupFlag(store.modify_date, YILOS_NAIL_MODULE.ENTERPRISE, null); var storeInfo = { name: store.name, contact_phoneMobile: store.contact_phoneMobile, addr_state_city_area: store.addr_state_city_area, addr_detail: store.addr_detail }; utils.setStoreInfo(storeInfo); utils.showAreaSuccessMsg("#m-setting-store-edit", "修改成功"); }); };
//删除会员、 function deleteMember(memberId, cardId, callback) { var sqlArray = []; sqlArray.push({statement: "delete from tb_member where id = ?;", value: [memberId]}); sqlArray.push({statement: "delete from tb_memberCard where id = ?;", value: [cardId]}); dataUtils.batchExecuteSql(sqlArray, callback); }