public function save($id, $data, $langId)
{
$addrId = 0;
if (isset($data[$this->_formDataName])) {
$oAdress = new AddressObject();
$addr = $data[$this->_formDataName];
// $addrShip = $data['addressShipping'];
}
if (!empty($addr)) {
$addrId = $oAdress->save($data[$this->_addressField], $addr, $langId);
// if ($addrShip['duplicate'] == 1)
// {
// $addrBill['A_Duplicate'] = $billId;
// $shipId = $oAdress->save($addrShip['MP_ShippingAddrId'], $addrBill, $langId);
// }
// else
// {
// $addrShip['A_Duplicate'] = 0;
// $shipId = $oAdress->save($addrShip['MP_ShippingAddrId'], $addrShip, $langId);
// }
if (empty($data[$this->_addressField])) {
$data[$this->_addressField] = $addrId;
}
// $data['MP_ShippingAddrId'] = $shipId;
}
parent::save($id, $data, $langId);
}
public function save($source, &$errors = array())
{
if (!parent::save()) {
return false;
}
return $this->update_owner_balance($errors);
}
public function save($id, $data, $langId)
{
if (!isset($data['NP_Categories'])) {
$data['NP_Categories'] = 0;
}
parent::save($id, $data, $langId);
}
public function save($id, $data, $langId)
{
$billId = 0;
$shipId = 0;
if (isset($data['addressFact'])) {
$oAdress = new AddressObject();
$addrBill = $data['addressFact'];
$addrShip = $data['addressShipping'];
}
if (!empty($addrBill)) {
$billId = $oAdress->save($addrBill['MP_BillingAddrId'], $addrBill, $langId);
if ($addrShip['duplicate'] == 1) {
$addrBill['A_Duplicate'] = $billId;
$shipId = $oAdress->save($addrShip['MP_ShippingAddrId'], $addrBill, $langId);
} else {
$addrShip['A_Duplicate'] = 0;
$shipId = $oAdress->save($addrShip['MP_ShippingAddrId'], $addrShip, $langId);
}
$data['MP_BillingAddrId'] = $billId;
$data['MP_ShippingAddrId'] = $shipId;
}
$oYears = new YearsParticipateObject();
$oYears->manageData($id, $data['MP_YearsParticipate']);
$data['MP_BirthDate'] = $data['MP_BirthDateDt'];
$years = $this->calculateAge($data['MP_BirthDate']);
$data['MP_Age'] = $years;
$data['MP_PassportExpiracyDate'] = $data['MP_PassportExpiracyDateDt'];
if ($data['MP_BirthDate'] != $data['MP_PassportBirthDate']) {
$data['MP_PassportBirthDate'] = $data['MP_BirthDate'];
}
parent::save($id, $data, $langId);
}
public function save($id, $data, $langId)
{
$oAddress = new AddressObject();
$profile = parent::findData(array('R_GenericProfileId' => $id));
$currentAddr = $profile[0]['R_RetailerAddressId'];
$retailerId = $profile[0]['R_RetailerProfileId'];
$retailer = $data['retailerForm'];
//If customer doesn't want to add data on website, set to false the field name
switch ($retailer['isDistributeur']) {
case 1:
$retailerData = array('R_Status' => $retailer['isDistributeur']);
break;
case 2:
if ($currentAddr > 0) {
$retailerData = array('R_Active' => $retailer['R_Active'], 'R_Status' => $retailer['isDistributeur']);
$oAddress->save($currentAddr, $retailer, 1);
$oAddress->save($currentAddr, $data['retailerFormEn'], 2);
} else {
$addressId = $oAddress->insert($retailer, 1);
$oAddress->save($addressId, $data['retailerFormEn'], 2);
$retailerData = array('R_GenericProfileId' => $id, 'R_RetailerAddressId' => $addressId, 'R_Status' => $retailer['isDistributeur'], 'R_Active' => $retailer['R_Active']);
}
break;
default:
break;
}
parent::save($retailerId, $retailerData, $langId);
}
public function save(&$errors)
{
if ($this->balance < 0) {
$errors[] = 'You do not have sufficient balance of ' . $this->stitem . ' at ' . $this->whlocation;
} else {
parent::save();
}
}
public function save($debug = false)
{
$db =& DB::Instance();
$result = parent::save($debug);
if ($result !== false) {
$result = $db->UpdateBlobFile($this->_tablename, 'file', $this->tmp_name, 'id=' . $this->id);
}
return $result;
}
public function save($id, $data, $langId)
{
$addrId = $id;
if (empty($id)) {
$addrId = parent::insert($data, $langId);
} else {
parent::save($id, $data, $langId);
}
return $addrId;
}
/**
* Extend save to update properties of parent-tasks
*/
public function save($debug = false)
{
$res = parent::save($debug);
$p_id = $this->parent_id;
if ($res === false || empty($p_id)) {
return $res;
}
$this->updateParent();
return true;
}
public function save($debug = false)
{
$db = DB::Instance();
$db->StartTrans();
$result = parent::save($debug);
if ($result === false) {
$db->FailTrans();
}
$db->CompleteTrans();
return $result;
}
function save(&$errors)
{
if (parent::save()) {
foreach ($this->unsaved_lines as $line) {
if (!$line->save()) {
$errors[] = 'Failed to save Transfer Line';
break;
}
}
} else {
$errors[] = 'Failed to save Transfer Header';
}
}
public function save($debug = false)
{
$db = DB::Instance();
$db->startTrans();
$result = parent::save($debug);
if ($result === false) {
$flash = Flash::Instance();
$flash->addError('Error saving Order Header : ' . $db->ErrorMsg());
$db->FailTrans();
}
$db->CompleteTrans();
return $result;
}
public function save($id, $data, $langId)
{
parent::save($id, $data, $langId);
if (is_array($data['DateRange'])) {
$dateRangeObject = new EventsDateRange();
$dateRangeObject->delete($this->_db->quoteInto('EDR_EventsDataID = ?', $id));
foreach ($data['DateRange'] as $_range) {
if (!empty($_range['from'])) {
$_range['to'] = !empty($_range['to']) ? $_range['to'] : $_range['from'];
$dateRangeObject->insert(array('EDR_EventsDataID' => $id, 'EDR_StartDate' => $_range['from'], 'EDR_EndDate' => $_range['to']));
}
}
}
}
public function save($id, $data, $langId)
{
$addrId = 0;
if (isset($data[$this->_formDataName])) {
$oAdress = new AddressObject();
$addr = $data[$this->_formDataName];
// $addrShip = $data['addressShipping'];
}
if (!empty($addr)) {
$addrId = $oAdress->save($data[$this->_addressField], $addr, $langId);
} else {
$addrId = $oAdress->insert($data[$this->_formDataName], $langId);
}
if (empty($data[$this->_addressField])) {
$data[$this->_addressField] = $addrId;
}
parent::save($id, $data, $langId);
}
function prepostprocess()
{
$message = "";
//prepostprocess//
$this->rapyd->load("dataobject");
$do = new DataObject("articles");
$do->set("title", "New Post");
$do->set("body", "New body");
$do->set("public", "n");
$do->post_process("insert", "relate_article_one");
$saved = $do->save();
$message = '<strong>$do->save()</strong><hr/>';
if ($saved) {
$art_id = $do->get("article_id");
$message .= "record <strong>{$art_id}</strong> created.<br/>";
$message .= nl2br(var_export($do->get_all(), true)) . "<hr/>";
$message .= $do->post_process_result;
$do->pre_process("delete", "remove_rel_toany_article");
$deleted = $do->delete();
$message .= '</div><br/><div class="note">';
$message .= '<strong>$do->delete()</strong><hr/>';
$message .= "<strong>remove_rel_toany_article()</strong> pre_process func.<hr/>";
if ($deleted) {
$message .= "OK, article {$art_id} is now not related with any article<hr/>";
$message .= "record of article {$art_id} deleted<hr/>";
} else {
$message .= "pre_process fails, so article {$art_id} not deleted<hr/>";
}
} else {
$message = "creation fails<br/>";
}
$data["content"] = $message;
//endprepostprocess//
$content["content"] = $this->load->view('rapyd/prepostprocess', $data, true);
$content["rapyd_head"] = "";
$content["code"] = highlight_code_file(THISFILE, "//prepostprocess//", "//endprepostprocess//");
$content["code"] .= '<br/><br/> <span style="color: #FF8000">//relate_article_one function<br /></span><br/>';
$content["code"] .= highlight_code_file(THISFILE, "//relatearticleone//", "//endrelatearticleone//");
$content["code"] .= '<br/><br/> <span style="color: #FF8000">//remove_rel_toany_article function<br /></span><br/>';
$content["code"] .= highlight_code_file(THISFILE, "//removerelarticle//", "//endremoverelarticle//");
$this->load->view('rapyd/template', $content);
}
public function save()
{
$db = DB::Instance();
$db->StartTrans();
$result = parent::save();
if ($result && $this->production_recording == 'false') {
foreach ($this->centres as $centre) {
if ($centre->production_recording == 't') {
$centre->production_recording = false;
if (!$centre->save()) {
$result = false;
$db->FailTrans();
break;
}
}
}
}
$db->CompleteTrans();
return $result;
}
function save()
{
if ($this->contactmethod_id != '') {
$partycontactmethod = DataObjectFactory::Factory('PartyContactMethod');
$partycontactmethod->load($this->id);
if ($partycontactmethod->isLoaded() && $this->contactmethod_id != $partycontactmethod->contactmethod_id) {
// Update to Party Contact Method, now points to different Contact Method
// so get the old Contact Method id for use below
$old_contactmethod = $partycontactmethod->contactmethod_id;
}
$db = DB::Instance();
$db->StartTrans();
$errors = array();
if ($this->main[0] == 't') {
$partycontactmethod = DataObjectFactory::Factory('PartyContactMethod');
$cc = new ConstraintChain();
$cc->add(new Constraint('party_id', '=', $this->party_id));
$cc->add(new Constraint('"type"', '=', $this->type));
$cc->add(new Constraint('main', 'is', 'true'));
foreach ($partycontactmethod->getAll($cc) as $id => $value) {
if (!$partycontactmethod->update($id, 'main', 'false')) {
break;
}
}
}
$result = parent::save();
if ($result && !empty($old_contactmethod)) {
// Party Contact Method has been saved OK, and Contact Method has changed
// so delete old Contact Method if no other party is linked to it
$contactmethod = DataObjectFactory::Factory('ContactMethod');
$result = $contactmethod->delete($old_contactmethod, $errors);
}
if ($result === FALSE || count($errors) > 0) {
$flash = Flash::Instance();
$flash->addErrors($errors);
$db->FailTrans();
}
$db->CompleteTrans();
}
return true;
}
function save()
{
$partyaddress = DataObjectFactory::Factory('PartyAddress');
$partyaddress->load($this->id);
if ($partyaddress->isLoaded() && $this->address_id != $partyaddress->address_id) {
// Update to Party Address, now points to different address
// so get the old address id for use below
$old_address = $partyaddress->address_id;
}
$db = DB::Instance();
$db->StartTrans();
$errors = array();
if ($this->main[0] == 't') {
$cc = new ConstraintChain();
$cc->add(new Constraint('party_id', '=', $this->party_id));
$cc->add(new Constraint('main', 'is', 'true'));
foreach ($partyaddress->getAll($cc) as $id => $value) {
if ($partyaddress->id != $id && !$partyaddress->update($id, 'main', 'false')) {
$errors[] = 'Error updating addresses : ' . $db->ErrorMsg();
}
}
}
$result = parent::save();
if ($result && !empty($old_address)) {
// Party address has been saved OK, and address has changed
// so delete old address if no other party is linked to it
$address = DataObjectFactory::Factory('Address');
$result = $address->delete($old_address, $errors);
}
if ($result === FALSE || count($errors) > 0) {
$flash = Flash::Instance();
$flash->addErrors($errors);
$db->FailTrans();
}
$db->CompleteTrans();
return $result;
}
function anular($id)
{
$error = "";
$this->rapyd->load('dataobject');
$do = new DataObject("odirect");
$do->load($id);
$status = $do->get('status');
if (empty($error)) {
if ($status == "M2") {
$do->set('status', 'MA');
$do->save();
} else {
$error .= "<div class='alert'><p>Este Pago No puede ser Anulado</p></div>";
}
}
if (empty($error)) {
logusu('pagomonetario', 'anulo pago monetario numero $id');
redirect($this->url . "dataedit/show/{$id}");
} else {
$data['content'] = $error . anchor($this->url . "dataedit/show/{$id}", 'Regresar');
$data['title'] = " {$this->t**s} ";
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script("plugins/jquery.numeric.pack.js");
$this->load->view('view_ventanas', $data);
}
}
function reversar($id)
{
$this->rapyd->load('dataobject');
$do = new DataObject("odirect");
$do->rel_one_to_many('itodirect', 'itodirect', array('numero' => 'numero'));
$do->load($id);
$error = "";
$codigoadm = $do->get('estadmin');
$fondo = $do->get('fondo');
$presup = new DataObject("presupuesto");
$pk = array('codigoadm' => $codigoadm, 'tipo' => $fondo);
$partidaiva = $this->datasis->traevalor("PARTIDAIVA");
//$pk['codigopres'] = $partidaiva;
//$presup->load($pk);
//
//$asignacion =$presup->get("asignacion");
//$aumento =$presup->get("aumento");
//$disminucion =$presup->get("disminucion");
//$traslados =$presup->get("traslados");
//$comprometido =$presup->get("comprometido");
//$disp=(($asignacion+$aumento-$disminucion)+($traslados))-$comprometido;
//
$ivaa = $do->get('ivaa');
$ivag = $do->get('ivag');
$ivar = $do->get('ivar');
$iva = $do->get('iva');
$ivan = $ivag + $ivar + $ivaa + $iva;
//if($ivan > $disp)
// $error.="<div class='alert'><p>El monto de iva ($ivan) de la orden de pago directa, es mayor al monto disponible ($disp) para la partida de iva ($partidaiva)</p></div>";
if (empty($error)) {
$sta = $do->get('status');
if ($sta == "B2") {
//for($i=0;$i < $do->count_rel('itodirect');$i++){
//
// $codigopres = $do->get_rel('itodirect','partida',$i);
// $piva = $do->get_rel('itodirect','iva' ,$i);
//
// if($piva=2222){
// $subt = $do->get_rel('itodirect','subt' ,$i);
// $mont = $subt;
// }else{
// $importe = $do->get_rel('itodirect','importe',$i);
// $mont = $importe;
// }
//
// $pk['codigopres'] = $codigopres;
//
// $presup->load($pk);
// $asignacion =$presup->get("asignacion");
// $aumento =$presup->get("aumento");
// $disminucion =$presup->get("disminucion");
// $traslados =$presup->get("traslados");
// $comprometido =$presup->get("comprometido");
//
// $disponible=(($asignacion+$aumento-$disminucion)+($traslados))-$comprometido;
// if($mont > $disponible){
// $error.="<div class='alert'><p>No se Puede Completar la Transaccion debido a que el monto de la $this->t**s ($mont) es mayor al monto disponible($disponible) para la partida: $codigopres</p></div>";
// }
//}
if (empty($error)) {
for ($i = 0; $i < $do->count_rel('itodirect'); $i++) {
$codigopres = $do->get_rel('itodirect', 'partida', $i);
$piva = $do->get_rel('itodirect', 'iva', $i);
if ($piva == 2222) {
$subt = $do->get_rel('itodirect', 'subt', $i);
$mont = $subt;
} else {
$importe = $do->get_rel('itodirect', 'importe', $i);
$mont = $importe;
}
$pk['codigopres'] = $codigopres;
$presup->load($pk);
$comprometido = $presup->get("comprometido");
$causado = $presup->get("causado");
$opago = $presup->get("opago");
$comprometido -= $mont;
$causado -= $mont;
$opago -= $mont;
$presup->set("comprometido", $comprometido);
$presup->set("causado", $causado);
$presup->set("opago", $opago);
$presup->save();
}
$pk['codigopres'] = $partidaiva;
$presup->load($pk);
$comprometido = $presup->get("comprometido");
$causado = $presup->get("causado");
$opago = $presup->get("opago");
$comprometido -= $ivan;
$causado -= $ivan;
$opago -= $ivan;
$presup->set("comprometido", $comprometido);
$presup->set("causado", $causado);
$presup->set("opago", $opago);
$presup->save();
$do->set('status', 'B1');
$do->save();
}
}
}
if (empty($error)) {
redirect($this->url . "dataedit/show/{$id}");
} else {
$data['content'] = $error . anchor($this->url . "dataedit/show/{$id}", 'Regresar');
$data['title'] = " {$this->t**s} ";
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script("plugins/jquery.numeric.pack.js");
$this->load->view('view_ventanas', $data);
}
}
function _validacheque($do)
{
$this->rapyd->load('dataobject');
$error = '';
$cod_prov = $do->get('cod_prov');
$codbanc = $do->get('codbanc');
$monto = $do->get('monto');
$cheque = $do->get('cheque');
$tipo_doc = $do->get('tipo_doc');
$observa = $do->get('observa');
$id = $do->get('id');
$fecha = $do->get('fecha');
$bcta = $do->get('bcta');
$desem = $do->get('desem');
$benefi = $do->get('benefi');
$destino = $do->get('destino');
$observa2 = $do->get('observa2');
$error .= $this->chbanse($codbanc, $fecha);
$existecaja = $this->datasis->traevalor('EXISTECAJA');
$mbanc = new DataObject("mbanc");
$mbanc->load($id);
$tcodbanc = $mbanc->get('codbanc');
$tmonto = $mbanc->get('monto');
$tcheque = $mbanc->get('cheque');
$ttipo_doc = $mbanc->get('tipo_doc');
$tobserva = $mbanc->get('observa');
$tfecha = $mbanc->get('fecha');
$tbenefi = $mbanc->get('benefi');
$tdestino = $mbanc->get('destino');
$trelch = $mbanc->get('relch');
$tobserva2 = $mbanc->get('observa2');
$desem = $mbanc->get('desem');
$mbanc->set('desem', $desem);
if ($existecaja == "S") {
$fcajrecibe = $do->get('fcajrecibe');
$fcajdevo = $do->get('fcajdevo');
if (!empty($fcajrecibe) && empty($fcajdevo)) {
$error .= "ERROR: El cheque ({$tcheque}) del banco ({$tcodbanc}) se encuentra en caja. Caja tiene el cheque fisicamente, el cheque debe ser devuelto de caja al emisor de cheques";
}
}
$do->set('fecha', $tfecha);
if (empty($error)) {
if (true) {
if (($this->datasis->traevalor('CREANCDIA') == 'S' and 1 * date('Ymd') != 1 * date('Ymd', strtotime($fecha))) || date('m', strtotime($fecha)) != date('m', strtotime($tfecha)) || ($this->datasis->traevalor('CREANCRELCH') == 'S' and strlen($trelch) > 0)) {
if ($codbanc != $tcodbanc) {
$this->chexiste_cheque($codbanc, $cheque, $tipo_doc, $id, $e);
$error .= $e;
$banc = new DataObject("banc");
$banc->load($codbanc);
$saldo = $banc->get('saldo');
$activo = $banc->get('activo');
$banco = $banc->get('banco');
if ($activo != 'S') {
$error .= "<div class='alert'><p>El banco ({$banco}) esta inactivo</p></div>";
}
if ($monto > $saldo) {
$error .= "<div class='alert'><p>El Monto ({$monto}) del cheque es mayor al disponible ({$saldo}) en el banco ({$banco})</p></div>";
}
if (empty($error)) {
$banc->set('saldo', $saldo - $monto);
$banc->save();
$banc->load($tcodbanc);
$saldo = $banc->get('saldo');
$banc->set('saldo', $saldo + $monto);
$banc->save();
if (empty($error)) {
$do->set('tipo_doc', $ttipo_doc);
$do->set('cheque', $tcheque);
$do->set('codbanc', $tcodbanc);
$do->set('benefi', $tbenefi);
$do->set('destino', $tdestino);
$do->set('observa', $tobserva);
$do->set('observa2', $tobserva2);
$do->set('fliable', date('Y-m-d'));
$do->set('status', 'A2');
$this->creambanc($codbanc, $monto, $cheque, $tipo_doc, $observa, $fecha, $cod_prov, 'E2', $id, $bcta, $desem, $benefi, 'S', NULL, $destino, $observa2);
$this->creambanc($tcodbanc, $monto, 'NC' . $tcheque, 'NC', "1-Creada para respaldar cambio de cheque {$tcheque}", $fecha, $cod_prov, 'NC', $id, '', $desem, $tbenefi, 'N', NULL, $destino, $observa2);
}
}
} else {
$this->chexiste_cheque($codbanc, $cheque, $tipo_doc, $id, $e);
$error .= $e;
if (empty($error)) {
//exit('7');
$do->set('tipo_doc', $ttipo_doc);
$do->set('cheque', $tcheque);
$do->set('codbanc', $tcodbanc);
$do->set('benefi', $tbenefi);
$do->set('destino', $tdestino);
$do->set('observa', $tobserva);
$do->set('observa2', $tobserva2);
$do->set('status', 'A2');
$this->creambanc($codbanc, $monto, $cheque, $tipo_doc, $observa, $fecha, $cod_prov, 'E2', $id, '', $desem, $benefi, 'S', NULL, $destino, $observa2);
$this->creambanc($codbanc, $monto, $tcheque, 'NC', "Anulacion de cheque {$tcheque}", $fecha, $cod_prov, 'NC', $id, '', $desem, $tbenefi, 'N', NULL, $tdestino, $observa2);
}
//exit("a".$error);
}
} else {
if ($codbanc != $tcodbanc) {
$this->chexiste_cheque($codbanc, $cheque, $tipo_doc, $id, $e);
$error .= $e;
$banc = new DataObject("banc");
$banc->load($codbanc);
$saldo = $banc->get('saldo');
$activo = $banc->get('activo');
$banco = $banc->get('banco');
if ($activo != 'S') {
$error .= "<div class='alert'><p>El banco ({$banco}) esta inactivo</p></div>";
}
if ($monto > $saldo) {
$error .= "<div class='alert'><p>El Monto ({$monto}) del cheque es mayor al disponible ({$saldo}) en el banco ({$banco})</p></div>";
}
if (empty($error)) {
//exit('10');
$banc->set('saldo', $saldo - $monto);
$banc->save();
$banc->load($tcodbanc);
$saldo = $banc->get('saldo');
$banc->set('saldo', $saldo + $monto);
$banc->save();
if (empty($error)) {
//exit('11');
$do->set('tipo_doc', $ttipo_doc);
$do->set('cheque', $tcheque);
$do->set('codbanc', $tcodbanc);
$do->set('benefi', $tbenefi);
$do->set('observa', $tobserva);
$do->set('observa2', $tobserva2);
$do->set('status', 'AN');
$this->creambanc($codbanc, $monto, $cheque, $tipo_doc, $observa, $fecha, $cod_prov, 'E2', $id, '', $desem, $benefi, 'S', NULL, $destino, $observa2);
}
}
} else {
$this->chexiste_cheque($codbanc, $cheque, $tipo_doc, $id, $e);
$error .= $e;
if (empty($error)) {
print_r($do->get_all());
// exit('21');
$do->set('tipo_doc', $ttipo_doc);
$do->set('cheque', $tcheque);
$do->set('codbanc', $tcodbanc);
$do->set('benefi', $tbenefi);
$do->set('observa', $tobserva);
$do->set('observa2', $tobserva2);
$do->set('status', 'AN');
}
$this->creambanc($codbanc, $monto, $cheque, $tipo_doc, $observa, $fecha, $cod_prov, 'E2', $id, '', $desem, $benefi, 'S', NULL, $destino, $observa2);
}
}
} else {
$this->chexiste_cheque($tcodbanc, $tcheque, $ttipo_doc, $id, $e);
$error .= $e;
}
}
if (empty($error)) {
logusu('desem', "cambio datos cheque/banco {$ttipo_doc} Nro {$tcheque} por {$tipo_doc} Nro {$cheque} movimento {$id}");
} else {
$do->error_message_ar['pre_ins'] = $error;
$do->error_message_ar['pre_upd'] = $error;
logusu('desem', "cambio datos cheque/banco {$ttipo_doc} Nro {$tcheque} por {$tipo_doc} Nro {$cheque} movimento {$id} con error {$error}");
return false;
}
}
function termina($numero)
{
$this->rapyd->load('dataobject');
$error = '';
$do = new DataObject("ingresos");
$do->load($numero);
$status = $do->get('status');
if ($status == 'P') {
$do->set('status', 'C');
} else {
$error .= "<div class='alert'>No se puede realizar la operacion para el certificado</div>";
}
if (empty($error)) {
$do->save();
logusu('ingresos', "Marco como terminado Ingreso nro {$numero}");
redirect($this->url . "dataedit/show/{$numero}");
} else {
logusu('cdisp', "Marco como terminado ingreso nro {$numero} con ERROR {$error}");
$data['content'] = $error . anchor($this->url . "dataedit/show/{$numero}", 'Regresar');
$data['title'] = " {$this->t**s}";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
}
function guardar()
{
$this->rapyd->load('dataobject');
$fechad = $this->input->post('fechad');
$fechah = $this->input->post('fechah');
$fechad2 = $this->db->escape(human_to_dbdate($fechad));
$fechah2 = $this->db->escape(human_to_dbdate($fechah));
$cant = $this->input->post('cant');
$codigoadm = $this->input->post('codigoadm');
$fondo = $this->input->post('fondo');
$do = new DataObject("mbanc");
$error = '';
$query = "SELECT numero,impmunicipal FROM MUNICIPAL";
$retenciones = $this->db->query($query);
$cant2 = $retenciones->num_rows();
$pagos = $compras = array();
$reten = 0;
foreach ($retenciones->result() as $row) {
$reten += $row->impmunicipal;
if ('' > 0) {
$compras[] = '';
} else {
$pagos[] = $row->numero;
}
}
if ($cant != $cant2) {
$error .= "<div class='alert'>Los montos Previsualizados y los actuales no parecen ser iguales</div>";
}
if (empty($error)) {
if ($reten > 0) {
$do->set("monto", $reten);
$do->set("status", "J");
$do->set("tipo", "M");
$do->set("tipo_doc", "ND");
$do->set("observa", ".Se cancelo el Impuesto Municipal desde {$fechad} hasta {$fechah} actividad {$codigoadm} fondo {$fondo}");
$do->set('rel', implode(',', $pagos) . '|' . implode(',', $compras));
$do->save();
$id = $do->get('id');
if (!$id > 0) {
$error .= "Ocurrio error al momento de Crear el movimiento bancario";
}
if (empty($error)) {
$query = "UPDATE odirect a \r\n\t\t\t\t\tJOIN pades b ON a.numero = b.pago\r\n\t\t\t\t\tJOIN desem c ON b.desem = c.numero\r\n\t\t\t\t\tSET a.mmuni={$id}\r\n\t\t\t\t\tWHERE c.status='D2' AND impmunicipal >0 AND fdesem>={$fechad2} AND fdesem<= {$fechah2} AND MID(a.status,1,1)<>'F' AND (a.mmuni IS NULL)";
if (!empty($codigoadm)) {
$query .= " AND a.estadmin='{$codigoadm}'";
}
if (!empty($fondo)) {
$query .= " AND a.fondo='{$fondo}'";
}
$bool = $this->db->simple_query($query);
if (!$bool) {
$error .= "Ocurrio error al momento de actualizar la tabla pagos";
}
}
} else {
$error .= "<div class='alert'><p>No hay IMPUESTO MUNICIPAL por pagar desde {$fechad} hasta {$fechah} </p></div>";
}
}
if (empty($error)) {
logusu('MUNICIPAL', "Creo movimiento bancario de Pago de IMPUESTO MUNICIPAL {$id}");
redirect("tesoreria/mbanc/dataedit/modify/" . $id);
} else {
logusu('MUNICIPAL', "intento crear movimiento bancario de Pago de IMPUESTO MUNICIPAL con error {$error}");
$data['content'] = $error . anchor($this->url . "nuevo", 'Regresar');
$data['title'] = " " . $this->t**s . " ";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
}
function anular($id)
{
$this->rapyd->load('dataobject');
$do = new DataObject("otrabajo");
$do->load($id);
$do->set('status', 'A');
$do->save();
logusu('otrabajo', "Anulo Orden de Compra Nro {$id}");
redirect("presupuesto/otrabajo/dataedit/show/{$id}");
}
function actualizar($id)
{
$error = "";
$this->rapyd->load('dataobject');
$do = new DataObject("odirect");
$do->load($id);
$obr = $do->get('obr');
$factura = $do->get('factura');
$controlfac = $do->get('controlfac');
$fechafac = $do->get('fechafac');
$reteiva = $do->get('reteiva');
$ivaa = $do->get('ivaa');
$ivag = $do->get('ivag');
$ivar = $do->get('ivar');
$iva = $do->get('iva');
$amortiza = $do->get('amortiza');
$total = $do->get('total');
$total2 = $do->get('total2');
$obra = new DataObject("obra");
$obra->load($obr);
$codigoadm = $obra->get('codigoadm');
$fondo = $obra->get('fondo');
$codigopres = $obra->get('codigopres');
$ordinal = $obra->get('ordinal');
$monto = $obra->get('monto');
$pagado = $obra->get('pagado');
$demostrado = $obra->get('demostrado');
$o_status = $obra->get('status');
$pagoviejo = $obra->get('pagoviejo');
$mont = $total2 - $amortiza;
if ($o_status == "O1") {
$error .= "<div class='alert'><p>No se pueden hacer pagos para la obra {$obr} </p></div>";
}
if (round($mont, 2) > round($monto - ($pagado + $pagoviejo), 2)) {
$error .= "<div class='alert'><p>El Monto({$mont}) de la orden de pago es mayor al monto adeudado (" . ($monto - ($pagado + $pagoviejo)) . ") para la obra {$obr} </p></div>";
}
if ($reteiva > 0 && (empty($factura) || empty($controlfac) || empty($fechafac))) {
$error .= "<div class='alert'><p> Los campos Nro. Factura, Nro Control y Fecha factura no pueden estar en blanco</p></div>";
}
if (empty($error)) {
$sta = $do->get('status');
if ($sta == "O1") {
$mont = $total2 - $amortiza;
$error .= $this->chequeapresup($codigoadm, $fondo, $codigopres, $ordinal, $mont, 0, 'round($monto,2) > round(($comprometido-$causado),2)', "El Monto ({$mont}) es mayor al disponible para la partida ({$codigoadm}) ({$fondo}) ({$codigopres}) ({$ordinal})");
if (empty($error)) {
$error .= $this->afectapresup($codigoadm, $fondo, $codigopres, $ordinal, $mont, 0, 1, array("causado", "opago"));
$obra->set('pagado', $pagado + $mont);
$do->set('fopago', date('Ymd'));
$obra->set('status', 'O4');
$obra->save();
}
}
}
if (empty($error)) {
$do->set('status', 'O2');
$do->set('fopago', date('Ymd'));
$do->save();
logusu('pobra', "Actualizo Pago de Obra {$id}");
redirect($this->url . "dataedit/show/{$id}");
} else {
logusu('pobra', "Actualizo Pago de Obra {$id} con error {$error}");
$data['content'] = $error . anchor($this->url . "dataedit/show/{$id}", 'Regresar');
$data['title'] = " {$this->t**s} ";
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script("plugins/jquery.numeric.pack.js");
$this->load->view('view_ventanas', $data);
}
}
function _validafac($do)
{
$this->rapyd->load('dataobject');
$factura = $do->get('factura');
$controlfac = $do->get('controlfac');
$fechafac = $do->get('fechafac');
$numero = $do->get('numero');
$cod_prov = $do->get('cod_prov');
$this->chexiste_factura($numero, $factura, $controlfac, $cod_prov, 'B', $e);
$error = $e;
$riva = new DataObject("riva");
$riva->load_where(array('odirect' => $numero, 'status <>' => 'A', 'status <>' => 'AN'));
$status = $riva->get('status');
$nrocomp = $riva->get('nrocomp');
if (!empty($nrocomp) && !($status == 'B' || $status == 'A')) {
$error .= "No se puede cambiar el numero de factura debido a que la retencion de iva ({$nrocomp}) ya fue declarada";
}
if (empty($error)) {
$riva->set('numero', $factura);
$riva->set('nfiscal', $controlfac);
$riva->set('ffactura', $fechafac);
$riva->save();
} else {
$do->error_message_ar['pre_ins'] = $error;
$do->error_message_ar['pre_upd'] = $error;
logusu('odirect', "Cambio datos Factura {$factura} Nro {$controlfac} fecha {$fechafac},orden de pago {$numero} con error {$error}");
return false;
}
}
function reversar($id)
{
$this->rapyd->load('dataobject');
$do = new DataObject("odirect");
$do->rel_one_to_many('itodirect', 'itodirect', array('numero' => 'numero'));
$do->load($id);
$sta = $do->get('status');
if ($sta == 'C') {
$codigoadm = $do->get('estadmin');
$fondo = $do->get('fondo');
$presup = new DataObject("presupuesto");
$pk = array('codigoadm' => $codigoadm, 'tipo' => $fondo);
$error = '';
$tiva = 0;
for ($i = 0; $i < $do->count_rel('itodirect'); $i++) {
$codigopres = $do->get_rel('itodirect', 'partida', $i);
$importe = $do->get_rel('itodirect', 'importe', $i);
$iva = $do->get_rel('itodirect', 'iva', $i);
$m = $importe * (($iva + 100) / 100) - $importe;
$tiva += $m;
$mont = $importe;
$pk['codigopres'] = $codigopres;
$presup->load($pk);
$comprometido = $presup->get("comprometido");
$causado = $presup->get("causado");
$opago = $presup->get("opago");
$pagado = $presup->get("pagado");
$comprometido -= $mont;
$causado -= $mont;
$opago -= $mont;
$pagado -= $mont;
$presup->set("comprometido", $comprometido);
$presup->set("causado", $causado);
$presup->set("opago", $opago);
$presup->set("pagado", $pagado);
$presup->save();
}
$partidaiva = $this->datasis->traevalor("PARTIDAIVA");
$pk['codigopres'] = $partidaiva;
$presup->load($pk);
$comprometido = $presup->get("comprometido");
$causado = $presup->get("causado");
$opago = $presup->get("opago");
$pagado = $presup->get("pagado");
$comprometido -= $tiva;
$causado -= $tiva;
$opago -= $tiva;
$pagado -= $tiva;
$presup->set("comprometido", $comprometido);
$presup->set("causado", $causado);
$presup->set("opago", $opago);
$presup->set("pagado", $pagado);
$presup->save();
$do->set('status', 'P');
$do->save();
}
redirect($this->url . "/dataedit/show/{$id}");
}
function reversar($id)
{
$this->rapyd->load('dataobject');
$do = new DataObject("opago");
$do->rel_one_to_many('itopago', 'itopago', array('numero' => 'numero'));
$do->load($id);
$sta = $do->get('status');
if ($sta == 'C') {
$codigoadm = $do->get('estadmin');
$fondo = $do->get('fondo');
$ordc = new DataObject("ocompra");
$ordc->rel_one_to_many('itocompra', 'itocompra', array('numero' => 'numero'));
$error = '';
for ($i = 0; $i < $do->count_rel('itopago'); $i++) {
$orden = $do->get_rel('itopago', 'orden', $i);
$pago = $do->get_rel('itopago', 'pago', $i);
$pk2 = array('numero' => $orden);
$ordc->load($pk2);
$debe = $ordc->get('total');
$status = $ordc->get('status');
if ($status != 'R') {
$error .= "<div class='alert'><p>Orden Compra ({$orden}): No ha sido Procesada</p></div>";
}
}
}
if (empty($error)) {
$presup = new DataObject("presupuesto");
for ($i = 0; $i < $do->count_rel('itopago'); $i++) {
$orden = $do->get_rel('itopago', 'orden', $i);
$pago = $do->get_rel('itopago', 'pago', $i);
$pk2 = array('numero' => $orden);
$ordc->load($pk2);
$debe = $ordc->get('total');
$codigoadm = $ordc->get('estadmin');
$fondo = $ordc->get('fondo');
$abono = $ordc->get('abono');
$pk = array('codigoadm' => $codigoadm, 'tipo' => $fondo);
for ($i = 0; $i < $ordc->count_rel('itocompra'); $i++) {
$codigopres = $ordc->get_rel('itocompra', 'partida', $i);
$importe = $ordc->get_rel('itocompra', 'importe', $i);
$iva = $ordc->get_rel('itocompra', 'iva', $i);
$mont = $importe * (($iva + 100) / 100);
$pk['codigopres'] = $codigopres;
$presup->load($pk);
$causado = $presup->get("causado");
$causado -= $mont;
$presup->set("opago", $causado);
$presup->save();
}
$ordc->set('status', 'T');
$ordc->save();
$do->set('status', 'P');
$do->save();
}
redirect("presupuesto/opago2/dataedit/show/{$id}");
} else {
$data['content'] = $error . anchor("presupuesto/opago2/dataedit/show/{$id}", 'Regresar');
$data['title'] = " Orden de Pago ";
$data["head"] = $this->rapyd->get_head() . script('jquery.js') . script("plugins/jquery.numeric.pack.js");
$this->load->view('view_ventanas', $data);
}
}
public function save($id, $data, $langId)
{
$tmpVal = array();
if (empty($data['MR_Diseases'])) {
$data['MR_Diseases'] = 0;
}
$tmpVal = explode(',', $data['MR_Diseases']);
$oDiseaseD = new DiseasesDetailsObject();
foreach ($data as $field => $dd) {
if (preg_match('/dd_[0-9]*/', $field)) {
$diseaseData = array();
$value = '';
foreach ($dd as $key => $value) {
$dId = explode('_', $field);
if (is_array($value)) {
$value = implode(',', $value);
}
$diseaseData[$oDiseaseD->getForeignKey()] = $data['genericId'];
$diseaseData['DD_DiseaseId'] = $dId[1];
$diseaseData[$key] = $value;
}
if (in_array($dId[1], $tmpVal)) {
$oDiseaseD->setFilters(array($oDiseaseD->getForeignKey() => $data['genericId'], 'DD_DiseaseId' => $dId[1]));
$exist = $oDiseaseD->getAll();
if (count($exist) > 0) {
$oDiseaseD->save($exist[0][$oDiseaseD->getDataId()], $diseaseData, 1);
} else {
$oDiseaseD->insert($diseaseData, 1);
}
}
}
}
if (!empty($data['MR_ExpiracyDate'])) {
$data['MR_ExpiracyDate'] = date('Y-m-d', strtotime($data['MR_ExpiracyDate']));
}
if (!empty($data['MR_TravelInduranceExpiracy'])) {
$data['MR_TravelInduranceExpiracy'] = date('Y-m-d', strtotime($data['MR_TravelInduranceExpiracy']));
}
parent::save($id, $data, $langId);
}
function save()
{
$wasNew = $this->isNew();
$result = parent::save();
if ($result && $this->isSearchable()) {
$this->addToSearchableObjects($wasNew);
}
return $result;
}
