/**
* Event function to update the organization data
* @param object $evctl
*/
public function eventEditRecord(EventControler $evctl)
{
$param_array = (array) $evctl;
$id_entity = (int) $evctl->sqrecord;
if ($id_entity > 0 && true === $_SESSION["do_crm_action_permission"]->action_permitted('edit', 14, (int) $evctl->sqrecord)) {
$obj = $this->getId($id_entity);
$obj = (object) $obj;
// convert the data array to Object
$do_process_plugins = new CRMPluginProcessor();
// process before update plugin. If any error is raised display that.
$do_process_plugins->process_action_plugins((int) $evctl->idmodule, $evctl, 3, $id_entity, $obj);
if (strlen($do_process_plugins->get_error()) > 2) {
$_SESSION["do_crm_messages"]->set_message('error', $do_process_plugins->get_error());
$next_page = NavigationControl::getNavigationLink($evctl->module, "edit");
$dis = new Display($next_page);
$dis->addParam("sqrecord", $id_entity);
if ($evctl->return_page != '') {
$dis->addParam("return_page", $evctl->return_page);
}
$evctl->setDisplayNext($dis);
} else {
$do_crm_fields = new CRMFields();
$crm_fields = $do_crm_fields->get_field_information_by_module_as_array((int) $evctl->idmodule);
$table_entity = 'sales_order';
$table_entity_custom = 'sales_order_custom_fld';
$table_entity_to_grp = 'sales_order_to_grp_rel';
$table_entity_address = 'sales_order_address';
$entity_data_array = array();
$custom_data_array = array();
$addr_data_array = array();
$assigned_to_as_group = false;
foreach ($crm_fields as $crm_fields) {
$field_name = $crm_fields["field_name"];
$field_value = $do_crm_fields->convert_field_value_onsave($crm_fields, $evctl, 'edit');
if (is_array($field_value) && count($field_value) > 0) {
if ($field_value["field_type"] == 15) {
$field_name = 'iduser';
$value = $field_value["value"];
$assigned_to_as_group = $field_value["assigned_to_as_group"];
$group_id = $field_value["group_id"];
} elseif ($field_value["field_type"] == 12) {
$value = $field_value["name"];
$avatar_array[] = $field_value;
}
} else {
$value = $field_value;
}
if ($crm_fields["table_name"] == $table_entity && $crm_fields["idblock"] > 0) {
$entity_data_array[$field_name] = $value;
} elseif ($crm_fields["table_name"] == $table_entity_custom && $crm_fields["idblock"] > 0) {
$custom_data_array[$field_name] = $value;
} elseif ($crm_fields["table_name"] == $table_entity_address && $crm_fields["idblock"] > 0) {
$addr_data_array[$field_name] = $value;
}
}
$this->update(array($this->primary_key => $id_entity), $table_entity, $entity_data_array);
//update quotes other information
$upd_array = array("terms_condition" => $evctl->terms_cond, "net_total" => $evctl->net_total_lines, "discount_type" => $evctl->final_discount_type, "discount_value" => $evctl->final_discount_val, "discounted_amount" => $evctl->final_discounted_total, "tax_values" => $evctl->final_tax_val, "taxed_amount" => $evctl->final_tax_amount, "shipping_handling_charge" => $evctl->final_ship_hand_charge, "shipping_handling_tax_values" => $evctl->final_ship_hand_tax_val, "shipping_handling_taxed_amount" => $evctl->final_ship_hand_tax_amount, "final_adjustment_type" => $evctl->final_adjustment, "final_adjustment_amount" => $evctl->final_adjustment_val, "grand_total" => $evctl->grand_total);
$this->update(array($this->primary_key => $id_entity), $table_entity, $upd_array);
//updating the last_modified,last_modified_by
$u_qry = "\n\t\t\t\tupdate `" . $this->getTable() . "` \n\t\t\t\tset \n\t\t\t\t`last_modified` = ? ,\n\t\t\t\t`last_modified_by` = ? \n\t\t\t\twhere `" . $this->primary_key . "` = ?\n\t\t\t\t";
$this->query($u_qry, array(date("Y-m-d H:i:s"), $_SESSION["do_user"]->iduser, $id_entity));
if (count($custom_data_array) > 0) {
$this->update(array($this->primary_key => $id_entity), $table_entity_custom, $custom_data_array);
}
if (count($addr_data_array) > 0) {
$this->update(array($this->primary_key => $id_entity), $table_entity_address, $addr_data_array);
}
if ($assigned_to_as_group === false) {
$qry_grp_rel = "DELETE from `{$table_entity_to_grp}` where `idsales_order` = ? LIMIT 1";
$this->query($qry_grp_rel, array($id_entity));
} else {
$qry_grp_rel = "select * from `{$table_entity_to_grp}` where `idsales_order` = ?";
$this->query($qry_grp_rel, array($id_entity));
if ($this->getNumRows() > 0) {
$this->next();
$id_grp_rel = $this->idsales_order_to_grp_rel;
$u_qry = "\n\t\t\t\t\t\tupdate `{$table_entity_to_grp}` \n\t\t\t\t\t\tset \n\t\t\t\t\t\t`idgroup` = ?\n\t\t\t\t\t\twhere `idsales_order_to_grp_rel` = ? LIMIT 1\n\t\t\t\t\t\t";
$this->query($u_qry, array($group_id, $id_grp_rel));
} else {
$this->insert($table_entity_to_grp, array("idsales_order" => $id_entity, "idgroup" => $group_id));
}
}
// Record the history
$do_data_history = new DataHistory();
$do_data_history->add_history($id_entity, (int) $evctl->idmodule, 'edit');
$do_data_history->add_history_value_changes($id_entity, (int) $evctl->idmodule, $obj, $evctl);
//record the feed
$feed_other_assigne = array();
if ($assigned_to_as_group === true) {
$feed_other_assigne = array("related" => "group", "data" => array("key" => "newgroup", "val" => $group_id));
}
$do_feed_queue = new LiveFeedQueue();
$do_feed_queue->add_feed_queue($id_entity, (int) $evctl->idmodule, $evctl->product_name, 'edit', $feed_other_assigne);
$do_line_items = new Lineitems();
$param_array = (array) $evctl;
$do_line_items->edit_line_items((int) $evctl->idmodule, $id_entity, $param_array["params"]);
// process after update plugin
$do_process_plugins->process_action_plugins((int) $evctl->idmodule, $evctl, 4, $id_entity, $obj);
$_SESSION["do_crm_messages"]->set_message('success', _('Data updated successfully !'));
$next_page = NavigationControl::getNavigationLink($evctl->module, "detail");
$dis = new Display($next_page);
$dis->addParam("sqrecord", $id_entity);
$evctl->setDisplayNext($dis);
}
} else {
$_SESSION["do_crm_messages"]->set_message('error', _('You do not have permission to edit the record ! '));
$next_page = NavigationControl::getNavigationLink($evctl->module, "list");
$dis = new Display($next_page);
$evctl->setDisplayNext($dis);
}
}
