Php kode til Stored Procedure
HejsaVil der være fornuftigt i at lave nedenståenden kode om til en SP? I så fald vil det være nødvendigt med et kraftigt spark i den rigtige retning for hvordan det gøres!
$Prefix[0] = "KL0"; //Denmark
$Prefix[1] = "KLS"; //Sweden
$k = 0;
$l = 0;
$t = 0;
$s =0;
$size = count($Prefix);
While ($size > $k)
{
echo "<br> Starting generating all design numbers in EDEMP.CLICHE1 for ".$Prefix[$k]." !";
$letters = $Prefix[$k];
$i = 0;
while ($i < 100000 )
{
if (strlen($Prefix[$l]) == 2)
{
if (strlen($i) == 1 ) { $array_IPROD[$i] = $letters."00000".$i;}
if (strlen($i) == 2 ) { $array_IPROD[$i] = $letters."0000".$i;}
if (strlen($i) == 3 ) { $array_IPROD[$i] = $letters."000".$i;}
if (strlen($i) == 4 ) { $array_IPROD[$i] = $letters."00".$i;}
if (strlen($i) == 5 ) { $array_IPROD[$i] = $letters."0".$i;}
if (strlen($i) == 6 ) { $array_IPROD[$i] = $letters.$i;}
//echo $array_IPROD[$i] . "<br>";
$sql = "INSERT INTO " . $database.".".$file."(ID,CLICHENO,Status) VALUES('$array_IPROD[$i]','$array_IPROD[$i]',1)";
//echo "<br>".$sql."<br>";
$rs = odbc_exec($conn,$sql);
}
if (strlen($Prefix[$l]) == 3)
{
if (strlen($i) == 1 ) { $array_IPROD[$i] = $letters."0000".$i;}
if (strlen($i) == 2 ) { $array_IPROD[$i] = $letters."000".$i;}
if (strlen($i) == 3 ) { $array_IPROD[$i] = $letters."00".$i;}
if (strlen($i) == 4 ) { $array_IPROD[$i] = $letters."0".$i;}
if (strlen($i) == 5 ) { $array_IPROD[$i] = $letters.$i;}
//echo $array_IPROD[$i] . "<br>";
$sql = "INSERT INTO " . $database.".".$file."(ID,CLICHENO,Status) VALUES('$array_IPROD[$i]','$array_IPROD[$i]',1)";
//echo "<br>".$sql."<br>";
$rs = odbc_exec($conn,$sql);
}
//echo "<br>".$i;
$i++;
$s++;
if ($s == 1000) {$s=0; echo "1000 records inserted!<br>";}
}
echo "<br> Finished generating all design numbers in EDEMP.CLICHE1 for ".$Prefix[$k]." !<br>";
$l++;
$k++;
}