public function update(array $data, $id)
{
$model_company = new Company_Model_Company();
if ($model_company->existSupplierCompany($data["fiscal_name"], $id)) {
//TODO ENVIAR UN MENSAJE
die("supplier existe");
}
//add types of activity for the supplier
$db = Zend_Registry::get('db');
$db->delete("suppliers_has_activity_types", "suppliers_id=" . $id);
$data_activity_type["suppliers_id"] = $data["id"];
foreach ($data["activity_types_id"] as $value) {
$data_activity_type["activity_types_id"] = $value;
$db->insert("suppliers_has_activity_types", $data_activity_type);
// Zend_Debug::dump($data_activity_type);
}
// die();
$model_company = new Company_Model_Company();
$data_company = $data;
$data_company["id"] = $data_company["companies_id"];
$model_company->update($data_company, 'id = ' . (int) $data["companies_id"]);
$table = $this->getTable();
$fields = $table->info(Zend_Db_Table_Abstract::COLS);
foreach ($data as $field => $value) {
if (!in_array($field, $fields)) {
unset($data[$field]);
}
}
return $table->update($data, 'id = ' . (int) $id);
}
public function save($id)
{
$model_company = new Company_Model_Company();
$data_receipt = $model_company->fetchProductionClientCompany($_SESSION["production"]["id"]);
$data_receipt["productions_id"] = $_SESSION["production"]["id"];
$data_receipt["production_name"] = $data_receipt["name"];
unset($data_receipt["id"]);
unset($data_receipt["name"]);
$table = $this->getTable();
$fields = $table->info(Zend_Db_Table_Abstract::COLS);
foreach ($data_receipt as $field => $value) {
if (!in_array($field, $fields)) {
unset($data_receipt[$field]);
}
}
$table->insert($data_receipt);
return $table->lastInsertId();
}
function consultAction()
{
$this->_helper->layout->disableLayout();
//check if the user select a production
$this->production = new Zend_Session_Namespace('production');
if ($this->production->id == null) {
return $this->_helper->_redirector->gotoSimple('index', 'production', 'production');
}
$model = new Finances_Model_Invoices();
$this->view->title = "Consult Invoice";
$invoice_id = $this->_getParam('id', 1);
if (!$model->fetchInvoiceBelongProduction($invoice_id, $_SESSION["production"]["id"])) {
return $this->_helper->_redirector->gotoSimple('index');
}
$production_model = new Company_Model_Company();
Zend_Debug::dump($model->fetchInvoice($invoice_id));
$this->view->company = $production_model->fetchEntry($_SESSION["company"]["id"]);
$this->view->client = $model->fetchDatasReceiptEntry($invoice_id);
$this->view->invoices = $model->fetchInvoice($invoice_id);
}
public function outLitter($where)
{
$table = $this->getTable();
$model = new Company_Model_Company();
return $model->outLitter($where);
}
/**
* AddAction for Suppliers
*
* @return void
*/
public function addAction()
{
$this->view->headTitle("Add New Supplier", 'APPEND');
$request = $this->getRequest();
$form = new Supplier_Form_Supplier();
if ($this->getRequest()->isPost()) {
if ($form->isValid($request->getPost())) {
$data_company = $form->getValues();
$data_supplier["description"] = $data_company["observation"];
$data_activity_types["activity_types_id"] = $data_company["activity_types_id"];
//add the new company
$model_company = new Company_Model_Company();
$data_supplier["companies_id"] = $model_company->saveSupplier($data_company);
//add this company to supplier table
$model_supplier = new Supplier_Model_Supplier();
$data_activity_type["suppliers_id"] = $model_supplier->save($data_supplier);
$data_companies_supplier["suppliers_id"] = $data_activity_type["suppliers_id"];
//add this supplier to the company
$model_companies_supplier = new Supplier_Model_Companiessupplier();
$data_companies_supplier["companies_id"] = $_SESSION["company"]["id"];
$model_companies_supplier->save($data_companies_supplier);
$db = Zend_Registry::get('db');
//add types of activity for the supplier
// Zend_Debug::dump($data_activity_types,"tipos a insertar");
foreach ($data_activity_types["activity_types_id"] as $value) {
$data_activity_type["activity_types_id"] = $value;
// Zend_Debug::dump($data_activity_type,"inserta bd");
$db->insert("suppliers_has_activity_types", $data_activity_type);
}
return $this->_helper->_redirector->gotoSimple('select', 'supplier', 'supplier', array('id' => $data_supplier["companies_id"]));
}
} else {
$form->populate($form->getValues());
}
$this->view->form = $form;
}
/**
* AddAction for Productions
*
* @return void
*/
public function addAction()
{
$this->view->headTitle("Add New Production", 'APPEND');
$request = $this->getRequest();
//form for a new production
$production_form = new Production_Form_Production();
//form for a new client
$company_form = new Company_Form_Company();
// check if there is a selection client
$data_clients['client_companies_id'] = $this->_getParam('client_companies_id');
$production_form->populate($data_clients);
if ($this->getRequest()->isPost()) {
$data_post = $request->getPost();
if (isset($data_post["status_id"])) {
if ($production_form->isValid($request->getPost())) {
$data_production = $production_form->getValues();
$model_production = new Production_Model_Production();
$id_production = $model_production->save($data_production);
return $this->_helper->_redirector->gotoSimple('select', 'production', 'production', array('id' => $id_production));
} else {
$production_form->populate($production_form->getValues());
}
} elseif ($company_form->isValid($request->getPost())) {
$data_clients = $company_form->getValues();
$model_company = new Company_Model_Company();
$client_companies_id = $model_company->saveClient($data_clients);
return $this->_helper->_redirector->gotoSimple('add', 'production', 'production', array('client_companies_id' => $client_companies_id));
} else {
$company_form->populate($company_form->getValues());
}
}
$this->view->production_form = $production_form;
$this->view->company_form = $company_form;
}
public function outlitterAction()
{
if ($this->getRequest()->isPost()) {
$del = $this->getRequest()->getPost('del');
if ($del == 'Yes') {
$id = $this->getRequest()->getPost('id');
$model = new Company_Model_Company();
$model->outLitter('id = ' . (int) $id);
}
return $this->_helper->redirector('index');
} else {
$id = $this->_getParam('id', 0);
if ($id > 0) {
$model = new Company_Model_Company();
$this->view->company = $model->fetchEntry($id);
}
}
}
