topContent(); $imagepath = "{$plugin_url_vtlc}/images/"; $vtdb = new wpdb($config['dbuser'], $config['dbpass'], $config['dbname'], $config['hostname']); foreach ($_POST as $key => $value) { //empty the value if sanitize fails $_POST[$key] = sanitize_text_field($value); } if ($_POST['module'] == 'widget') { $config_widget_field = get_option("Vts_vtlc_widget_field_settings"); $modeled = 'widget'; if ($_POST['savedisplayname'] == 'save_display_name') { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,sequence FROM vtiger_field WHERE tabid = 4 ORDER BY block, sequence"); for ($i = 0; $i < ($_POST['no_of_fields']); $i++) { $label = $_POST['display_label' . $i]; $field = $allowedFields[$i]->fieldid; // sanitize field label $label = sanitize_text_field($label); $query1 = $vtdb->query("UPDATE `vtiger_field` SET `fieldlabel`='$label' WHERE `fieldid`='$field'"); } } if (!empty($config['hostname']) && !empty($config['dbuser'])) { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,sequence FROM vtiger_field WHERE tabid = 4 ORDER BY block, sequence"); if (!is_array($config_widget_field['widgetfieldlist'])) { $config_widget_field['widgetfieldlist'] = array(); } } } if ($_POST['module'] == 'lead') { $config_widget_field = get_option("Vts_vtpl_field_settings"); $config_widget_field['widgetfieldlist'] = $config_widget_field['fieldlist']; $modeled = 'lead'; if ($_POST['savedisplayname'] == 'save_display_name') { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,sequence FROM vtiger_field WHERE tabid = 7 ORDER BY block, sequence"); for ($i = 0; $i < ($_POST['no_of_fields']); $i++) { $label = $_POST['display_label' . $i]; $field = $allowedFields[$i]->fieldid; // sanitize field label if (preg_match('/^[A-Za-z0-9_-]*$/', $label)) { $query1 = $vtdb->query("UPDATE `vtiger_field` SET `fieldlabel`='$label' WHERE `fieldid`='$field'"); } } } if (!empty($config['hostname']) && !empty($config['dbuser'])) { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,sequence FROM vtiger_field WHERE tabid = 7 ORDER BY block, sequence"); if (!is_array($config_widget_field['widgetfieldlist'])) { $config_widget_field['widgetfieldlist'] = array(); } } } if (!empty($_POST['shortcode'])) { if ($_POST['module'] == 'widget') { $add = $_POST['option']; $edit_fild = $_REQUEST['shortcode']; // sanitize the shortcode if (preg_match('/^[A-Za-z0-9_-]*$/', $edit_fild)) { $alloweded2 = $wpdb->get_row("SELECT * FROM `create_shortcode` WHERE `shortcode`='$edit_fild'"); $new_data = json_decode("$alloweded2->select_field", true); if ($_POST['publish'] == '1') { if ($new_data == null) { $new_data = array(); array_push($new_data, $add); } else { array_push($new_data, $add); } $newdata = json_encode($new_data); echo $wpdb->update('create_shortcode', array('select_field' => $newdata), array('shortcode' => $edit_fild), array('%s'), array('%s')); } } if ($_POST['publish'] == '0') { // sanitize the shortcode if (preg_match('/^[A-Za-z0-9_-]*$/', $edit_fild)) { $alloweded2 = $wpdb->get_row("SELECT * FROM `create_shortcode` WHERE `shortcode`='$edit_fild'"); $new_data = json_decode("$alloweded2->select_field", true); $key = array_search($add, $new_data); $unsetproduct = $key; unset($new_data[$unsetproduct]); $newdata = json_encode($new_data); echo $wpdb->update('create_shortcode', array('select_field' => $newdata), array('shortcode' => $edit_fild), array('%s'), array('%s')); } } $config_widget_field['widgetfieldlist'] = $new_data; } if ($_POST['module'] == 'lead') { $add = $_POST['option']; $edit_fild = $_REQUEST['shortcode']; // sanitize the shortcode if (preg_match('/^[A-Za-z0-9_-]*$/', $edit_fild)) { $alloweded2 = $wpdb->get_row("SELECT * FROM `create_shortcode` WHERE `shortcode`='$edit_fild'"); $new_data = json_decode("$alloweded2->select_field", true); if ($_POST['publish'] == '1') { if ($new_data == null) { $new_data = array(); array_push($new_data, $add); } else { array_push($new_data, $add); } $newdata = json_encode($new_data); echo $wpdb->update('create_shortcode', array('select_field' => $newdata), array('shortcode' => $edit_fild), array('%s'), array('%s')); } } if ($_POST['publish'] == '0') { // sanitize the shortcode if (preg_match('/^[A-Za-z0-9_-]*$/', $edit_fild)) { $alloweded2 = $wpdb->get_row("SELECT * FROM `create_shortcode` WHERE `shortcode`='$edit_fild'"); $new_data = json_decode("$alloweded2->select_field", true); $key = array_search($add, $new_data); $unsetproduct = $key; unset($new_data[$unsetproduct]); $newdata = json_encode($new_data); $wpdb->update('create_shortcode', array('select_field' => $newdata), array('shortcode' => $edit_fild), array('%s'), array('%s')); } } $config_widget_field['widgetfieldlist'] = $new_data; } } if ($_POST['direction'] == 'down') { $j = 1; for ($i = 0; $i < count($allowedFields); $i++) { $field = $allowedFields[$i]->fieldid; $seq = $j; $query1 = $vtdb->query("UPDATE `vtiger_field` SET `sequence`='$seq' WHERE `fieldid`='$field'"); $j++; } $movedown = $_POST['shortcode1']; $sequence1 = $_POST['position']; $sequence2 = $_POST['position'] + 1; if ($allowedFields) { $seq1 = $allowedFields[$sequence1]->sequence; $seq2 = $allowedFields[$sequence1]->sequence + 1; $field1 = $allowedFields[$sequence1]->fieldid; $field2 = $allowedFields[$sequence2]->fieldid; } if ($field1) { $query1 = $vtdb->query("UPDATE `vtiger_field` SET `sequence`='$seq2' WHERE `fieldid`='$field1'"); } if ($field2) { $query2 = $vtdb->query("UPDATE `vtiger_field` SET `sequence`='$seq1' WHERE `fieldid`='$field2'"); } } if ($_POST['direction'] == 'up') { if ($allowedFields) { $j = 1; for ($i = 0; $i < count($allowedFields); $i++) { $field = $allowedFields[$i]->fieldid; $seq = $j; $query1 = $vtdb->query("UPDATE vtiger_field SET `sequence`='$seq' WHERE `fieldid`='$field'"); $j++; } } $movedown = $_POST['shortcode1']; $sequence1 = $_POST['position']; $sequence2 = $_POST['position'] - 1; if ($allowedFields) { $seq1 = $allowedFields[$sequence1]->sequence; $seq2 = $allowedFields[$sequence1]->sequence - 1; $field1 = $allowedFields[$sequence1]->fieldid; $field2 = $allowedFields[$sequence2]->fieldid; } $chandeid = $_POST['option']; $allowedFields1 = $vtdb->get_results("SELECT * FROM `vtiger_field` WHERE `fieldid`='$moveid'"); if ($field1) { $query1 = $vtdb->query("UPDATE `vtiger_field` SET `sequence`='$seq2' WHERE `fieldid`='$field1'"); } if ($field2) { $query2 = $vtdb->query("UPDATE `vtiger_field` SET `sequence`='$seq1' WHERE `fieldid`='$field2'"); } } if (!empty($allowedFields)) { global $wpdb; if (isset($_POST['create_shortcode']) && $_POST['create_shortcode'] == 'Generate Shortcode') { echo "
"; foreach ($_POST as $key => $value) { //empty the value if sanitize fails $_POST[$key] = sanitize_text_field($value); } $datanew = json_encode($_POST); $shortcode = createRandomPassword(); echo '

[Vts-tiger-New-form name="' . $shortcode . '"]

'; if ($datanew) { $wpdb->insert('create_shortcode', array('shortcode' => $shortcode, 'data' => $datanew, 'assign' => $_POST['assigned']), array('%s', '%s')); } } if (isset($_POST['Submit']) && $_POST['Submit'] == 'Save Field Settings') { ?> '; } else { $widgetContent .= ''; } $typeofdata = explode('~', $field->typeofdata); $widgetContent .= ''; $inc++; } $widgetContent .= '
Field Name
Show Field
Order
Mandatory Fields
Field Label Display
'; $nooffields = count($allowedFields); $inc = 1; foreach ($allowedFields as $key => $field) { if ($inc % 2 == 1) { $widgetContent .= '
'; if ($typeofdata[1] == 'M') { $checked = ''; } else { $checked = ""; } if ($typeofdata[1] == 'M') { $widgetContent .= ' '; } else { $widgetContent .= ''; } $widgetContent .= ' ' . $field->fieldlabel; if ($typeofdata[1] == 'M') { $widgetContent .= ' *'; } $widgetContent .= ' '; if (in_array($field->fieldid, $config_widget_field['widgetfieldlist'])) { if ($typeofdata[1] == 'M') { $widgetContent .= ''; } else { $widgetContent .= ''; } } else { $widgetContent .= ''; } $widgetContent .= ' '; if ($inc == 1) { $widgetContent .= ' '; } elseif ($inc == $nooffields) { $widgetContent .= ' '; } else { $widgetContent .= ' '; } $widgetContent .= '
'; echo $widgetContent; } else { $widgetContent = "
Please enter a valid database settings
"; echo $widgetContent; } } add_action('wp_ajax_adminActions', 'vtst_adminActions'); function vtst_captureWpUsers() { $config = get_option('Vts_vtpl_settings'); if (!empty($config['hostname']) && !empty($config['dbuser'])) { $vtdb = new wpdb($config['dbuser'], $config['dbpass'], $config['dbname'], $config['hostname']); $Contactuser = $vtdb->get_results("SELECT firstname,email FROM vtiger_contactdetails"); $wpcantactuser = new WP_User_Query(array('role' => '', 'user_email' => '')); $wpuserdata = array(); foreach ($wpcantactuser->results as $key => $wpuserget) { $newarray = array( "firstname" => $wpuserget->data->user_login, "email" => $wpuserget->data->user_email, ); array_push($wpuserdata, (object) $newarray); } for ($i = 0; $i < count($Contactuser); $i++) { $user_id = username_exists($Contactuser[$i]->firstname); if (!$user_id and email_exists($Contactuser[$i]->email) == false) { $random_password = wp_generate_password($length = 12, $include_standard_special_chars = false); $user_id = wp_create_user($Contactuser[$i]->firstname, $random_password, $Contactuser[$i]->email); } else { $random_password = __('User already exists. Password inherited.'); } } } else { echo "Conection Failed"; } } add_action('wp_ajax_captureWpUsers', 'vtst_captureWpUsers'); function vtst_getCrmFields() { global $plugin_url_vtlc; $config = get_option('Vts_vtpl_settings'); //$topContent = $this->topContent(); $imagepath = "{$plugin_url_vtlc}/images/"; $vtdb = new wpdb($config['dbuser'], $config['dbpass'], $config['dbname'], $config['hostname']); if ($_POST['module'] == 'widget') { $config_widget_field = get_option("Vts_vtlc_widget_field_settings"); $modeled = 'widget'; if (!empty($config['hostname']) && !empty($config['dbuser'])) { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,block FROM vtiger_field WHERE tabid = 4 ORDER BY block, sequence"); if (!is_array($config_widget_field['widgetfieldlist'])) { $config_widget_field['widgetfieldlist'] = array(); } } } if ($_POST['module'] == 'lead') { $config_widget_field = get_option("Vts_vtpl_field_settings"); $config_widget_field['widgetfieldlist'] = $config_widget_field['fieldlist']; $modeled = 'lead'; if (!empty($config['hostname']) && !empty($config['dbuser'])) { $allowedFields = $vtdb->get_results("SELECT fieldid, fieldname, fieldlabel, typeofdata,block FROM vtiger_field WHERE tabid = 7 ORDER BY block, sequence"); if (!is_array($config_widget_field['widgetfieldlist'])) { $config_widget_field['widgetfieldlist'] = array(); } } } if (!empty($allowedFields)) { global $wpdb; if (isset($_POST['create_shortcode']) && $_POST['create_shortcode'] == 'Generate Shortcode') { echo "
"; foreach ($_POST as $key => $value) { //empty the value if sanitize fails $_POST[$key] = sanitize_text_field($value); } $datanew = json_encode($_POST); $shortcode = createRandomPassword(); echo '

[Vts-tiger-New-form name="' . $shortcode . '"]

'; if ($datanew) { $wpdb->insert('create_shortcode', array('shortcode' => $shortcode, 'data' => $datanew, 'assign' => $_POST['assigned']), array('%s', '%s')); } } if (isset($_POST['Submit']) && $_POST['Submit'] == 'Save Field Settings') { ?> '; } else { $widgetContent .= ''; } $typeofdata = explode('~', $field->typeofdata); $widgetContent .= ''; $inc++; } $widgetContent .= '
Field Name
Show Field
Order
Mandatory Fields
Field Label Display
'; $nooffields = count($allowedFields); $inc = 1; foreach ($allowedFields as $key => $field) { if ($inc % 2 == 1) { $widgetContent .= '
'; if ($typeofdata[1] == 'M') { $checked = ''; } else { $checked = ""; } if ($typeofdata[1] == 'M') { $widgetContent .= ' '; } else { $widgetContent .= ''; } $widgetContent .= ' ' . $field->fieldlabel; if ($typeofdata[1] == 'M') { $widgetContent .= ' *'; } $widgetContent .= ' '; if (in_array($field->fieldid, $config_widget_field['widgetfieldlist'])) { if ($typeofdata[1] == 'M') { $widgetContent .= ''; } else { $widgetContent .= ''; } } else { $widgetContent .= ''; } $widgetContent .= ' '; if ($inc == 1) { $widgetContent .= ' '; } elseif ($inc == $nooffields) { $widgetContent .= ' '; } else { $widgetContent .= ' '; } $widgetContent .= '
'; echo $widgetContent; } else { $widgetContent = "
Please enter a valid database settings
"; echo $widgetContent; } } add_action('wp_ajax_getCrmFields', 'vtst_getCrmFields'); function vtst_recatuerget() { if ($_POST['captueval'] == 'checked') { if (function_exists('gglcptch_display')) { echo "Success"; } else { echo "Please install and Activated Google Captcha (reCAPTCHA) Plugin"; } } } add_action('wp_ajax_recatuerget', 'vtst_recatuerget'); function vtst_update_from_fields() { $config = get_option('Vts_vtpl_settings'); $vtdb = new wpdb($config['dbuser'], $config['dbpass'], $config['dbname'], $config['hostname']); $fields = ($_POST['fields']); //print_r($fields); //$query = $vtdb->query("UPDATE `vtiger_field` SET `typeofdata`='V~O'"); for ($i = 0; $i < sizeof($fields); $i++) { // sanitize the shortcode if (preg_match('/^[A-Za-z0-9_-]*$/', $fields[$i])) { if ($fields[$i] != 0) { //echo "UPDATE `vtiger_field` SET `typeofdata`='V~M' WHERE `fieldid`='$fields[$i]'"; //$query = $vtdb->query("UPDATE `vtiger_field` SET `typeofdata`='V~M' WHERE `fieldid`='$fields[$i]'"); //$query = $vtdb->query("UPDATE `vtiger_field` SET `typeofdata`='V~O' WHERE `fieldid`='65'"); } } // else // { // $query = $vtdb->query("UPDATE `vtiger_field` SET `typeofdata`='V~O' WHERE `fieldid`='$fields[$i]'"); // } } //echo "from function"; } add_action('wp_ajax_update_from_fields', 'vtst_update_from_fields'); function vtst_vtstiger_settings() { $AdminPages = new VTLCWPAdminPages(); $action = vtst_getActionVtsTiger(); ?>
$action();?>