break; case 'getMEDRows': print json_encode($dbaccess->getMEDRows()); break; case 'getMPDRows': print json_encode($dbaccess->getMPDRows()); break; 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) {
} // 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.'])); } // validate templates if (!call_user_func(function ($templateID) { $templates = \ZP\ZP::getTemplates(); if (!count($templates)) { exit(json_encode(['success' => false, 'message' => 'Internal error occurred, could not validate templates'])); } foreach ($templates as $v) { if ($v->templateID = $templateID) { return true;
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]; } }