case 'addMEType': $name = $_REQUEST['name']; print json_encode($dbaccess->addMEType($name)); break; case 'getReport': //exit(json_encode($_REQUEST)); // validate extractive company $TPIN = call_user_func(function ($TPIN) { if (\ZP\ZP::getExtractiveCompany($TPIN)) { return $TPIN; } exit(json_encode(['success' => false, 'message' => 'Please select a valid extractive company.'])); }, $_REQUEST['TPIN']); // validate entityID $entityID = call_user_func(function ($entityID) { if (\ZP\ZP::getEntity($entityID)) { return $entityID; } return null; }, $_REQUEST['entity']); // validate templateID $templateID = call_user_func(function ($templateID) { $templates = \ZP\ZP::getTemplates(); foreach ($templates as $v) { if ($templateID == $v->templateID) { return $templateID; } } exit(json_encode(['success' => false, 'message' => 'Please select a valid templates.'])); }, $_REQUEST['templateID']); // validate period
$reports = \ZP\ZP::getReports(); foreach ($reports as $v) { if ($reportID == $v->reportID) { return true; } } return false; }, $reportID)) { exit(json_encode(['success' => false, 'message' => 'You have submitted an invalid report. Please refresh page and try again.'])); } // validate entity if ($_SESSION['entity']->isGovernmentEntity()) { $entityID = $_SESSION['entity']->getID(); } else { if (intval($_REQUEST['entity']) > 0) { if (!\ZP\ZP::getEntity($_REQUEST['entity'])) { exit(json_encode(['success' => false, 'message' => 'Please input a valid Government Entity.'])); } $entityID = intval($_REQUEST['entity']); } else { $entityID = null; } } // validate extractive company if (!\ZP\ZP::getExtractiveCompany($_REQUEST['mine'])) { exit(json_encode(['success' => false, 'message' => 'Please input a valid Extractive Company.'])); } // validate period if (intval($_REQUEST['period']) < 2000 || intval($_REQUEST['period']) > intval(date('Y'))) { exit(json_encode(['success' => false, 'message' => 'Please input a valid period.'])); }
public function deleteEntity($ID) { try { if (property_exists($ID, 'entityID')) { $sql = "DELETE ge " . "FROM governmententity ge " . "WHERE ge.entityID = :ID AND (ge.entityID != 1 OR ge.entityName NOT LIKE '%ZEITI Secretariat%');"; $key = $ID->entityID; $entity = ZP::getEntity($ID->entityID); //exit($sql.$key); } else { $sql = "DELETE ec " . "FROM extractivecompany ec " . "WHERE ec.TPIN = :ID"; $entity = ZP::getExtractiveCompany($ID->tpin); $key = $ID->tpin; } $query = $this->getConnection()->prepare($sql); $query->bindParam(":ID", $key, PDO::PARAM_INT); if ($query->execute()) { //exit(json_encode(['success'=>false, 'key'=>$key])); ZP::log('Delete Entity', json_encode($entity), $_SESSION['user']->getID(), $_SESSION['module_number']); return $this->getEntities(); } return ['success' => false, 'exception' => 'Could not delete entity.']; } catch (\PDOException $e) { return ['success' => false, 'exception' => $e]; } }