#!/bin/bash
LISTARQTMP=50claro.csv


for listIdArqTmp in $(cat $LISTARQTMP)
do

varid="`echo $listIdArqTmp|awk -F ";" '{print $1}'`";
varestado="`echo $listIdArqTmp|awk -F ";" '{print $2}'`";
varddd="`echo $listIdArqTmp|awk -F ";" '{print substr ($3, 0, 2)}'`";
varcelular="`echo $listIdArqTmp|awk -F ";" '{print substr ($3, 3 )}'`";
varnumfull="`echo $listIdArqTmp|awk -F ";" '{print $3}'`";
varlistagem="`echo $listIdArqTmp|awk -F ";" '{print $4}'`";
varoperadora="`echo $listIdArqTmp|awk -F ";" '{print $5}'`";


temportabilidade=$(mysql -u root -pCodex#2015<<EOFMYSQL
use gsmVOICEsbc;
SELECT operadora FROM portabilidade WHERE numero like '$varddd' AND numero='$varcelular' limit 1;
EOFMYSQL)

echo -e "$temportabilidade"

if [ "$temportabilidade" == "" ]
then
CHECKOPERA=$(mysql -u root -pCodex#2015<<EOFMYSQL
use gsmVOICEsbc;
SELECT operadora FROM prefixos_anatel where prefixo=SUBSTRING('$varnumfull',1,length(prefixo)) ORDER BY LENGTH(prefixo) DESC LIMIT 1;
EOFMYSQL)

case $CHECKOPERA in
        55321)echo -e "CLARO"
		echo -e "FIM";;

        55331)echo -e "OI"
        echo -e "FIM OI" ;;

        55324)echo -e "OI"
        echo -e "FIM OI" ;;

        55314)echo -e "OI"
        echo -e "FIM OI" ;;

        55351)echo -e "NEXTEL"
        echo -e "FIM NEXTEL" ;;

        55377)echo -e "NEXTEL"
        echo -e "FIM NEXTEL" ;;

        55315)echo "VIVO"
        echo -e "FIM VIVO" ;;

        55320)echo "VIVO"
        echo -e "FIM VIVO" ;;

        55323)echo "VIVO"
        echo -e "FIM VIVO" ;;

        55341)echo "TIM"
        echo -e "FIM TIM" ;;
esac

else
        echo -e "$temportabilidade"
fi

done