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); }