void MarketingunitController::save(const QString &pk)
{
if (httpRequest().method() != Tf::Post) {
return;
}
QString error;
auto marketingunit = Marketingunit::get(pk.toInt());
if (marketingunit.isNull()) {
error = "Original data not found. It may have been updated/removed by another transaction.";
tflash(error);
redirect(urla("edit", pk));
return;
}
auto form = httpRequest().formItems("marketingunit");
marketingunit.setProperties(form);
if (marketingunit.save()) {
QString notice = "Updated successfully.";
tflash(notice);
redirect(urla("show", pk));
} else {
error = "Failed to update.";
texport(error);
renderEdit(form);
}
}
void EntryController::save(const QString &pk)
{
if (httpRequest().method() != Tf::Post) {
return;
}
QString error;
Entry entry = Entry::get(pk.toInt());
if (entry.isNull()) {
error = "Original data not found. It may have been updated/removed by another transaction.";
tflash(error);
redirect(urla("edit", pk));
return;
}
entry.setProperties( httpRequest().formItems("entry") );
if (entry.save()) {
QString notice = "Updated successfully.";
tflash(notice);
} else {
error = "Failed to update.";
tflash(error);
}
redirect(urla("show", pk));
}
void WorldController::save(const QString &pk)
{
if (httpRequest().method() != Tf::Post) {
return;
}
QString error;
World world = World::get(pk.toUInt());
if (world.isNull()) {
error = "Original data not found. It may have been updated/removed by another transaction.";
tflash(error);
redirect(urla("edit", pk));
return;
}
QVariantMap form = httpRequest().formItems("world");
world.setProperties(form);
if (world.save()) {
QString notice = "Updated successfully.";
tflash(notice);
redirect(urla("show", pk));
} else {
error = "Failed to update.";
texport(error);
renderEdit(form);
}
}
void MarketingunitController::searching() {
QString val = httpRequest().formItemValue("search");
QString error;
if(val.isEmpty()) {
error="请输入查询关键字";
tflash(error);
redirect(urla("index"));
return;
}
QList<Marketingunit> list1;
TSqlQuery query;
query.exec("SELECT * FROM CMS.marketingunit WHERE MUid LIKE '%"+val+"%';");
while(query.next()) {
Marketingunit a;
a.setMuid(query.value(0).toInt());
a.setMuname(query.value(1).toString());
a.setMusname(query.value(2).toString());
a.setMuvalue(query.value(3).toInt());
a.setMudate(query.value(4).toDate());
a.setSrcUnitID(query.value(5).toInt());
a.setDestUnitID(query.value(6).toInt());
a.setOperatorID(query.value(7).toString());
list1.append(a);
}
QList<Marketingunit> list2;
TSqlQuery query2;
query2.exec("SELECT * FROM CMS.marketingunit WHERE MUsname LIKE '%"+val+"%';");
while(query2.next()) {
Marketingunit b;
b.setMuid(query2.value(0).toInt());
b.setMuname(query2.value(1).toString());
b.setMusname(query2.value(2).toString());
b.setMuvalue(query2.value(3).toInt());
b.setMudate(query2.value(4).toDate());
b.setSrcUnitID(query2.value(5).toInt());
b.setDestUnitID(query2.value(6).toInt());
b.setOperatorID(query2.value(7).toString());
list2.append(b);
}
if(list1.isEmpty()&&list2.isEmpty()) {
error="无对应记录";
tflash(error);
redirect(urla("index"));
return;
} else {
texport(list1);
texport(list2);
render();
}
}
void MarketingunitController::showform() {
QString start = httpRequest().formItemValue("start");
QString end = httpRequest().formItemValue("end");
QString error;
QList<Marketingunit> list;
TSqlQuery query;
int c=0;
if(start.isEmpty()&&end.isEmpty()) {
query.exec("SELECT * FROM CMS.marketingunit ORDER BY MUdate;");
} else if(start.isEmpty()||end.isEmpty()) {
error="请输入日期";
tflash(error);
redirect(urla("reportform"));
return;
} else if(start>end) {
error="起始日期应小于截止日期";
tflash(error);
redirect(urla("reportform"));
return;
} else {
query.exec("SELECT * FROM CMS.marketingunit WHERE MUdate BETWEEN '"+start+"' AND '"+end+"' ORDER BY MUdate;");
}
while(query.next()) {
Marketingunit a;
a.setMuid(query.value(0).toInt());
a.setMuvalue(query.value(1).toInt());
a.setMusname(query.value(2).toString());
a.setMuname(query.value(3).toString());
a.setMudate(query.value(4).toDate());
a.setSrcUnitID(query.value(5).toInt());
a.setDestUnitID(query.value(6).toInt());
a.setOperatorID(query.value(7).toString());
c=a.muvalue()+c;
list.append(a);
}
if(list.isEmpty()) {
error="所选日期内无记录";
tflash(error);
redirect(urla("reportform"));
return;
}
texport(list);
texport(c);
render();
}
void CmsController::savemanager(const QString &pk)
{
QString adminID = session().value("adminID").toString();
if (httpRequest().method() != Tf::Post) {
return;
}
QString error;
auto assetsunitmanager = Assetsunitmanager::get(pk);
if (assetsunitmanager.isNull()) {
error = "Original data not found. It may have been updated/removed by another transaction.";
tflash(error);
redirect(urla("change", pk));
return;
}
Cms a;
if(!a.update_manager(adminID,pk))
{
return;
}
auto form = httpRequest().formItems("assetsunitmanager");
assetsunitmanager.setProperties(form);
if (assetsunitmanager.save()) {
redirect(urla("list_manager"));
} else {
error = "Failed to update.";
texport(error);
renderEdit(form);
}
}
void MarketingunitController::searching(){
QString val = httpRequest().formItemValue("muid");
QString error;
auto marketingunit = Marketingunit::get(val.toInt());
if (marketingunit.isNull()) {
error = "关键字不存在";
tflash(error);
redirect(urla("index"));
return;
}else{
redirect(urla("showsearch", val));}
}
void EntryController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
Entry entry = Entry::create( httpRequest().formItems("entry") );
if (!entry.isNull()) {
QString notice = "Created successfully.";
tflash(notice);
redirect(urla("show", entry.id()));
} else {
QString error = "Failed to create.";
texport(error);
render("entry");
}
}
void CmsController::operatorlogin()
{
if(httpRequest().method() != Tf::Post){
return;
}
auto form = httpRequest().formItems("cms");
Cms cms;
if(cms.operatorlogin(form)){
a = form["numberID"].toString();
session().insert("operatorID",a);
redirect(url("assetsunit","index"));
}else{
QString error = "NumberID or Password Error";
tflash(error);
redirect(urla("operator_login"));
}
}
void CmsController::adminlogin()
{
if(httpRequest().method() != Tf::Post){
return;
}
auto form = httpRequest().formItems("cms");
Cms cms;
if(cms.adminlogin(form)){
b = form["numberID"].toString();
session().insert("adminID",b);
redirect(urla("admin_center",b));
}else{
QString error = "NumberID or Password Error";
tflash(error);
redirect(urla("admin_login"));
}
}
void MarketingunitController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
auto form = httpRequest().formItems("marketingunit");
auto marketingunit = Marketingunit::create(form);
if (!marketingunit.isNull()) {
QString notice = "Created successfully.";
tflash(notice);
redirect(urla("show", marketingunit.muid()));
} else {
QString error = "Failed to create.";
texport(error);
renderEntry(form);
}
}
void WorldController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
QVariantMap form = httpRequest().formItems("world");
World world = World::create(form);
if (!world.isNull()) {
QString notice = "Created successfully.";
tflash(notice);
redirect(urla("show", world.id()));
} else {
QString error = "Failed to create.";
texport(error);
renderEntry(form);
}
}
void AssetsunitmanagerController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
auto form = httpRequest().formItems("assetsunitmanager");
auto assetsunitmanager = Assetsunitmanager::create(form);
if (!assetsunitmanager.isNull()) {
QString notice = "Created successfully.";
tflash(notice);
redirect(urla("Cms/list_manager"));
} else {
QString error = "Failed to create.";
texport(error);
renderEntry(form);
}
}
void ParksController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
auto form = httpRequest().formItems("parks");
auto parks = Parks::create(form);
if (!parks.isNull()) {
QString notice = "Created successfully.";
tflash(notice);
redirect(urla("show", parks.id()));
} else {
QString error = "Failed to create.";
texport(error);
renderEntry(form);
}
}
