#!/bin/sh

fromdos TOPROD TOOFFR
grep '|' TOPROD|grep -vi select |sed 's/ *//g;s/^/$q[/;s/x/]=array(/;s/|/,/;s/\:/,\"/;s/$/\"\)\;/' > TOPROD_
grep '|' TOOFFR|grep -vi select |perl -p -w -e \
's/ *//g;s/^(.*)x(.*)\|(.*)\:(.*)\+(.*)$/\$ofpr[$1][]\=$2\; \$ofpw[$1][$2]\="$4"\; $3/;' - > TOOFFR_
grep '|' TOOFFR_BYHAND          |perl -p -w -e \
's/ *//g;s/^(.*)x(.*)\|(.*)\:(.*)\+(.*)$/\$ofpr[$1][]\=$2\; \$ofpw[$1][$2]\="$4"\; $3/;' - >> TOOFFR_
grep '|' TOOFFR_DIGIFON         |perl -p -w -e \
's/ *//g;s/^(.*)x(.*)\|(.*)\:(.*)\+(.*)$/\$ofpr[$1][]\=$2\; \$ofpw[$1][$2]\="$4"\; $3/;' - >> TOOFFR_
#'s/ *//g;s/^(.*)x(.*)\|(.*)\:(.*)\+(.*)$/\$ofpr[$1][]\=$2\; \$ofpw[$1][$2]\="$4"\; \$ofel[$1][$2]\=$5\; $3/;' - > TOOFFR_

php change_n2i.php -a change_n2i > change_n2i.doit
chmod 755                          change_n2i.doit
                                 ./change_n2i.doit

f=alloffers_
#m g=_product
h=mindenusp_ #h=uspoffers_ - nem ezt használjuk
j=tdsloffers_
#k masra kell
l=_VOIP

echo "<?php" > $f\n
echo "<?php" > $f\i
#m echo "<?php" > $g

grep    " N$" TOOFFR_ |sed 's/ N$//'>> $f\n
grep -v " N$" TOOFFR_ |sed 's/ .$//'>> $f\i

#Kiküszöbölendő offerek
k=kiv_
cp $f\i $k\i
cp $f\n $k\n
cat noff        |xargs -iQ perl -pi -w -e 's/^(\$ofpr\['Q'\])/\/\/$1/' $k\i
cat noff        |xargs -iQ perl -pi -w -e 's/^(\$ofpr\['Q'\])/\/\/$1/' $k\n
cat noff_DIGIFON|xargs -iQ perl -pi -w -e 's/^(\$ofpr\['Q'\])/\/\/$1/' $k\i
cat noff_DIGIFON|xargs -iQ perl -pi -w -e 's/^(\$ofpr\['Q'\])/\/\/$1/' $k\n
mv $k\i $f\i
mv $k\n $f\n

#korábbi make_alluspnrs
echo '<?php $alluspnrs=array('                   >_alluspnrs
grep USPP TOPROD|perl -p -w -e's/^ +//;s/ .*/,/'>>_alluspnrs
A=$(tail -n1 _alluspnrs); B=$(echo $A|sed 's/,//'); perl -pi -w -e "s/^$A\n/$B/" _alluspnrs
echo ');?>'                                     >>_alluspnrs

echo "<?php" > $h\n
echo "<?php" > $h\i
uspmeret=$(cat _alluspnrs|wc -l)
for i in $(/usr/bin/seq 2 $uspmeret); do
#vhogy elromlott: USP=$(cat _alluspnrs|awk -F',|)' "NR==$i {print \$1 }");
USP=$(cat _alluspnrs|perl -p -w -e 's/,//g;s/\).*//g' - |awk "NR==$i {print $1 }");

#echo "QQQQQ" $USP >>$h\n
#echo "QQQQQ" $USP >>$h\i
grep "\=$USP\;" $f\n $f\i|perl -p -w -e 's/.*?\[(.*?)\].*/$1/' -|xargs -iQ grep 'ofpr\['Q $f\n>>$h\n
grep "\=$USP\;" $f\n $f\i|perl -p -w -e 's/.*?\[(.*?)\].*/$1/' -|xargs -iQ grep 'ofpr\['Q $f\i>>$h\i
#Nem hiba itt a két^^ fájl, mert először csak az offer_nr-eket keressük
#x eredeti egyusp-s: grep "\=$USP\;" $f\n $f\i|perl -p -w -e 's/.*?\[(.*?)\].*/$1/' -|xargs -iQ grep 'ofpr\['Q $f\n>>$h\n
#x eredeti egyusp-s: grep "\=$USP\;" $f\n $f\i|perl -p -w -e 's/.*?\[(.*?)\].*/$1/' -|xargs -iQ grep 'ofpr\['Q $f\i>>$h\i
done
echo "?>"   >> $h\n
echo "?>"   >> $h\i

echo "<?php" > $j\n
echo "<?php" > $j\i
cat tdsl|xargs -iQ grep 'ofpr\['Q $f\i>>$j\i
cat tdsl|xargs -iQ grep 'ofpr\['Q $f\n>>$j\n
echo "?>"   >> $j\n
echo "?>"   >> $j\i

perl -p -w -e 's/^(.*?)\t.*?\t.*?\t.*?\t(.*?)/$1:$2/' $l |sort -u > $l\_dict # Azaz ebből ezt: VSZLA   N   40395   EGYN    VOIP_SZLACSOKK_2010_tech =>VSZLA:VOIP_SZLACSOKK_2010_tech

echo '<?php' > $l\_i
echo '<?php' > $l\_n
grep '  I   ' $l | perl -p -w -e 's/^(.*?)\t.*?\t(.*?)\t(.*?)\t.*?$/\$ofpr\["$1"\]\[\]=$2\;  \$ofpw\["$1"\]\[$2\]="$3"\;/' - >> $l\_i
grep '  N   ' $l | perl -p -w -e 's/^(.*?)\t.*?\t(.*?)\t(.*?)\t.*?$/\$ofpr\["$1"\]\[\]=$2\;  \$ofpw\["$1"\]\[$2\]="$3"\;/' - >> $l\_n
grep '  I   ' $l | perl -p -w -e 's/^(.*?)\t.*?\t(.*?)\t(.*?)\t.*?$/\$ofpr\["$1"\]\[\]=$2\;  \$ofpw\["$1"\]\[$2\]="$3"\;/' - |grep -v '\[\"1' >> $f\i #alloffers-be is - de a már meglevő számosokat kiszűrjük. Lesznek betűvel ábrázolt offeres duplikációk
grep '  N   ' $l | perl -p -w -e 's/^(.*?)\t.*?\t(.*?)\t(.*?)\t.*?$/\$ofpr\["$1"\]\[\]=$2\;  \$ofpw\["$1"\]\[$2\]="$3"\;/' - |grep -v '\[\"1' >> $f\n #alloffers-be is - de a már meglevő számosokat kiszűrjük. Lesznek betűvel ábrázolt offeres duplikációk
echo '?>' >> $l\_i
echo '?>' >> $l\_n
echo '?>' >> $f\n
echo '?>' >> $f\i

wget http://127.0.0.1/$(cat ~/bin/k)/csillagell.php?switch=1 -q -O mindenusp_csillagl
wget http://127.0.0.1/$(cat ~/bin/k)/csillagell.php?switch=2 -q -O mindenusp_plusz

exit 0