Mσнαммαɗ SαtαГолосовое сообщение
$queryInsert = "insert into SelOrderItems1
(id,
OrderId
,RowIndex,stuffid,Value,ConfirmValue,GetValue,UnitId,ConvertRate,PriceId,UnitPrice,
CurrencyId,CurrencyRate
,StorageId,DeliveryDate,IsFinish,des,CreatorUName,GetValueInProduct,ItemType,Price,
NetPrice,VATBase,DbAccElaborative1ID,DbAccCodingID,cracccodingid
)
values ";
for ($x = 1; $x <= count(@=gridVar001); $x++)
{
$IDitem=executeQuery("select case when Max(ID) IS NULL then 1 else Max(Id)+1 end as MAXID from [Faradaneh].dbo.SelOrderItems1",$db);
$IDitem1=$IDitem[1][MAXID]+$x-1;
$stuffid= @=gridVar001[$x]['stuffid'];
$unitid= @=gridVar001[$x]['unitid'];
$Value= @=gridVar001[$x]['Value'];
$priceID= @=gridVar001[$x]['priceID'];
$Ddate= @=gridVar001[$x]['Ddate'];
$Des= @=gridVar001[$x]['Des'];
$text0000000002= @=gridVar001[$x]['text0000000002'];
$text0000000001= @=gridVar001[$x][text0000000001];
$ConvertRate= @=gridVar001[$x][ConvertRate];
$StorageId=executeQuery("select StorageId from [Faradaneh].dbo.InvStuff_InvStorage where DefaultStorageInSelOrder=1 and StuffId=$stuffid",$db);
$StorageId1=$StorageId[1][StorageId];
////
$Stuffacc=executeQuery("exec SelItemsAccountInfo_SELECT @StorageId=$StorageId1,@IsStuff=1,@ItemID=$stuffid",$db);
$Stuffacc1=$Stuffacc[1][AccCodingId];
////
$query3 ="(
$IDitem1,
$MaxID1
,$x,
$stuffid,
$Value,
$Value,
0.000000,
$unitid,
$ConvertRate,
$priceID,
$text0000000002,
1,
1.000000000,
$StorageId1,
isnull([Faradaneh].[dbo].ShamsiToMiladi(BPMS.dbo.PersaintoEnglishNumber(N'$Ddate')),''),
0,
'$Des',
'$username',
0.000000,
1,
$text0000000001,
$text0000000001,
1,
isnull($customer,NULL),
isnull($acccoding1,NULL),
isnull($Stuffacc1,Null)
)";
if ($x!=count(@=gridVar001)){
$query3 = $query3.",";
}
$queryInsert=$queryInsert.$query3;
//$result1=executeQuery($query3, $db);
}
$result1=sqlsrv_query( $conn, $queryInsert);