/**
* Static function to display form for the field type
* @param string $name
* @param string $value
* @param string $css
* @return html for the form containing the field
*/
public static function display_field($name, $idfield, $value = '', $css = 'form-control input-sm')
{
$combo_values = new ComboValues();
$combo_values->get_combo_values($idfield);
echo '<select class="' . $css . '" name = "' . $name . '" id="' . $name . '">' . "\n";
if ($combo_values->getNumRows() > 0) {
while ($combo_values->next()) {
$select = '';
if ($value == $combo_values->combo_value) {
$select = 'Selected';
}
echo '<option value = "' . $combo_values->combo_option . '" ' . $select . '>' . $combo_values->combo_value . '</option>' . "\n";
}
}
echo '</select>';
}
/**
* Static function to display form for the field type
* @param string $name
* @param string $value
* @param string $css
* @return html for the form containing the field
*/
public static function display_field($name, $idfield, $value = '', $css = '')
{
$combo_values = new ComboValues();
$combo_values->get_combo_values($idfield);
if ($value != '') {
$val_to_array = explode(",", $value);
}
echo '<select class="' . $css . '" name = "' . $name . '[]" id="' . $name . '" size= 5 multiple>' . "\n";
if ($combo_values->getNumRows() > 0) {
while ($combo_values->next()) {
$select = '';
if ($value != '' && in_array($combo_values->combo_value, $val_to_array)) {
$select = 'Selected';
}
echo '<option value = "' . $combo_values->combo_option . '" ' . $select . '>' . $combo_values->combo_value . '</option>' . "\n";
}
}
echo '</select>';
}
/**
* function to edit the custom field
* @param object $evctl
* @see popups/edit_custom_field_modal.php
*/
public function eventEditCustomField(EventControler $evctl)
{
$idfields = (int) $evctl->idfields_ed;
$update_data = false;
if ($idfields > 0) {
$this->getId($idfields);
if ($this->getNumRows() > 0) {
$update_data = true;
} else {
$update_data = false;
$_SESSION["do_crm_messages"]->set_message('error', _('Record does not exit.'));
}
} else {
$update_data = false;
$_SESSION["do_crm_messages"]->set_message('error', _('Record does not exit.'));
}
if ($update_data === true) {
$custom_field_type = $evctl->custom_field_type_ed;
$req = $evctl->cf_req_ed;
$field_validation = array();
$is_required = false;
if ($req == 'on') {
$is_required = true;
$field_validation["required"] = true;
}
switch ($custom_field_type) {
case 1:
if ($is_required === true) {
if ($evctl->cf_max_len_ed != '' || (int) $evctl->cf_max_len_ed > 0) {
$field_validation["maxlength"] = (int) $evctl->cf_max_len_ed;
}
if ($evctl->cf_min_len_ed != '' || (int) $evctl->cf_min_len_ed > 0) {
$field_validation["minlength"] = (int) $evctl->cf_min_len_ed;
}
}
break;
case 5:
$pick_values = $evctl->cf_pick_ed;
$not_equal = $evctl->cf_pick_notequal_ed;
if ($is_required === true) {
$field_validation["notEqual"] = $not_equal;
}
break;
case 6:
$pick_values = $evctl->cf_pick_ed;
break;
}
if (count($field_validation) > 0) {
$field_validation_entry = json_encode($field_validation);
} else {
$field_validation_entry = '';
}
$qry_update = "\n\t\t\tupdate " . $this->getTable() . " \n\t\t\tset `field_label` = ?,\n\t\t\t`field_validation` = ?\n\t\t\twhere idfields = ?";
$this->query($qry_update, array(CommonUtils::purify_input($evctl->cf_label_ed), $field_validation_entry, $idfields));
if ($custom_field_type == 5 || $custom_field_type == 6) {
//$pick_values_seperated = explode(PHP_EOL,$evctl->cf_pick);
$pick_values_seperated = preg_split('/[\\r\\n]+/', $evctl->cf_pick_ed, -1, PREG_SPLIT_NO_EMPTY);
$do_combo_values = new ComboValues();
$do_combo_values->update_combo_values($idfields, $pick_values_seperated);
}
$_SESSION["do_crm_messages"]->set_message('success', _('Custom field updated successfully !'));
}
}
<?php
// Copyright SQCRM. For licensing, reuse, modification and distribution see license.txt
/**
* Pick List/ Multi select combo values manage page
* @author Abhik Chakraborty
*/
$do_crm_fields = new CRMFields();
$do_combo_values = new ComboValues();
$non_editable_combo_fields = $do_combo_values->get_non_editable_combo_fields();
// modules which does not have the custom fields or any fields
$ignore_modules = array(1, 8, 9);
if (isset($_GET["cmid"]) && $_GET["cmid"] != '') {
$cf_module = (int) $_GET["cmid"];
} else {
$cf_module = 3;
}
$modules_info = $_SESSION["do_module"]->get_modules_with_full_info();
$do_crm_fields->get_pick_multiselect_fields($cf_module);
$data_array = array();
if ($do_crm_fields->getNumRows() > 0) {
while ($do_crm_fields->next()) {
$combo_data = array();
if (in_array($do_crm_fields->idfields, $non_editable_combo_fields)) {
continue;
}
$do_combo_values->get_combo_values($do_crm_fields->idfields);
if ($do_combo_values->getNumRows() > 0) {
$combo_data = array();
while ($do_combo_values->next()) {
$combo_data[] = $do_combo_values->combo_value;
* Change password modal
* @author Abhik Chakraborty
*/
include_once "config.php";
$idmodule = (int) $_GET["idmodule"];
$referrar = $_GET["referrar"];
$idfields = (int) $_GET["sqrecord"];
$do_custom_fields = new CustomFields();
$do_custom_fields->getId($idfields);
$field_validation = $do_custom_fields->field_validation;
$field_validation_data = array();
if ($field_validation != '') {
$field_validation_data = json_decode($field_validation, true);
}
if ($do_custom_fields->field_type == 5 || $do_custom_fields->field_type == 6) {
$do_combo_values = new ComboValues();
$do_combo_values->get_combo_values($idfields);
$pick_data = '';
while ($do_combo_values->next()) {
$pick_data .= $do_combo_values->combo_value . "\n";
//adding new lines for the text area in pick options
}
}
$allow = true;
$e_add = new Event("CustomFields->eventEditCustomField");
echo '<form class="form-horizontal" id="CustomFields__eventEditCustomField" name="CustomFields__eventEditCustomField" action="/eventcontroler.php" method="post">';
echo $e_add->getFormEvent();
?>
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
