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;
}
private function kisiBilgiVerisiGuncelle($evrak_pk, $personel_id, $panelName, $posted)
{
$egitimColCount = 3;
$sertifikaColCount = 4;
$deneyimColCount = 5;
$dilColCount = 5;
$resultST = FormFactory::kisiBilgiTablolariSil($personel_id);
$personelValues = FormFactory::getPanelValues($posted, "input" . $panelName, 9, 3);
//M_BASVURU_PERSONEL
$deneyimAciklama = $posted["input" . $panelName . "-17"];
$egitimValues = FormFactory::getTableValues($posted, array("div" . $panelName . "-13-12", $egitimColCount));
//M_PERSONEL_EGITIM
$sertifikaValues = FormFactory::getTableValues($posted, array("div" . $panelName . "-15-14", $sertifikaColCount));
//M_PERSONEL_SERTIFIKA
$deneyimValues = FormFactory::getTableValues($posted, array("div" . $panelName . "-19-18", $deneyimColCount));
//M_PERSONEL_DENEYIM
$dilValues = FormFactory::getTableValues($posted, array("div" . $panelName . "-21-20", $dilColCount));
//M_DILBILGISI
$resultP = FormFactory::personelVerisiGuncelle($personel_id, $personelValues, $deneyimAciklama);
$resultE = FormFactory::egitimVerileriEkle($egitimValues, $personel_id, $egitimColCount);
$resultS = FormFactory::sertifikaVerileriEkle($sertifikaValues, $personel_id, $sertifikaColCount);
$resultD = FormFactory::deneyimVerileriEkle($deneyimValues, $personel_id, $deneyimColCount);
$resultDL = FormFactory::dilVerileriEkle($dilValues, $personel_id, $dilColCount);
////////////////
// Kısı bilgi ekindeki yeterlilik acıklaması icin:
$resultYA = true;
$yeterlilik_aciklama = "";
if ($posted["input" . $panelName . "-23"]) {
$yeterlilik_aciklama = $posted["input" . $panelName . "-23"];
}
if ($yeterlilik_aciklama != "") {
$resultYA = FormFactory::yeterlilikAciklamaKaydet($personel_id, $yeterlilik_aciklama);
}
///////////////
//$returnValues = array ($resultST, $resultP, $resultE, $resultS,$resultD, $resultDL);
$returnValues = array($resultST, $resultP, $resultE, $resultS, $resultD, $resultDL, $resultYA);
return !FormFactory::isThereError($returnValues);
}
