| | |
| | | |
| | | //* Send message |
| | | if($error == '') { |
| | | if(intval($_POST['recipient']) > 0){ |
| | | $circle = $app->db->queryOneRecord("SELECT client_ids FROM client_circle WHERE active = 'y' AND circle_id = ".intval($_POST['recipient'])." AND ".$app->tform->getAuthSQL('r')); |
| | | if($app->functions->intval($_POST['recipient']) > 0){ |
| | | $circle = $app->db->queryOneRecord("SELECT client_ids FROM client_circle WHERE active = 'y' AND circle_id = ".$app->functions->intval($_POST['recipient'])." AND ".$app->tform->getAuthSQL('r')); |
| | | if(isset($circle['client_ids']) && $circle['client_ids'] != ''){ |
| | | $tmp_client_ids = explode(',',$circle['client_ids']); |
| | | $where = array(); |
| | |
| | | if($_SESSION["s"]["user"]["typ"] == 'admin'){ |
| | | $sql = "SELECT * FROM client WHERE email != ''"; |
| | | } else { |
| | | $client_id = intval($_SESSION['s']['user']['client_id']); |
| | | $client_id = $app->functions->intval($_SESSION['s']['user']['client_id']); |
| | | if($client_id == 0) die('Invalid Client ID.'); |
| | | $sql = "SELECT * FROM client WHERE email != '' AND parent_client_id = '$client_id'"; |
| | | } |
| | |
| | | //* Parse client details into message |
| | | $message = $_POST['message']; |
| | | foreach($client as $key => $val) { |
| | | if($key != 'password'){ |
| | | $message = str_replace('{'.$key.'}', $val, $message); |
| | | } else { |
| | | $message = str_replace('{'.$key.'}', '---', $message); |
| | | switch ($key) { |
| | | case 'password': |
| | | $message = str_replace('{'.$key.'}', '---', $message); |
| | | break; |
| | | case 'gender': |
| | | $message = str_replace('{salutation}', $wb['gender_'.$val.'_txt'], $message); |
| | | break; |
| | | default: |
| | | $message = str_replace('{'.$key.'}', $val, $message); |
| | | } |
| | | } |
| | | |
| | |
| | | } else { |
| | | // pre-fill Sender field with reseller's email address |
| | | if($_SESSION["s"]["user"]["typ"] != 'admin'){ |
| | | $client_id = intval($_SESSION['s']['user']['client_id']); |
| | | $client_id = $app->functions->intval($_SESSION['s']['user']['client_id']); |
| | | if($client_id > 0){ |
| | | $sql = "SELECT email FROM client WHERE client_id = ".$client_id; |
| | | $client = $app->db->queryOneRecord($sql); |
| | |
| | | } |
| | | |
| | | // Recipient Drop-Down |
| | | $recipient = '<option value="0"'.(intval($_POST['recipient']) == 0 ? ' selected="selected"' : '').'>'.($_SESSION["s"]["user"]["typ"] == 'admin'? $wb['all_clients_resellers_txt'] : $wb['all_clients_txt']).'</option>'; |
| | | $recipient = '<option value="0"'.($app->functions->intval($_POST['recipient']) == 0 ? ' selected="selected"' : '').'>'.($_SESSION["s"]["user"]["typ"] == 'admin'? $wb['all_clients_resellers_txt'] : $wb['all_clients_txt']).'</option>'; |
| | | $sql = "SELECT * FROM client_circle WHERE active = 'y' AND ".$app->tform->getAuthSQL('r'); |
| | | $circles = $app->db->queryAllRecords($sql); |
| | | if(is_array($circles) && !empty($circles)){ |
| | | foreach($circles as $circle){ |
| | | $recipient .= '<option value="'.$circle['circle_id'].'"'.(intval($_POST['recipient']) == $circle['circle_id'] ? ' selected="selected"' : '').'>'.$circle['circle_name'].'</option>'; |
| | | $recipient .= '<option value="'.$circle['circle_id'].'"'.($app->functions->intval($_POST['recipient']) == $circle['circle_id'] ? ' selected="selected"' : '').'>'.$circle['circle_name'].'</option>'; |
| | | } |
| | | } |
| | | $app->tpl->setVar('recipient',$recipient); |
| | |
| | | $field_names = $app->db->queryAllRecords($sql); |
| | | if(!empty($field_names) && is_array($field_names)){ |
| | | foreach($field_names as $field_name){ |
| | | if($field_name['Field'] != '') $message_variables .= '<a href="javascript:void(0);" class="addPlaceholder">{'.$field_name['Field'].'}</a> '; |
| | | if($field_name['Field'] != ''){ |
| | | if($field_name['Field'] == 'gender'){ |
| | | $message_variables .= '<a href="javascript:void(0);" class="addPlaceholder">{salutation}</a> '; |
| | | } else { |
| | | $message_variables .= '<a href="javascript:void(0);" class="addPlaceholder">{'.$field_name['Field'].'}</a> '; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | $app->tpl->setVar('message_variables',trim($message_variables)); |