public function add()
{
$request = knl_lib_Registry::getRequestObj()->getInstance();
$arr_grupos = $request->getPost("grupos");
$doc_pend_tp = $request->getPost("pendtipo");
$doc_sub_tp = $request->getPost("docsubtipo");
$addrem = $request->getPost("addrem");
$mRegraCred = new knl_model_doc_sub_tipo_regra_cred(0, $addrem, $doc_pend_tp, 0, 0, $doc_sub_tp, 0, 0, 0);
$dRegraCred = knl_dao_doc_sub_tipo_regra_cred::getInstance();
if (!empty($arr_grupos)) {
foreach ($arr_grupos as $v) {
$mGrupo = knl_dao_knl_grupo::getInstance()->selectById($v);
$mPermBin = knl_dao_knl_perm_bin::getInstance()->selectById($mGrupo->get_id_knl_perm_bin());
$mRegraCred->set_id(0);
$mRegraCred->set_id_knl_grupo($v);
$mRegraCred->set_perm_grupo($mPermBin->get_permbin());
$dRegraCred->upsert($mRegraCred);
}
}
echo "add em domain RegraCred";
}
public function upsert(knl_model_doc_sub_tipo_regra_cred $objmodel)
{
if ($objmodel->get_id() == 0) {
$query = "INSERT INTO doc_sub_tipo_regra_cred (addrem,id_doc_pendencia_tipo,id_knl_usuario,id_knl_grupo,id_doc_sub_tipo,perm_usuario,perm_grupo,perm_outros)\n VALUES ('" . $objmodel->get_addrem() . "','" . $objmodel->get_id_doc_pendencia_tipo() . "','" . $objmodel->get_id_knl_usuario() . "','" . $objmodel->get_id_knl_grupo() . "','" . $objmodel->get_id_doc_sub_tipo() . "','" . $objmodel->get_perm_usuario() . "','" . $objmodel->get_perm_grupo() . "','" . $objmodel->get_perm_outros() . "')";
$stmt = $this->conn->prepare($query);
$stmt = $this->conn->execute($stmt);
$objmodel->set_id($this->conn->Insert_ID());
} else {
$query = "UPDATE doc_sub_tipo_regra_cred SET \n addrem='{$objmodel->get_addrem()}', id_doc_pendencia_tipo='{$objmodel->get_id_doc_pendencia_tipo()}',id_knl_usuario='{$objmodel->get_id_knl_usuario()}',id_knl_grupo='{$objmodel->get_id_knl_grupo()}',id_doc_sub_tipo='{$objmodel->get_id_doc_sub_tipo()}',perm_usuario='{$objmodel->get_perm_usuario()}',perm_grupo='{$objmodel->get_perm_grupo()}',perm_outros='{$objmodel->get_perm_outros()}'\n WHERE id = ?";
$stmt = $this->conn->prepare($query);
$stmt = $this->conn->execute($stmt, $objmodel->get_id());
}
return $objmodel;
}
