- satırda $row['column1'] ve $row['column2'] şeklinde iki adet sütun adı belirtilmiş, ancak sorguda bu sütun adları kullanılmamış. Bu nedenle, kodun düzeltilmiş hali aşağıdaki gibi olacaktır diyor chatgpt amca düzeltilmiş kod ise :
<?php
$dbname = "ip";
$dbuser = "user";
$dbpass = "pass";
$dbhost = "db";
$conn = pg_connect("dbname=$dbname user=$dbuser password=$dbpass host=$dbhost");
// Sorgu
$query = "WITH PERYOT AS (
SELECT DET.BPERIOD_D_ID,
MAS.BPERIOD_M_ID,
MAS.BPERIOD_M_CODE,
DET.BPERIOD_D_CODE
FROM BGTT_BPERIOD_M MAS
INNER JOIN BGTT_BPERIOD_D DET ON MAS.BPERIOD_M_ID = DET.BPERIOD_M_ID
WHERE MAS.BPERIOD_M_CODE = TO_CHAR(CURRENT_DATE,'YYYY')
AND TO_CHAR(det.end_date,'MM') = TO_CHAR(CURRENT_DATE,'MM')
)
,BAGIS AS (
SELECT SUM(BGS.AMT_WITH_DISC) BAGIS_CIRO
FROM
(
SELECT
SUM(CASE WHEN PIM.PURCHASE_SALES = 2
THEN PID.AMT_WITH_DISC
ELSE -PID.AMT_WITH_DISC END) AMT_WITH_DISC
FROM PSMT_INVOICE_D PID
LEFT JOIN PSMT_INVOICE_M PIM ON PID.INVOICE_M_ID = PIM.INVOICE_M_ID
LEFT JOIN GNLD_COMPANY CO1 ON PID.CO_ID = CO1.CO_ID
LEFT JOIN INVD_ITEM ITE ON PID.ITEM_ID = ITE.ITEM_ID
LEFT JOIN GNLD_CATEGORIES CAT1 ON ITE.CATEGORIES1_ID = CAT1.CATEGORIES_ID
LEFT JOIN INVD_UNIT UN ON PID.UNIT_ID = UN.UNIT_ID
LEFT JOIN INVD_UNIT UN1 ON ITE.UNIT_ID = UN1.UNIT_ID
WHERE (CO1.CO_CODE = 'efeel')
AND PIM.PURCHASE_SALES IN (2,3)
AND PIM.IS_CANCEL_INVOICE = 0
AND PIM.E_INVOICE_STATUS NOT IN (1,7)
AND PID.LINE_TYPE = 1
AND PIM.SOURCE_APP <> 165
AND PIM.CAT_CODE1_ID IN (SELECT CAT_CODE_ID FROM GNLD_CATEGORY WHERE CAT_CODE LIKE 'BAGIS%')
AND TO_CHAR(PIM.DOC_DATE,'YYYY-MM')= TO_CHAR(CURRENT_DATE,'YYYY-MM')
UNION ALL
SELECT
COALESCE(
SUM(CASE WHEN PIM.PURCHASE_SALES = 2
THEN PID.AMT_WITH_DISC
ELSE -PID.AMT_WITH_DISC END),0) AMT_WITH_DISC
FROM PSMT_INVOICE_D PID
LEFT JOIN PSMT_INVOICE_M PIM ON PID.INVOICE_M_ID = PIM.INVOICE_M_ID
LEFT JOIN GNLD_COMPANY CO1 ON PID.CO_ID = CO1.CO_ID
LEFT JOIN INVD_EXPENSE EXP ON PID.DCARD_ID = EXP.EXPENSE_ID
LEFT JOIN FIND_ACC ACC ON PID.DCARD_ID = ACC.ACC_ID
LEFT JOIN GNLD_CATEGORIES CAT1 ON EXP.CATEGORIES1_ID = CAT1.CATEGORIES_ID
LEFT JOIN GNLD_CATEGORIES CATE ON EXP.CATEGORIES1_ID = CATE.CATEGORIES_ID
LEFT JOIN INVD_UNIT UN ON PID.UNIT_ID = UN.UNIT_ID
LEFT JOIN INVD_UNIT UN1 ON EXP.UNIT_ID = UN1.UNIT_ID
WHERE (CO1.CO_CODE = 'efeel')
AND PIM.PURCHASE_SALES IN (2,3)
AND PIM.IS_CANCEL_INVOICE = 0
AND PIM.E_INVOICE_STATUS NOT IN (1,7)
AND PID.LINE_TYPE <> 1
AND PIM.SOURCE_APP <> 165
AND PIM.CAT_CODE1_ID IN (SELECT CAT_CODE_ID FROM GNLD_CATEGORY WHERE CAT_CODE LIKE 'BAGIS%')
AND TO_CHAR(PIM.DOC_DATE,'YYYY-MM') = TO_CHAR(CURRENT_DATE,'YYYY-MM')
) BGS
)
, BUTCE AS (
SELECT
SUM(BSD2.BGT_AMT - BSD2.BGT_AMT_DISC) AS \"BTC_CIRO_TL\" ,
SUM(BSD2.AMT - BSD2.AMT_DISC - BSD2.AMT_RETURN)-
(SELECT BAGIS_CIRO FROM BAGIS) AS \"GERCEKLESEC_CIRO_TL\"
FROM BGTT_SALES_D BSD
INNER JOIN BGTT_SALES_M BSM ON BSD.SALES_M_ID = BSM.SALES_M_ID
INNER JOIN BGTD_CO_BUDGET BGC ON BSM.BUDGET_ID = BGC.BUDGET_ID
AND BSM.CO_ID = BGC.CO_ID
AND BSM.CO_BUDGET_ID = BGC.CO_BUDGET_ID
INNER JOIN BGTD_BUDGETS BGB ON BGC.BUDGET_ID = BGB.BUDGET_ID
INNER JOIN GNLD_COMPANY CO1 ON BSM.CO_ID = CO1.CO_ID
INNER JOIN GNLD_BRANCH BR1 ON BSM.BRANCH_ID = BR1.BRANCH_ID
LEFT JOIN BGTT_SALES_D2 BSD2 ON BSD.SALES_D_ID = BSD2.SALES_D_ID
LEFT JOIN BGTT_BPERIOD_D PD1 ON BSD2.BPERIOD_D_ID = PD1.BPERIOD_D_ID
LEFT JOIN BGTT_ITEM_GROUP_REL_M RELM ON BSM.CO_BUDGET_ID = RELM.CO_BUDGET_ID
LEFT JOIN BGTT_ITEM_GROUP_REL_D RELD ON RELM.ITEM_GROUP_REL_M_ID = RELD.ITEM_GROUP_REL_M_ID
AND BSD.DCARD_ID = RELD.ITEM_GROUP_REL_D_ID
LEFT JOIN GNLD_CATEGORIES_RECORD CTG ON CTG.CATEGORIES_SEQ_M_ID = BGC.SALES_ITEM_CAT_SEQ_ID
AND BGC.SALES_ITEM_ENTRY_TYPE = 3
AND RELD.CATEGORIES_RECORD_ID = CTG.CATEGORIES_RECORD_ID
LEFT JOIN INVD_EXPENSE EXP ON BSD.DCARD_ID = EXP.EXPENSE_ID
LEFT JOIN BGTT_ITEM_GROUP_REL_D GRD ON BSD.DCARD_ID = GRD.ITEM_GROUP_REL_D_ID
LEFT JOIN BGTD_BUDGET_ITEM CAT ON GRD.BUDGET_ITEM_ID = CAT.BUDGET_ITEM_ID
LEFT JOIN GNLD_CATEGORIES CATE ON EXP.CATEGORIES1_ID = CATE.CATEGORIES_ID
LEFT JOIN GNLD_CURRENCY CUR ON BSD.CUR_TRA_ID = CUR.CUR_ID
LEFT JOIN GNLD_CATEGORY CAT2 ON BSM.CAT_CODE2_ID = CAT2.CAT_CODE_ID AND CAT2.IS_CAT_CODE2 = 1
LEFT JOIN FIND_ENTITY FEN ON BSD.ENTITY_ID = FEN.ENTITY_ID
LEFT JOIN INVD_UNIT UNI ON BSD.UNIT_ID = UNI.UNIT_ID
WHERE
(BGB.BUDGET_CODE = '2023') AND
(CO1.CO_CODE = 'efeel') AND
(BSD2.BPERIOD_D_ID = (SELECT BPERIOD_D_ID
FROM PERYOT )) AND
(BSM.CANAL_TYPE = 1) AND
(BSM.CAT_CODE1_ID <> 374)
)
SELECT \"BTC_CIRO_TL\" BUTCE_TUTAR,
\"GERCEKLESEC_CIRO_TL\" GERCEKLESEN_TUTAR,
\"BTC_CIRO_TL\" - \"GERCEKLESEC_CIRO_TL\" SAPMA
FROM BUTCE";
$result = pg_query($conn, $query);
while ($row = pg_fetch_array($result)) {
echo $row['BUTCE_TUTAR'] . " " . $row['GERCEKLESEN_TUTAR'] . " " . $row['SAPMA'] . "<br>";
}
pg_close($conn);
?>