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