making_list_mn_new_v2_bsh

<?php
$FileIn = fopen("mn.csv", "r+");
//$FileOut = fopen("1381_2.csv", "a+");
$FileOut = fopen("bsh.sql", "a+");
$start_date = "16.09.2014";
while (($Line = fgetcsv($FileIn,1024,";"))!== False)
{
/*
fwrite($FileOut, "$Line[0];60$Line[1];$Line[2];$Line[3];$Line[4];$Line[5];$Line[6];$Line[7];$Line[8];$Line[9];$Line[10];$Line[11];$Line[12];$Line[13];$Line[14];$Line[15];$Line[16];$Line[17];$Line[18];$Line[19];$Line[20];$Line[21]\r\n");
*/
$Line[2] = str_replace(",",".",$Line[2]);
//1381-для наука и связь
//104-для ростелекома
//БСХ - 597

if($Line[0][0]!='7'){
$ins = "INSERT INTO OUTSIDER_TARIFS_TMP_2 (CODE, CAPTION, KIND, FROM_DATE, TO_DATE, ED_TO_DATE, FROM_TIME, TO_TIME, BEGTIME, ENDTIME, TARIF, MONEYFORCALL, FIRSTM, ROUNDM, FM_FLAG, VALUTA, CODE_TYPE, INFO, FIRM_NUM, GRCODE) VALUES (810$Line[1],'$Line[0]', 0, '$start_date','31.12.2999', NULL,'00:00','24:00',0,1,$Line[2],0,1,1,1,1,'','',1,597)";
fwrite($FileOut, "$ins;\r\n");
$ins = "INSERT INTO OUTSIDER_TARIFS_TMP_2 (CODE, CAPTION, KIND, FROM_DATE, TO_DATE, ED_TO_DATE, FROM_TIME, TO_TIME, BEGTIME, ENDTIME, TARIF, MONEYFORCALL, FIRSTM, ROUNDM, FM_FLAG, VALUTA, CODE_TYPE, INFO, FIRM_NUM, GRCODE) VALUES (860810$Line[1],'$Line[0]', 0, '$start_date','31.12.2999', NULL,'00:00','24:00',0,1,$Line[2],0,1,1,1,1,'','',1,597)";
fwrite($FileOut, "$ins;\r\n");
}
else
{
$Line[0][0]='8';
$ins = "INSERT INTO OUTSIDER_TARIFS_TMP_2 (CODE, CAPTION, KIND, FROM_DATE, TO_DATE, ED_TO_DATE, FROM_TIME, TO_TIME, BEGTIME, ENDTIME, TARIF, MONEYFORCALL, FIRSTM, ROUNDM, FM_FLAG, VALUTA, CODE_TYPE, INFO, FIRM_NUM, GRCODE) VALUES ($Line[1],'$Line[0]', 0, '$start_date','31.12.2999', NULL,'00:00','24:00',0,1,$Line[2],0,1,1,1,1,'','',1,597)";
fwrite($FileOut, "$ins;\r\n");
$ins = "INSERT INTO OUTSIDER_TARIFS_TMP_2 (CODE, CAPTION, KIND, FROM_DATE, TO_DATE, ED_TO_DATE, FROM_TIME, TO_TIME, BEGTIME, ENDTIME, TARIF, MONEYFORCALL, FIRSTM, ROUNDM, FM_FLAG, VALUTA, CODE_TYPE, INFO, FIRM_NUM, GRCODE) VALUES (860$Line[1],'$Line[0]', 0, '$start_date','31.12.2999', NULL,'00:00','24:00',0,1,$Line[2],0,1,1,1,1,'','',1,597)";
fwrite($FileOut, "$ins;\r\n");
}
}
fclose ($FileIn);
fclose ($FileOut);
?>