function irtibatkaydet($userid, $posted)
{
$_db =& JFactory::getOracleDBO();
$panelName = "irtibat_panel";
$panelCount = $posted["panelCount_" . $panelName];
$result = true;
for ($i = 1; $result && $i < $panelCount + 2; $i++) {
$irtibatHiddenId = $panelName . $i;
if ($i == 1) {
$irtibatHiddenId = $panelName;
}
if (!isset($posted[$irtibatHiddenId])) {
// INSERT
if (isset($posted["input" . $irtibatHiddenId . "-2"])) {
$inputName = "input" . $irtibatHiddenId;
$rowCount = 4;
$panelValues = FormFactory::getPanelValues($posted, $inputName, $rowCount);
$irtibat_id = $_db->getNextVal(IRTIBAT_SEQ);
$irtibat_kisi_adi = $panelValues[0];
$irtibat_eposta = $panelValues[1];
$irtibat_telefon = $panelValues[2];
$irtibat_faks = $panelValues[3];
//Prepare sql statement
$sql = "INSERT INTO m_kurulus_irtibat\n\t\t\t\t\t\t\t\t\t(irtibat_id, irtibat_kisi_adi, irtibat_eposta, irtibat_telefon, irtibat_faks,user_id)\n\t\t\t\t\t\t\t\t\tvalues( ?, ?, ?, ?, ?, ?)";
$params = array($irtibat_id, $irtibat_kisi_adi, $irtibat_eposta, $irtibat_telefon, $irtibat_faks, $userid);
$result = $_db->prep_exec_insert($sql, $params);
}
} else {
$irtibatId = $posted[$irtibatHiddenId];
if (!isset($posted["input" . $irtibatHiddenId . "-2"])) {
// DELETE
$result = FormFactory::irtibatVerisiSil($evrak_pk, $irtibatId);
} else {
// UPDATE
$inputName = "input" . $irtibatHiddenId;
$rowCount = 4;
$panelValues = FormFactory::getPanelValues($posted, $inputName, $rowCount);
$irtibat_kisi_adi = $panelValues[0];
$irtibat_eposta = $panelValues[1];
$irtibat_telefon = $panelValues[2];
$irtibat_faks = $panelValues[3];
//Prepare sql statement
$sql = "UPDATE m_kurulus_irtibat \n\t\t\t\t\t\t\tSET irtibat_kisi_adi = ?, \n\t\t\t\t\t\t\t\tirtibat_eposta = ?, \n\t\t\t\t\t\t\t\tirtibat_telefon = ?,\n\t\t\t\t\t\t\t\tirtibat_faks = ? \n\t\t\t\t\t\t WHERE irtibat_id = ?";
$params = array($irtibat_kisi_adi, $irtibat_eposta, $irtibat_telefon, $irtibat_faks, $irtibatId);
$result = $_db->prep_exec_insert($sql, $params);
}
}
}
return $result;
}
public function irtibatVerileriKaydet($evrak_pk, $panelName, $posted)
{
$panelCount = $posted["panelCount_" . $panelName];
$result = true;
for ($i = 1; $result && $i < $panelCount + 2; $i++) {
$irtibatHiddenId = $panelName . $i;
if ($i == 1) {
$irtibatHiddenId = $panelName;
}
if (!isset($posted[$irtibatHiddenId])) {
// INSERT
if (isset($posted["input" . $irtibatHiddenId . "-2"])) {
$inputName = "input" . $irtibatHiddenId;
$rowCount = 4;
$panelValues = FormFactory::getPanelValues($posted, $inputName, $rowCount);
$result = FormFactory::irtibatVerisiEkle($evrak_pk, $panelValues);
}
} else {
$irtibatId = $posted[$irtibatHiddenId];
if (!isset($posted["input" . $irtibatHiddenId . "-2"])) {
// DELETE
$result = FormFactory::irtibatVerisiSil($evrak_pk, $irtibatId);
} else {
// UPDATE
$inputName = "input" . $irtibatHiddenId;
$rowCount = 4;
$panelValues = FormFactory::getPanelValues($posted, $inputName, $rowCount);
$result = FormFactory::irtibatVerisiGuncelle($evrak_pk, $irtibatId, $panelValues);
}
}
}
return $result;
}
