def city_manager():
conn = DBBuilder.test_db()
# sql = "select t.product_id,t.policy_uuid as uuid,push_money,u.mobile,u.`name`,u.id as userId,ua.total_amount as total_amount from car_insure_policy_allocation t,car_city_manager ct,sales_user u,sales_user_account ua where t.pay_time BETWEEN 1463500800000 and 1463587200000 and ct.user_id = t.sales_user_id and t.policy_status = 200 and ct.user_id = u.id and ct.user_id = ua.user_id"
sql = "select t.policy_uuid as uuid,push_money,u.mobile,u.`name`,u.id as userId,ua.total_amount as total_amount from car_insure_policy_allocation t,sales_user u,sales_user_account ua where t.policy_status = 200 and t.car_number in ('浙A688QH','浙AUR176','浙A4JJ00','浙AV006B','皖A53M19','浙A223QB','浙A6LQ51','浙A0GF33','浙A2XD38','浙J4699T','浙AZ791U','浙A772QF') and t.sales_user_id = u.id and t.sales_user_id = ua.user_id order by t.sales_user_id"
results = conn.fetchDict(sql=sql)
out_r = [parseOutFromRow(row, conn) for row in results]
conn.close()
writeCsv('city.csv', fieldKeys, fieldnames, out_r)
def city_manager():
conn = DBBuilder.online_db()
# sql = "select t.product_id,t.policy_uuid as uuid,push_money,u.mobile,u.`name`,u.id as userId,ua.total_amount as total_amount from car_insure_policy_allocation t,car_city_manager ct,sales_user u,sales_user_account ua where t.pay_time BETWEEN 1463500800000 and 1463587200000 and ct.user_id = t.sales_user_id and t.policy_status = 200 and ct.user_id = u.id and ct.user_id = ua.user_id"
sql = (
"select t.policy_uuid as uuid,(case t.policy_status when 100 then '已支付' when 200 then '出单' when 500 then '已退款' when 700 then '已退保' when 350 then '核保失败' when 180 then '已付款待出单' else '' end )as policyStatus, t.policy_status,"
"t.car_number as carNumber,c.`name` as company,FROM_UNIXTIME(t.pay_time/1000,'%Y-%m-%d') as payTime,FROM_UNIXTIME(t.writer_time/1000,'%Y-%m-%d') as successTime,u.mobile as salesUserName,u.`name` as salesUserMobile,u.id as userId \
from car_insure_policy_allocation t,sales_user u,sales_user_account ua,car_insure_company c where t.sales_user_id = u.id and t.sales_user_id = ua.user_id and t.company_id = c.id \
and t.pay_time BETWEEN 1469980800000 and 1472659200000 order by t.company_id,t.pay_time desc"
)
results = conn.fetchDict(sql=sql)
out_r = [parseOutFromRow(row, conn) for row in results]
conn.close()
writeCsv("all_pay_month8.csv", fieldKeys, fieldnames, out_r)
