TYPE=VIEW
query=select `wmsdb`.`t_operflow`.`operFlowId` AS `operFlowId`,`wmsdb`.`t_operflow`.`demanderId` AS `demanderId`,`wmsdb`.`t_operflow`.`demandNo` AS `demandNo`,`wmsdb`.`t_operflow`.`goodsId` AS `goodsId`,`wmsdb`.`t_operflow`.`productBatch` AS `productBatch`,`wmsdb`.`t_operflow`.`quantity` AS `quantity`,`wmsdb`.`t_operflow`.`operTime` AS `operTime`,`wmsdb`.`t_operflow`.`locationId` AS `locationId`,`wmsdb`.`t_operflow`.`locationId2` AS `locationId2`,`wmsdb`.`t_operflow`.`operType` AS `operType`,`wmsdb`.`t_operflow`.`userId` AS `userId`,`wmsdb`.`t_operflow`.`causeId` AS `causeId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_warehousearea`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaId` AS `areaId`,`t_warehouselocation2`.`locationNo` AS `locationNo2`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_operflow`.`supplierId` AS `supplierId`,`wmsdb`.`t_warehouselocation`.`status` AS `locationStatus`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_goods`.`gcId` AS `gcId`,`wmsdb`.`t_dict`.`dictName` AS `causeName`,`wmsdb`.`t_staff`.`staffName` AS `staffName`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName` from (((((((((`wmsdb`.`t_operflow` left join `wmsdb`.`t_demander` on((`wmsdb`.`t_operflow`.`demanderId` = `wmsdb`.`t_demander`.`demanderId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_operflow`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_goods` on((`wmsdb`.`t_operflow`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_operflow`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) left join `wmsdb`.`t_warehouselocation` `t_warehouselocation2` on((`t_warehouselocation2`.`locationId` = `wmsdb`.`t_operflow`.`locationId2`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_dict`.`dictId` = `wmsdb`.`t_operflow`.`causeId`))) join `wmsdb`.`t_staff` on((`wmsdb`.`t_staff`.`staffId` = `wmsdb`.`t_operflow`.`userId`))) left join `wmsdb`.`t_instockdemandbill` on((`wmsdb`.`t_operflow`.`demandNo` = `wmsdb`.`t_instockdemandbill`.`demandNo`)))
md5=a08f0060aaaaf7f015318ff2a425d40e
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:00
create-version=1
source=select `t_operflow`.`operFlowId` AS `operFlowId`,`t_operflow`.`demanderId` AS `demanderId`,`t_operflow`.`demandNo` AS `demandNo`,`t_operflow`.`goodsId` AS `goodsId`,`t_operflow`.`productBatch` AS `productBatch`,`t_operflow`.`quantity` AS `quantity`,`t_operflow`.`operTime` AS `operTime`,`t_operflow`.`locationId` AS `locationId`,`t_operflow`.`locationId2` AS `locationId2`,`t_operflow`.`operType` AS `operType`,`t_operflow`.`userId` AS `userId`,`t_operflow`.`causeId` AS `causeId`,`t_goods`.`goodsCode` AS `goodsCode`,`t_goods`.`goodsName` AS `goodsName`,`t_warehouselocation`.`locationNo` AS `locationNo`,`t_warehousearea`.`areaName` AS `areaName`,`t_warehousearea`.`areaNature` AS `areaNature`,`t_warehousearea`.`areaId` AS `areaId`,`t_warehouselocation2`.`locationNo` AS `locationNo2`,`t_supplier`.`supplierName` AS `supplierName`,`t_operflow`.`supplierId` AS `supplierId`,`t_warehouselocation`.`status` AS `locationStatus`,`t_warehousearea`.`status` AS `areaStatus`,`t_supplier`.`status` AS `supplierStatus`,`t_goods`.`gcId` AS `gcId`,`t_dict`.`dictName` AS `causeName`,`t_staff`.`staffName` AS `staffName`,`t_dict`.`status` AS `causeStatus`,`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`t_demander`.`demanderName` AS `demanderName` from (((((((((`t_operflow` left join `t_demander` on((`t_operflow`.`demanderId` = `t_demander`.`demanderId`))) left join `t_supplier` on((`t_operflow`.`supplierId` = `t_supplier`.`supplierId`))) join `t_goods` on((`t_operflow`.`goodsId` = `t_goods`.`goodsId`))) join `t_warehouselocation` on((`t_operflow`.`locationId` = `t_warehouselocation`.`locationId`))) join `t_warehousearea` on((`t_warehouselocation`.`areaId` = `t_warehousearea`.`areaId`))) left join `t_warehouselocation` `t_warehouselocation2` on((`t_warehouselocation2`.`locationId` = `t_operflow`.`locationId2`))) join `t_dict` on((`t_dict`.`dictId` = `t_operflow`.`causeId`))) join `t_staff` on((`t_staff`.`staffId` = `t_operflow`.`userId`))) left join `t_instockdemandbill` on((`t_operflow`.`demandNo` = `t_instockdemandbill`.`demandNo`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_operflow`.`operFlowId` AS `operFlowId`,`wmsdb`.`t_operflow`.`demanderId` AS `demanderId`,`wmsdb`.`t_operflow`.`demandNo` AS `demandNo`,`wmsdb`.`t_operflow`.`goodsId` AS `goodsId`,`wmsdb`.`t_operflow`.`productBatch` AS `productBatch`,`wmsdb`.`t_operflow`.`quantity` AS `quantity`,`wmsdb`.`t_operflow`.`operTime` AS `operTime`,`wmsdb`.`t_operflow`.`locationId` AS `locationId`,`wmsdb`.`t_operflow`.`locationId2` AS `locationId2`,`wmsdb`.`t_operflow`.`operType` AS `operType`,`wmsdb`.`t_operflow`.`userId` AS `userId`,`wmsdb`.`t_operflow`.`causeId` AS `causeId`,`wmsdb`.`t_goods`.`goodsCode` AS `goodsCode`,`wmsdb`.`t_goods`.`goodsName` AS `goodsName`,`wmsdb`.`t_warehouselocation`.`locationNo` AS `locationNo`,`wmsdb`.`t_warehousearea`.`areaName` AS `areaName`,`wmsdb`.`t_warehousearea`.`areaNature` AS `areaNature`,`wmsdb`.`t_warehousearea`.`areaId` AS `areaId`,`t_warehouselocation2`.`locationNo` AS `locationNo2`,`wmsdb`.`t_supplier`.`supplierName` AS `supplierName`,`wmsdb`.`t_operflow`.`supplierId` AS `supplierId`,`wmsdb`.`t_warehouselocation`.`status` AS `locationStatus`,`wmsdb`.`t_warehousearea`.`status` AS `areaStatus`,`wmsdb`.`t_supplier`.`status` AS `supplierStatus`,`wmsdb`.`t_goods`.`gcId` AS `gcId`,`wmsdb`.`t_dict`.`dictName` AS `causeName`,`wmsdb`.`t_staff`.`staffName` AS `staffName`,`wmsdb`.`t_dict`.`status` AS `causeStatus`,`wmsdb`.`t_instockdemandbill`.`deliveryCompany` AS `deliveryCompany`,`wmsdb`.`t_instockdemandbill`.`deliveryman` AS `deliveryman`,`wmsdb`.`t_instockdemandbill`.`vehicleNo` AS `vehicleNo`,`wmsdb`.`t_demander`.`demanderName` AS `demanderName` from (((((((((`wmsdb`.`t_operflow` left join `wmsdb`.`t_demander` on((`wmsdb`.`t_operflow`.`demanderId` = `wmsdb`.`t_demander`.`demanderId`))) left join `wmsdb`.`t_supplier` on((`wmsdb`.`t_operflow`.`supplierId` = `wmsdb`.`t_supplier`.`supplierId`))) join `wmsdb`.`t_goods` on((`wmsdb`.`t_operflow`.`goodsId` = `wmsdb`.`t_goods`.`goodsId`))) join `wmsdb`.`t_warehouselocation` on((`wmsdb`.`t_operflow`.`locationId` = `wmsdb`.`t_warehouselocation`.`locationId`))) join `wmsdb`.`t_warehousearea` on((`wmsdb`.`t_warehouselocation`.`areaId` = `wmsdb`.`t_warehousearea`.`areaId`))) left join `wmsdb`.`t_warehouselocation` `t_warehouselocation2` on((`t_warehouselocation2`.`locationId` = `wmsdb`.`t_operflow`.`locationId2`))) join `wmsdb`.`t_dict` on((`wmsdb`.`t_dict`.`dictId` = `wmsdb`.`t_operflow`.`causeId`))) join `wmsdb`.`t_staff` on((`wmsdb`.`t_staff`.`staffId` = `wmsdb`.`t_operflow`.`userId`))) left join `wmsdb`.`t_instockdemandbill` on((`wmsdb`.`t_operflow`.`demandNo` = `wmsdb`.`t_instockdemandbill`.`demandNo`)))
