{
  "dBType" : "MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeConds" : [ {
    "condType" : "CUSTOM",
    "customCond" : "t21.IBIZORDERID is not null",
    "name" : "查询条件"
  }, {
    "condType" : "CUSTOM",
    "customCond" : "( t21.IBIZORDERID =  ${srfwebcontext('srfkeys','{\"defname\":\"IBIZORDERID\",\"dename\":\"IBIZORDER\"}')} )",
    "name" : "查询条件"
  } ],
  "queryCode" : "SELECT\nt1.`QUANTITY`*t11.`UNITPRICE` AS `AMOUNT`,\nt1.`IBIZORDERDETAILNAME`,\nt11.`IBIZUNIPRODUCTNAME`,\nt21.`ORDERUID`,\nt1.`QUANTITY`,\nt11.`UNIT`,\nt11.`UNITPRICE`\nFROM `T_IBIZORDERDETAIL` t1 \nLEFT JOIN T_IBIZUNIPRODUCT t11 ON t1.IBIZUNIPRODUCTID = t11.IBIZUNIPRODUCTID \nLEFT JOIN T_IBIZORDER t21 ON t1.IBIZORDERID = t21.IBIZORDERID",
  "id" : "PSMODULES/Sample/PSDATAENTITIES/IBIZOrder/PSDEDATAQUERIES/CSDY/PSDEDQCODES/MYSQL5.json"
}