from models.AggrType import AggrModelfrom datatypes.Meta import datatypes
class sold(AggrModel): f_RfvxeP = datatypes.Serial(name = "f_RfvxeP" , title = "流水号" , readOnly = 1 , description = "" , placeholder = "" , prefix = "DD" , connector = "" , dateTimeFormat = "YYYYMMDD" , incNum = 2 , startNumber = 1 , fieldId = "") f_FSjPsD = datatypes.AutoInt(name = "f_FSjPsD" , title = "客户" , readOnly = 1 , description = "" , placeholder = "" , relateFieldTitle = "") f_yCneuS = datatypes.Member(name = "f_yCneuS" , title = "业务人员" , readOnly = 1 , description = "" , placeholder = "" , selectionWay = "custom" , availableUser = {} , allowLeave = 0 , mulLevelSelectionConfig = []) f_yibFzQ = datatypes.Dept(name = "f_yibFzQ" , title = "业务部门" , readOnly = 1 , description = "" , placeholder = "" , selectionWay = "custom" , availableDeptId = None , mulLevelSelectionConfig = None , availableParentDeptId = None) f_MfoGRk = datatypes.Money(name = "f_MfoGRk" , title = "订单总价" , readOnly = 1 , description = "" , placeholder = "" , maxDigits = 18 , decimal = 2 , unit = "元") f_AUwaJZ = datatypes.Ltext(name = "f_AUwaJZ" , title = "备注" , readOnly = 1 , description = "" , placeholder = "" , limit = False , maxLen = 1024 , minLen = 0) f_cqanMi = datatypes.File(name = "f_cqanMi" , title = "合同附件" , readOnly = 1 , description = "" , placeholder = "" , maxCount = 5 , maxSize = 20 , selectedDown = False , selectedDelete = False , selectedDownUser = None , selectedDeleteUser = None) f_mFjkNd = datatypes.Date(name = "f_mFjkNd" , title = "签订日期" , readOnly = 1 , description = "" , placeholder = "" , dateTimeType = "DAY" , dateTimeFormat = "YYYY-MM-DD" , createDefault = False , updateDefault = False , autoAssign = None) f_psoTgX = datatypes.Datetime(name = "f_psoTgX" , title = "到期时间" , readOnly = 1 , description = "" , placeholder = "" , dateTimeType = "SECOND" , dateTimeFormat = "YYYY-MM-DD HH:mm:ss" , createDefault = False , updateDefault = False , autoAssign = None) f_EQWzec = datatypes.AutoInt(name = "f_EQWzec" , title = "主键ID" , readOnly = 1 , description = "" , placeholder = "" , maxDigits = 18 , decimal = 0 , unit = None) f_AvbhdP = datatypes.Stext(name = "f_AvbhdP" , title = "客户名称" , readOnly = 1 , description = "" , placeholder = "" , limit = False , maxLen = 255 , minLen = 0) f_PnqDle = datatypes.Radio(name = "f_PnqDle" , title = "客户状态" , readOnly = 1 , description = "" , placeholder = "" , color = True , options = [{"label": "线索", "value": "线索", "style": {"backgroundColor": "#CDE7FF", "color": "#CDE7FF"}}, {"value": "商机", "label": "商机", "style": {"backgroundColor": "#FFDDDA", "color": "#FFDDDA"}}, {"value": "成交", "label": "成交", "style": {"backgroundColor": "#FEEECA", "color": "#FEEECA"}}, {"value": "续签", "label": "续签", "style": {"backgroundColor": "#bddfdb", "color": "#bddfdb"}}] , selectionWay = "custom" , allowManualInput = False , mulLevelSelectionConfig = {"sortFieldName": "", "sortBy": "", "matchFieldName": "", "dataSourceModel": "", "filterValue": ""}) f_zxKYaF = datatypes.Radio(name = "f_zxKYaF" , title = "客户来源" , readOnly = 1 , description = "" , placeholder = "" , color = False , options = [{"label": "渠道", "value": "渠道", "style": {"backgroundColor": "#FFDDDA", "color": "#FFDDDA"}}, {"label": "官网", "value": "官网", "style": {"backgroundColor": "#FEEECA", "color": "#FEEECA"}}, {"label": "推流", "value": "推流", "style": {"backgroundColor": "#E4F7E0", "color": "#E4F7E0"}}, {"label": "自拓客", "value": "自拓客", "style": {"backgroundColor": "#CFEFF4", "color": "#CFEFF4"}}] , selectionWay = "custom" , allowManualInput = False , mulLevelSelectionConfig = {"sortFieldName": "", "sortBy": "", "matchFieldName": "", "dataSourceModel": "", "filterValue": ""}) f_EHcWfP = datatypes.Dropdown(name = "f_EHcWfP" , title = "行业分类" , readOnly = 1 , description = "" , placeholder = "" , color = False , options = [{"label": "A农、林、牧、渔业", "value": "A农、林、牧、渔业", "style": {"backgroundColor": "#FFDDDA", "color": "#FFDDDA"}}, {"label": "B采矿业", "value": "B采矿业", "style": {"backgroundColor": "#FEEECA", "color": "#FEEECA"}}, {"label": "C制造业", "value": "C制造业", "style": {"backgroundColor": "#E4F7E0", "color": "#E4F7E0"}}, {"label": "D电力、热力、燃气及水生产和供应业", "value": "D电力、热力、燃气及水生产和供应业", "style": {"backgroundColor": "#CFEFF4", "color": "#CFEFF4"}}, {"label": "E建筑业", "value": "E建筑业", "style": {"backgroundColor": "#D5F5EF", "color": "#D5F5EF"}}, {"label": "F批发和零售业", "value": "F批发和零售业", "style": {"backgroundColor": "#BED3E5", "color": "#BED3E5"}}] , allowManualInput = False , selectionWay = "custom" , mulLevelSelectionConfig = {"sortFieldName": "", "sortBy": "", "matchFieldName": "", "dataSourceModel": "", "filterValue": ""}) f_ezrBkJ = datatypes.Address(name = "f_ezrBkJ" , title = "客户地址" , readOnly = 1 , description = "" , placeholder = "" , addressFormat = "pca" , detail = True) f_OxygvD = datatypes.Stext(name = "f_OxygvD" , title = "主要联系人" , readOnly = 1 , description = "" , placeholder = "" , limit = False , maxLen = 255 , minLen = 0) f_yresXj = datatypes.Phone(name = "f_yresXj" , title = "手机号" , readOnly = 1 , description = "" , placeholder = "" , rules = 0) f_HcyPMf = datatypes.Member(name = "f_HcyPMf" , title = "业务人员" , readOnly = 1 , description = "" , placeholder = "" , selectionWay = "custom" , availableUser = {} , allowLeave = 0 , mulLevelSelectionConfig = []) f_lbqUwe = datatypes.Radio(name = "f_lbqUwe" , title = "归属情况" , readOnly = 1 , description = "" , placeholder = "" , color = True , options = [{"label": "公海客户", "value": "公海客户", "style": {"backgroundColor": "#CDE7FF", "color": "#CDE7FF"}}, {"label": "私有客户", "value": "私有客户", "style": {"backgroundColor": "#FFDEEB", "color": "#FFDEEB"}}] , selectionWay = "custom" , allowManualInput = False , mulLevelSelectionConfig = {"sortFieldName": "", "sortBy": "", "matchFieldName": "", "dataSourceModel": "", "filterValue": ""}) f_oFQtsh = datatypes.Date(name = "f_oFQtsh" , title = "最新跟进日期" , readOnly = 1 , description = "" , placeholder = "" , dateTimeType = "DAY" , dateTimeFormat = "YYYY-MM-DD" , createDefault = False , updateDefault = False , autoAssign = None) f_KJhDZv = datatypes.Date(name = "f_KJhDZv" , title = "下次跟进日期" , readOnly = 1 , description = "" , placeholder = "" , dateTimeType = "DAY" , dateTimeFormat = "YYYY-MM-DD" , createDefault = False , updateDefault = False , autoAssign = None) class Meta: modelType = "AggrType" db = "" dataTitle = None dbTable = "Select([F(\"T_AjXaRD.drillNo1\", \"f_RfvxeP\"), F(\"T_AjXaRD.customer\", \"f_FSjPsD\"), F(\"T_AjXaRD.salesman\", \"f_yCneuS\"), F(\"T_AjXaRD.operationalComponent\", \"f_yibFzQ\"), F(\"T_AjXaRD.total_price\", \"f_MfoGRk\"), F(\"T_AjXaRD.remarks\", \"f_AUwaJZ\"), F(\"T_AjXaRD.contract_annexs\", \"f_cqanMi\"), F(\"T_AjXaRD.date\", \"f_mFjkNd\"), F(\"T_AjXaRD.f353\", \"f_psoTgX\"), F(\"T_RCAIxV.id\", \"f_EQWzec\"), F(\"T_RCAIxV.cName\", \"f_AvbhdP\"), F(\"T_RCAIxV.status\", \"f_PnqDle\"), F(\"T_RCAIxV.sources\", \"f_zxKYaF\"), F(\"T_RCAIxV.industry\", \"f_EHcWfP\"), F(\"T_RCAIxV.address\", \"f_ezrBkJ\"), F(\"T_RCAIxV.contactor\", \"f_OxygvD\"), F(\"T_RCAIxV.phone\", \"f_yresXj\"), F(\"T_RCAIxV.sales\", \"f_HcyPMf\"), F(\"T_RCAIxV.attribution\", \"f_lbqUwe\"), F(\"T_RCAIxV.latest_followup_date\", \"f_oFQtsh\"), F(\"T_RCAIxV.next_followup_date\", \"f_KJhDZv\")], From([Select([F(\"drillNo1\"), F(\"customer\"), F(\"salesman\"), F(\"operationalComponent\"), F(\"total_price\"), F(\"remarks\"), F(\"contract_annexs\"), F(\"date\"), F(\"f353\")], From([\"models.OrderModel\"])), \"T_AjXaRD\"], LeftJoin(Select([F(\"id\"), F(\"cName\"), F(\"status\"), F(\"sources\"), F(\"industry\"), F(\"address\"), F(\"contactor\"), F(\"phone\"), F(\"sales\"), F(\"attribution\"), F(\"latest_followup_date\"), F(\"next_followup_date\")], From([\"models.CustomerModel\"])),\"T_RCAIxV\"), On([F(\"T_AjXaRD.customer\"), \"=\", F(\"T_RCAIxV.id\")])), \"横向连接\")" name = "sold" baseModel = ""
评论