void CmsController::renderEntry(const QVariantMap &cms)
{
QString adminID = session().value("adminID").toString();
texport(cms);
texport(adminID);
render("entry");
}
void CmsController::renderEdit(const QVariantMap &operators)
{
QString adminID = session().value("adminID").toString();
texport(operators);
texport(adminID);
render("edit");
}
void CmsController::list_manager()
{
QString adminID = session().value("adminID").toString();
Assetsunitmanager form;
QList<Assetsunitmanager> manager_list = form.list_manager();
texport(adminID);
texport(manager_list);
render("list_manager");
}
void CmsController::list_operator(const QString &adminID)
{
//QList<Operators> list_operator();
Operators form;
QList<Operators> operator_list = form.list_operator(adminID);
texport(operator_list);
//QString adminID = session().value("adminID").toString();
texport(adminID);
render("list_operator");
}
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::index()
{
QString hpage = httpRequest().formItemValue("page");
int tpage=0,trec=0,spage,epage,page;
QString spage1,epage1,warning;
TSqlQuery query;
query.exec("SELECT * FROM CMS.marketingunit;");
while(query.next()) {
trec=trec+1;
}
tpage=trec/5;
if(tpage*5<trec)tpage=tpage+1;
if(hpage.isNull()) {
page=1;
} else {
page=hpage.toInt();
}
if(page<1) {
page=1;
warning="当前为最前页";
} else if(page>tpage) {
page=tpage;
warning="当前为最后页";
}
epage=page*5;
spage=epage-5;
spage1=QString::number(spage);
epage1=QString::number(epage);
QList<Marketingunit> marketingunitList;
TSqlQuery query2;
query2.exec("SELECT * FROM CMS.marketingunit LIMIT "+spage1+","+epage1+";");
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());
marketingunitList.append(b);
}
texport(warning);
texport(page);
texport(tpage);
texport(marketingunitList);
render();
}
void CmsController::show_manager(const QString &pk)
{
auto assetsunitmanager = Assetsunitmanager::get(pk);
if(assetsunitmanager.isNull()){
QString error = "该资产管理人不存在!";
texport(error);
texport(assetsunitmanager);
render();
}else{
texport(assetsunitmanager);
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 SessionController::login()
{
if (httpRequest().method() != Tf::Post) {
return;
}
QString password_md5;
QByteArray bb;
QString username = httpRequest().formItemValue("username");
QString password = httpRequest().formItemValue("password");
bb = QCryptographicHash::hash ( password.toLocal8Bit(), QCryptographicHash::Md5 );
password_md5.append(bb.toHex());
Admin admin = Admin::authenticate(username, password_md5);
if(!admin.isNull()) {
userLogin(&admin);
redirect(QUrl("/admin/dashboard"));
} else {
QString message = "Login failed";
texport(message);
redirect(url("session", "form"));
}
}
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 CmsController::show_operator(const QString &pk)
{
auto operators = Operators::get(pk);
QString adminID = session().value("adminID").toString();
if(operators.isNull()){
QString error = "该操作员不存在!";
texport(error);
texport(adminID);
texport(operators);
render();
}else{
texport(adminID);
texport(operators);
render();
}
}
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::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::edit(const QString &pk)
{
Entry entry = Entry::get(pk.toInt());
if (!entry.isNull()) {
texport(entry);
render();
} else {
redirect(urla("entry"));
}
}
void FortuneController::index()
{
QList<Fortune> fortuneList = Fortune::getAll();
Fortune fortune;
fortune.setMessage(QLatin1String("Additional fortune added at request time."));
fortuneList << fortune;
// Sort
qSort(fortuneList.begin(), fortuneList.end(), caseSensitiveLessThan);
texport(fortuneList);
render();
}
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 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 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 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);
}
}
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 CmsController::createmanager()
{
QString adminID = session().value("adminID").toString();
if (httpRequest().method() != Tf::Post) {
return;
}
auto form = httpRequest().formItems("assetsunitmanager");
QString managerID = form["managerID"].toString();
Assetsunitmanager a;
auto assetsunitmanager = a.create(form);
if(!assetsunitmanager.isNull() && a.new_manager(adminID,managerID)){
// QString adminID = session().value("adminID").toString();
redirect(urla("list_manager"));
}else{
QString error = "资产管理人编号已经存在!";
texport(error);
renderEntry2(form);
}
}
void CmsController::create()
{
if (httpRequest().method() != Tf::Post) {
return;
}
auto form = httpRequest().formItems("operators");
QString ID = form["operatorID"].toString();
auto operators = Operators::create(form);
Cms cms;
if (!operators.isNull() && cms.checkoperatorID(ID)) {
QString adminID = session().value("adminID").toString();
QString notice = form["operatorID"].toString();
if(cms.insert_connection(adminID,notice)){
redirect(urla("list_operator", adminID));
}
} else {
QString error = "操作员编号已经存在!";
texport(error);
renderEntry(form);
}
}
void MarketingunitController::show(const QString &pk)
{
auto marketingunit = Marketingunit::get(pk.toInt());
texport(marketingunit);
render();
}
void MarketingunitController::index()
{
QList<Marketingunit> marketingunitList = Marketingunit::getAll();
texport(marketingunitList);
render();
}
void WorldController::renderEdit(const QVariantMap &world)
{
texport(world);
render("edit");
}
void WorldController::renderEntry(const QVariantMap &world)
{
texport(world);
render("entry");
}
void WorldController::index()
{
QList<World> worldList = World::getAll();
texport(worldList);
render();
}
void WorldController::show(const QString &pk)
{
World world = World::get(pk.toUInt());
texport(world);
render();
}
void MarketingunitController::renderEdit(const QVariantMap &marketingunit)
{
texport(marketingunit);
render("edit");
}
void AssetsunitmanagerController::renderEdit(const QVariantMap &assetsunitmanager)
{
texport(assetsunitmanager);
render("edit");
}
