export_income_proxy.sh 922 B

1234567891011
  1. #!/bin/bash
  2. dealerId=$1
  3. for dealerId in $@
  4. do
  5. if [! -e dealer_income_proxies_${dealerId}.csv]; then
  6. mongoexport --host 172.16.69.131 --port 27228 --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin -u guanli -p 75558195de6ac016bb15c05d07e08024 -d report -c dealer_income_proxies -q '{"dealerIds":{"$oid":"'${dealerId}'"}}' -f ref_id,title,totalAmount,dealerIds,actualAmountMap,groupId,logicalCode,partition,dateTimeAdded --type csv -o dealer_income_proxies_${dealerId}.csv
  7. mongoexport --host 172.16.145.62 --port 20000 --authenticationMechanism=SCRAM-SHA-1 --authenticationDatabase=admin -u guanli -p 67374030857714990597992655453345 -d report_his -c dealer_income_proxies -q '{"dealerIds":{"$oid":"'${dealerId}'"}}' -f ref_id,title,totalAmount,dealerIds,actualAmountMap,groupId,logicalCode,partition,dateTimeAdded --type csv -o dealer_income_proxies_his_${dealerId}.csv
  8. fi
  9. done