static function addTransition($pratica, $prms) { $db = self::getDb(); $userid = appUtils::getUserId(); $initVal = array("pratica" => $pratica, 'codice' => null, 'utente_in' => $userid, 'utente_fi' => null, 'data' => "now", 'stato_in' => null, 'stato_fi' => null, 'note' => null, 'tmsins' => time(), 'uidins' => $userid); foreach ($initVal as $key => $val) { $params[$key] = in_array($key, array_keys($prms)) && $prms[$key] ? $prms[$key] : $val; } $params['note'] = $params['note'] ? $db->quote($params['note']) : $params['note']; $cod = $params['codice']; if ($db->insert("pe.wf_transizioni", $params)) { switch ($cod) { case "ardp": case "aitec": case "aiamm": case "aipre": case "aiagi": case "ailav": self::addRole($pratica, substr($cod, 1), $params['utente_fi'], $params['data']); break; case "rardp": case "raitec": case "raiamm": self::delRole($pratica, substr($cod, 2)); self::addRole($pratica, substr($cod, 2), $params['utente_fi'], $params['data']); break; default: break; } } }