mongo-js-20141126

#!/bin/sh# 创建一个0字节文档，如果存在，则清空。:subsidiaryCode.txttlist=`cat ./AccountGuid.txt`;for i in $tlistdoTEMP_LIST=$i;# 打印出$TEMP_LIST取到的值# printf AccountGuid:$TEMP_LIST\n;mysql -h 172.24.0.220 -uquery -pquery che001 -NB EOF

#!/bin/sh# 创建一个0字节文档，如果存在，则清空。:>subsidiaryCode.txttlist=`cat ./AccountGuid.txt`;for i in $tlistdoTEMP_LIST=$i;# 打印出$TEMP_LIST取到的值# printf "AccountGuid:$TEMP_LIST\n";mysql -h 172.24.0.220 -uquery -pquery che001 -NB < Referal_user_Id.txtselect ReferalGuid,UserGuid from KyPayAccounts where AccountGuid='$TEMP_LIST';EOF#获取Referal_user_IdReferal_user_Id=`cat ./Referal_user_Id.txt`;#判断Referal_user_Id是否为空if [ "$Referal_user_Id"x = x ]thenecho "Error: failed to get AccountGuid $TEMP_LIST date , Referal_user_Id in not exist !";#exit -1fiReferalId=`echo "$Referal_user_Id"|awk '{print $1}'`;userId=`echo "$Referal_user_Id"|awk '{print $2}'`;mongo --quiet localhost:27020/che001 -uquery -pquery <>subsidiaryCode.txt//mongo --quiet localhost:27020/che001 -uquery -pquery << EOFvar subsidiaryCode="";var employee=db.employee.find({"userId" :'$ReferalId'},{"store" :1,"logicalDel" : 1})while(employee.hasNext()){var employee2=employee.next();//print("sroteId:"+employee2.store);if( typeof(employee2.store) != "undefined"){var t_store=employee2.store;var logicalDel=employee2.logicalDel;}else{//print(&#<b style="color:transparent">本文来源gao@!dai!ma.com搞$$代^@码!网!</b>39;$TEMP_LIST'+","+'$ReferalId'+",employee.store in not exist !");break ;}var store=db.store.find({"id" :t_store},{"subsidiaryInfo.subsidiaryCode" :1})while(store.hasNext()){var store2=store.next();//print("subsidiaryCode:"+store2.subsidiaryInfo.subsidiaryCode);var subsidiaryCode=store2.subsidiaryInfo.subsidiaryCode;}var contract=db.contract.find({"userId" :'$userId'})while(contract.hasNext()){var contract2=contract.next();//print(contract2.data.doc_cnt_number);var doc_cnt_number=contract2.data.doc_cnt_number}var user=db.user.find({"id" :'$userId'})while(user.hasNext()){var user2=user.next();//print(user2.username);var username=user2.username}var serviceAccount=db.serviceAccount.find({"userId" :'$userId'})while(serviceAccount.hasNext()){var serviceAccount2=serviceAccount.next();//print(serviceAccount2.fullName);var fullName=serviceAccount2.fullName}print(""+'$TEMP_LIST'+","+subsidiaryCode+",logicalDel:"+logicalDel+","+doc_cnt_number+","+username+","+fullName);}EOFdone

喜欢 (0)赏

[搞代码]

分享 (0)