public ActionResult Filter(int id)
{
object viewModel = null;
ViewBag.title = this._report[id];
switch (id)
{
case 5:
ViewBag.type = new SortedList()
{
{ 1, "盈電工程有限公司" },
{ 2, "盈電機電工程有限公司" }
};
break;
case 7:
ViewBag.type = new SortedList()
{
{ 1, "All Billed ACQ" },
{ 2, "Billed ACQ with Dummy Invoice Only" },
{ 3, "Billed ACQ with invoice Number" }
};
break;
case 8:
ViewBag.dummy = new SortedList()
{
{ 1, "All" },
{ 2, "With Dummy Invoice" },
{ 3, "Without Dummy Invoice" }
};
break;
case 9:
viewModel = new Report9Model()
{
types = new Report9ModelType[] { Report9ModelType.Maintenance, Report9ModelType.Quotation }
};
break;
case 11:
ViewBag.region = this.getRegion();
viewModel = new Report11Model()
{
order_date = DateTime.Today.ToString("dd-MM-yyyy"),
//order_date_required = true
};
break;
case 12:
ViewBag.engineer = this.getEngineer();
break;
case 13:
ViewBag.type = new SortedList()
{
{ 1, "Invoice" },
{ 2, "Quotation" }
};
ViewBag.type2 = new SortedList()
{
{ 1, "for Maintenance Contract (ACM)" },
{ 2, "for Quotation (ACQ)" }
};
break;
case 14:
ViewBag.type = new SortedList()
{
{ 1, "All" },
{ 2, "T&C Only" },
{ 3, "Not T&C Only" },
{ 4, "Without Service Date" }
};
break;
case 15:
ViewBag.region = this.getRegion();
break;
case 16:
//ViewBag.type = _bank;
break;
case 17:
ViewBag.region = this.getRegion();
break;
case 19:
Report19Model repot19model = new Report19Model();
repot19model.Modes = new Report19ModelMode[] { Report19ModelMode.By_Category, Report19ModelMode.By_Employee, Report19ModelMode.By_Sub__Contractor, Report19ModelMode.By_Supplier, Report19ModelMode.By_Minor_Work };
repot19model.CostCategories = this.getCosts();
repot19model.Suppliers = this.getSuppliers();
viewModel = repot19model;
break;
case 20:
ViewBag.order_status = new SortedList()
{
{ 1, "預約保養" },
{ 2, "做保養" },
{ 3, "完成保養" }
};
break;
case 21:
//ViewBag.district = this.getDistrict();
var district = (from d in this._db.recsys_district
where d.status == 1 && (d.name == "帝琴灣" || d.name == "爵悅庭")
orderby d.region ascending
select d);
ViewBag.district = Common.array_conv(Common.query(district), "id", "name");
break;
case 22:
Report22Model report22Model = new Report22Model();
report22Model.show_printed = false;
viewModel = report22Model;
break;
}
return View("Report" + id, viewModel);
}
public ActionResult Report11(Report11Model model)
{
//return Pdf("/reportsgen/report11/", this._report[11].ToString(), false);
return new ReportsGenController().Report11(model);
}
public ActionResult Report11(Report11Model model)
{
string order_id = model.order_id;
string order_date = model.order_date;
string customer_code = model.customer_code;
string customer_name = model.customer_name;
ReportDailyECall.ReportModel reportModel = new ReportDailyECall.ReportModel();
ArrayList where = new ArrayList();
if (!String.IsNullOrWhiteSpace(order_id))
where.Add("o.id = '" + order_id + "'");
if (model.choose_region.Trim().Length > 0)
{
string[] chosenRegionList = model.choose_region.Split(',');
string regionIDFilter = string.Empty;
string regionNullFilter = " rg.id is null ";
bool isRegionNullFilterChoose = false;
foreach (var regionId in chosenRegionList)
{
if (regionId.Equals("-1"))
isRegionNullFilterChoose = true;
else
{
regionIDFilter += regionId + ",";
}
}
if (isRegionNullFilterChoose)
{
if (!string.IsNullOrEmpty(regionIDFilter))
where.Add("(rg.id in ( " + regionIDFilter.TrimEnd(',') + " ) or " + regionNullFilter + " )");
else
where.Add(regionNullFilter);
}
else
{
where.Add("rg.id in ( " + regionIDFilter.TrimEnd(',') + " )");
}
}
else
{
return Content("找不到任何紀錄。");
}
//if (model.order_date_required)
//{
if (!string.IsNullOrEmpty(model.order_date))
{
where.Add(string.Format("o.repair_date >= '{0}' AND o.repair_date < DATEADD(day, 1, '{0}')", ConvertDateStringFormat(model.order_date, DATEPICKER_DATE_FORMAT, DB_DATE_FORMAT)));
ViewBag.date = Common.to_date("d/M/yyyy", DateTime.ParseExact(model.order_date, DATEPICKER_DATE_FORMAT, null));
}
else
{
where.Add(string.Format("o.repair_date >= '{0}' AND o.repair_date < DATEADD(day, 1, '{0}')", DateTime.Today.ToString(DB_DATE_FORMAT)));
ViewBag.date = Common.to_date("d/M/yyyy", DateTime.Today);
}
//}
//else
//{
// where.Add(" o.repair_date is null ");
// ViewBag.date = "";
//}
if (model.MasterCustomerID.HasValue)
where.Add("c.customer_id = " + model.MasterCustomerID.Value);
string sql = @"
select
o.id, o.repair_date, o.start_time, o.end_time, o.remark, o.fault,
pu.name as recipient, e1.name as technician1, e2.name as technician2, e3.name as technician3, e4.name as technician4, o.reviewer,
c.customer_code, c.name AS customer_name, c.address2, c.tel1,
c.type, c.code, c.manual_input_code, c.prefix,
c.contact, c.title, rg.name as region_name, rg.id as region_id,
c.customer_code as customer_code
from recsys_order as o
left outer join recsys_relate_customers as c on o.customer_id = c.id
left outer join recsys_district as d on c.district2 = d.id
left outer join recsys_region as rg on d.region = rg.id
left outer join recsys_users as pu on o.call_pickup_user_id = pu.id
left outer join recsys_users as e1 on o.engineer_id_1 = e1.id
left outer join recsys_users as e2 on o.engineer_id_2 = e2.id
left outer join recsys_users as e3 on o.engineer_id_3 = e3.id
left outer join recsys_users as e4 on o.engineer_id_4 = e4.id
where o.status = '1' AND o.order_status = '2'
" + (where.Count > 0 ? " AND " + String.Join(" AND ", where.ToArray()) : String.Empty) + @"
order by o.repair_date desc";
reportModel.Records = Common.queryToObject<ReportDailyECall.RecordModel>(this._db.ExecuteStoreQuery<ReportDailyECall.RecordModel>(sql)).ToList();
if (reportModel.Records.Count() > 0)
{
//ViewBag.date = Common.to_date("d/M/yyyy", DateTime.Now);
return View("~/Views/ReportsGen/Report11.cshtml", reportModel);
}
else
{
return Content("找不到任何紀錄。");
}
}