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); }
/** * 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(); }