public function getlivrabileFactura($id_factura) { $ids = self::getIDsDepartamente(Confide::getDepartamenteUser()); $sql = self::getlivrabileFacturateNefacturate($id_factura, true); $factura = self::getFactura($id_factura); $livrabile = DB::select($sql); return View::make('livrabile_factura.list')->with('livrabile', $livrabile)->with('factura', $factura); }
public function getEditInvestitie($id) { $departamente = Confide::getDepartamenteUser(); $tva = self::getCoteTVA(); $imobil_class = new \Codecorner\Imobil\Controllers\ImobileController(); $imobile = $imobil_class->getImobil(); $cheltuieli = self::getCheltuieliSF(); $investitie = DB::select("SELECT\n investitie.id,\n investitie.denumire,\n investitie.cota_indiviza_spatii_locuit,\n investitie.cota_indiviza_spatii_alta_destinatie,\n investitie.finantare_nerambursabila_por,\n investitie.cofinantare_ap_eligibil,\n investitie.cofinantare_uat_eligibil,\n investitie.cofinantare_ap_neeligibil_ad,\n investitie.cofinantare_uat_neeligibil,\n investitie.cofinantare_ap_neeligibil_sl,\n investitie.id_imobil,\n investitie.id_departament,\n investitie.id_tva,\n l.denumire AS localitate,\n j.denumire AS judet,\n i.adresa\n FROM por12_investitie investitie\n INNER JOIN imobil i ON i.id = investitie.id_imobil AND i.logical_delete = 0\n LEFT OUTER JOIN judet j ON j.id_judet = i.id_judet AND j.logical_delete = 0\n LEFT OUTER JOIN localitate l ON l.id_localitate = i.id_localitate AND l.logical_delete = 0\n WHERE investitie.id = :id_investitie", array('id_investitie' => $id)); return View::make('investitie_por_axa12.edit')->with('investitie', $investitie[0])->with('imobile', $imobile)->with('tva', $tva)->with('finantare_nerambursabila_por', 60)->with('cofinantare_ap_neeligibil_ad', 100)->with('departamente', self::object_to_array($departamente))->with('cheltuieli', $cheltuieli); }
public function getSeriiFacturare() { $ids = self::getIDsDepartamente(Confide::getDepartamenteUser()); $sql = "SELECT \n sf.id,\n sf.serie,\n sf.numar,\n sf.id_entitate,\n ent.denumire AS entitate\n FROM serie_factura sf\n INNER JOIN entitate ent ON ent.id = sf.id_entitate AND ent.logical_delete = 0\n WHERE "; if (!Entrust::can("administrare_platforma")) { /*$sql .= " INNER JOIN departament d ON d.id_entitate = ent.id AND d.logical_delete = 0" . " AND d.id IN (" . $ids . ")";*/ $sql .= " EXISTS(SELECT id FROM departament WHERE departament.id_entitate = sf.id_entitate AND departament.logical_delete = 0\n AND departament.id IN (" . $ids . ")) AND "; } $sql .= " sf.logical_delete = 0 ORDER BY ent.id, sf.serie"; //dd($sql); $serii = DB::select($sql); return View::make('serii_facturare.list')->with('serii', $serii); }
public function getEntitati($tip_entitate) { $sql = "SELECT \n ent.id, \n ent.denumire, \n ent.cif,\n ent.adresa, \n ent.cod_postal, \n ent.telefon, \n ent.fax, \n ent.id_organizatie, \n ent.id_tip_entitate, \n judet.denumire AS judet, \n loc.denumire AS localitate\n FROM entitate ent\n LEFT OUTER JOIN judet ON ent.id_judet = judet.id_judet AND judet.logical_delete = 0 \n LEFT OUTER JOIN localitate loc ON ent.id_localitate = loc.id_localitate AND loc.logical_delete = 0"; $and = ""; if (\Entrust::hasRole("Administrator de grup")) { $and = " AND ent.id_organizatie = " . \Entrust::user()->id_org; } else { if (!\Entrust::can("administrare_platforma")) { $ids = self::getIDsDepartamente(\Confide::getDepartamenteUser()); $sql = $sql . " INNER JOIN departament d ON d.id_entitate = ent.id AND d.logical_delete = 0" . " AND d.id IN (" . $ids . ")"; } } $sql .= " WHERE ent.logical_delete = 0 "; $sql .= $and; if ($tip_entitate == 1) { $sql .= " AND ent.id_tip_entitate = 1 "; } else { $sql .= " AND ent.id_tip_entitate = 2 "; } $sql .= " GROUP BY ent.id"; $entitati = DB::select($sql); //dd($sql); return View::make('entitate::entitati_organizatie.list')->with('entitati', $entitati)->with('tip_entitate', $tip_entitate); }
public function getEditObiectiv($id) { $stadii_obiectiv = self::getStadiiObiectiv(); $ids = self::getIDsDepartamente(Confide::getDepartamenteUser()); $contracte = DB::select("SELECT \n id, denumire \n FROM contract\n WHERE logical_delete = 0\n AND id_departament IN (" . $ids . ")"); $templates = DB::select("SELECT\n id, denumire\n FROM template_contract_tipizat_master\n WHERE logical_delete = 0\n AND id_organizatie = " . self::organizatie()[0]->id_organizatie); $obiectiv = DB::select("SELECT\n obj.id,\n obj.nr_reg_proiect,\n obj.numar,\n date_format(obj.data_semnare, '%d-%m-%Y') AS data_semnare_obiectiv, \n obj.denumire AS denumire_obj,\n obj.id_tara,\n obj.id_regiune,\n obj.id_judet,\n obj.id_localitate,\n obj.adresa,\n obj.cod_postal,\n obj.id_contract,\n obj.id_template,\n obj.valoare,\n obj.tva,\n obj.id_stadiu,\n obj.id_departament,\n tara.denumire AS tara, \n regiune.denumire AS regiune, \n judet.denumire AS judet, \n localitate_obj.denumire AS localitate\n FROM obiectiv obj\n LEFT OUTER JOIN tara tara ON obj.id_tara = tara.id_tara AND tara.logical_delete = 0\n LEFT OUTER JOIN regiune regiune ON obj.id_regiune = regiune.id_regiune AND regiune.logical_delete = 0\n LEFT OUTER JOIN judet judet ON obj.id_judet = judet.id_judet AND judet.logical_delete = 0\n LEFT OUTER JOIN localitate localitate_obj ON obj.id_localitate = localitate_obj.id_localitate \n WHERE obj.logical_delete = 0\n AND obj.id = :id", array('id' => $id)); return View::make('obiective.edit')->with('contracte', self::object_to_array($contracte))->with('templates', self::object_to_array($templates))->with('stadii_obiectiv', $stadii_obiectiv)->with('obiectiv', $obiectiv[0])->with('departamente', self::object_to_array(Confide::getDepartamenteUser())); }
public function postEditContract($id) { $rules = array('departament' => 'required', 'numar' => 'required', 'data_semnare' => 'required', 'denumire' => 'required', 'parte_in_contract' => 'required', 'partener_organizatie' => 'required', 'durata_contract' => 'required', 'um_timp' => 'required', 'tip_contract' => 'required'); $errors = array('required' => 'Campul este obligatoriu.'); $validator = Validator::make(Input::all(), $rules, $errors); if ($validator->fails()) { return Redirect::back()->with('message', 'Eroare validare formular!')->withErrors($validator)->withInput(); } else { $data_semnarii_eu = DateTime::createFromFormat('d-m-Y', Input::get('data_semnare')); $data_semnarii_us = $data_semnarii_eu->format('Y-m-d'); $valoare = 0; if (!empty(Input::get('valoare_contract'))) { $valoare = Input::get('valoare_contract'); $valoare = str_replace('.', '', $valoare); $valoare = str_replace(',', '.', $valoare); } $tva = 0; if (!empty(Input::get('procent_tva'))) { $tva = Input::get('procent_tva'); $tva = str_replace('.', '', $tva); $tva = str_replace(',', '.', $tva); } $durata_contract = 0; if (!empty(Input::get('durata_contract'))) { $durata_contract = Input::get('durata_contract'); $durata_contract = str_replace('.', '', $durata_contract); $durata_contract = str_replace(',', '.', $durata_contract); } $id_entitate = 0; foreach (Confide::getDepartamenteUser() as $departament) { if ($departament->id == intval(Input::get('departament'))) { $id_entitate = $departament->id_entitate; break; } } try { DB::table('contract')->where('id', $id)->update(array('numar' => Input::get('numar'), 'id_tip_contract' => intval(Input::get('tip_contract')), 'data_semnarii' => $data_semnarii_us, 'id_tip_nivel_contractare' => intval(Input::get('parte_in_contract')), 'id_entitatea_mea' => $id_entitate, 'id_partener' => intval(Input::get('partener_organizatie')), 'denumire' => Input::get('denumire'), 'valoare' => $valoare, 'tva' => $tva, 'durata_contract' => $durata_contract, 'id_um_timp' => intval(Input::get('um_timp')), 'id_tara' => intval(Input::get('tara')), 'id_regiune' => intval(Input::get('regiune')), 'id_judet' => intval(Input::get('judet')), 'id_localitate' => intval(Input::get('localitate')), 'id_departament' => intval(Input::get('departament')))); } catch (Exception $e) { return Redirect::back()->with('message', 'Eroare salvare date: ' . $e)->withInput(); } return Redirect::back()->with('message', 'Salvare realizata cu succes!')->withInput(); } }
public function getSeriiFacturare() { $ids = self::getIDsEntitati(Confide::getDepartamenteUser()); $serii_facturare = DB::select("SELECT\n sf.id,\n sf.serie,\n sf.numar,\n ent.denumire AS entitate \n FROM serie_factura sf \n INNER JOIN entitate ent ON ent.id = sf.id_entitate AND ent.logical_delete = 0\n WHERE sf.logical_delete = 0\n AND sf.id_entitate IN (" . $ids . ")"); /*$serii_facturare = DB::select("SELECT sf.id_serie_factura, sf.serie, sf.numar FROM serie_factura sf INNER JOIN entitate ON entitate.id = sf.id_entitate AND entitate.logical_delete = 0 WHERE sf.logical_delete = 0 AND entitate.id_organizatie = :id_organizatie", array('id_organizatie' => isset(self::organizatie()[0])?self::organizatie()[0]->id_organizatie:-1));*/ return $serii_facturare; }