public static function obj2DB($obj)
{
$id = $obj->id;
$em = DoctrineBootstrap::getEntityManager();
$infection = $em->getRepository('Hospitalplugin\\Entities\\Infections')->find($id);
$infection->setWeryfikacja($obj->value);
$em->persist($infection);
$em->flush();
echo $id;
}
public static function getWardsArray()
{
if (WardCRUD::$wardsArray == null) {
$entityManager = (object) DoctrineBootstrap::getEntityManager();
$query = $entityManager->createQuery('select w FROM Hospitalplugin\\Entities\\Ward w ORDER BY w.name');
$wards = $query->getResult();
WardCRUD::$wardsArray = $wards;
}
return WardCRUD::$wardsArray;
}
/**
*
* @param unknown $wardId
* @param unknown $startDate
* @param unknown $endDate
*/
public static function getRaportBetweenDatesNative($wardId, $startDate, $endDate)
{
$em = DoctrineBootstrap::getEntityManager();
PatientRaportOptimized::updateNativeRaport();
$conn = $em->getConnection();
$sql3 = "SELECT kategoria, date(data) as data, suma FROM kategoria_view WHERE data between :data1 AND :data2 and oddzialId = :oddzialId";
$stmt = $conn->prepare($sql3);
$stmt->execute(array('data1' => $startDate, 'data2' => $endDate, 'oddzialId' => $wardId));
$result = $stmt->fetchAll();
$table = array();
foreach ($result as $row) {
$table[$row['data']][$row['kategoria']] = $row['suma'];
}
return $table;
}
/**
*
* @param unknown $wardId
* @param unknown $type
* @param unknown $startDate
* @param unknown $endDate
* @return array
*/
public static function getRaportBetweenDates($wardId, $type, $startDate, $endDate)
{
$em = DoctrineBootstrap::getEntityManager();
$em->getConfiguration()->addCustomDatetimeFunction('DATE', 'Hospitalplugin\\DQLFunctions\\DateFunction');
$dql = PatientRaport::getQuery($type);
$allResults = array();
foreach ($dql as $query) {
$result = $em->createQuery($query)->setParameter(1, $startDate)->setParameter(2, $endDate)->setParameter(3, $wardId)->getResult();
$allResults = array_merge($result, $allResults);
}
$table = array();
foreach ($allResults as $row) {
$table[$row['data']][$row['kategoria']] = $row['suma'];
}
return $table;
}
public static function load($yaml, $class, $dir)
{
try {
$em = DoctrineBootstrap::getEntityManager();
$userId = $userId = wp_get_current_user()->ID;
$ward = WardCRUD::getWardForUser($userId);
$user = $em->find("\\Hospitalplugin\\Entities\\User", $userId);
if (!empty($_POST)) {
$args = $_POST;
$i = new $class($args);
$i->setWard($ward);
$i->setUser($user);
$em->persist($i);
$em->flush();
} else {
$object = \Hospitalplugin\utils\YAML2Object::getObject($yaml);
echo PLTwig::load($dir)->render('form.twig', array('infections' => $object));
}
} catch (Exception $e) {
echo "ERR: " . $e;
}
}
public static function getCli()
{
$em = DoctrineBootstrap::getEntityManager();
$em->getConnection()->getDatabasePlatform()->registerDoctrineTypeMapping('enum', 'string');
return ConsoleRunner::createHelperSet($em);
}
<?php use Hospitalplugin\DB\DoctrineBootstrap; return DoctrineBootstrap::getCli();
/**
* deletePatient
*
* @param $id $id
* int
*/
public static function deletePatient($id, $userId = 0)
{
$entityManager = (object) DoctrineBootstrap::getEntityManager();
$type = 'Hospitalplugin\\Entities\\Patient';
$patient = $entityManager->getRepository($type)->findOneBy(array('id' => $id));
$entityManager->remove($patient);
$log = strval($patient);
$audit = new PatientDeleted();
$audit->deletedAt = new \DateTime();
$audit->deletedByUserId = $userId;
$audit->log = $log;
$entityManager->persist($audit);
$entityManager->flush();
}
