interface/batchcom/settingsnotification.php

   1 <?php
   2 //INCLUDES, DO ANY ACTIONS, THEN GET OUR DATA
   3 include_once("../globals.php");
   4 include_once("$srcdir/registry.inc");
   5 include_once("../../library/acl.inc");
   6 include_once("batchcom.inc.php");
   7
   8 // gacl control
   9 $thisauth = acl_check('admin', 'notification');
  10
  11 if (!$thisauth) {
  12   echo "<html>\n<body>\n";
  13   echo "<p>".xl('You are not authorized for this.','','','</p>')."\n";
  14   echo "</body>\n</html>\n";
  15   exit();
  16  }
  17
  18  $type = 'SMS/Email Settings';
  19 // process form
  20 if ($_POST['form_action']=='Save')
  21 {
  22     if ($_POST['Send_SMS_Before_Hours']=="") $form_err.=xl('Empty value in "SMS Hours"','','<br>');
  23     if ($_POST['Send_Email_Before_Hours']=="") $form_err.=xl('Empty value in "Email Hours"','','<br>');
  24     if ($_POST['SMS_gateway_username']=="") $form_err.=xl('Empty value in "Username"','','<br>');
  25     if ($_POST['SMS_gateway_password']=="") $form_err.=xl('Empty value in "Password"','','<br>');
  26     //process sql
  27     if (!$form_err)
  28     {
  29         $sql_text=" ( `SettingsId` , `Send_SMS_Before_Hours` , `Send_Email_Before_Hours` , `SMS_gateway_password` , `SMS_gateway_apikey` , `SMS_gateway_username` , `type` ) ";
  30         $sql_value=" ( '".$_POST[SettingsId]."' , '".$_POST[Send_SMS_Before_Hours]."' , '".$_POST[Send_Email_Before_Hours]."' , '".$_POST[SMS_gateway_password]."' , '".$_POST[SMS_gateway_apikey]."' , '".$_POST[SMS_gateway_username]."' , '".$type."' ) ";
  31         $query = "REPLACE INTO `notification_settings` $sql_text VALUES $sql_value";
  32         //echo $query;
  33         $id = sqlInsert($query);
  34         $sql_msg="ERROR!... in Update";
  35         if($id)    $sql_msg="SMS/Email Alert Settings Updated Successfully";
  36     }
  37 }
  38
  39 // fetch data from table
  40 $sql="select * from notification_settings where type='$type'";
  41 $result = sqlQuery($sql);
  42 if($result)
  43 {
  44     $SettingsId = $result[SettingsId];
  45     $Send_SMS_Before_Hours = $result[Send_SMS_Before_Hours];
  46     $Send_Email_Before_Hours = $result[Send_Email_Before_Hours];
  47     $SMS_gateway_password=$result[SMS_gateway_password];
  48     $SMS_gateway_username=$result[SMS_gateway_username];
  49     $SMS_gateway_apikey=$result[SMS_gateway_apikey];
  50 }
  51 //my_print_r($result);
  52 //START OUT OUR PAGE....
  53 ?>
  54 <html>
  55 <head>
  56 <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css">
  57 <link rel="stylesheet" href="batchcom.css" type="text/css">
  58
  59
  60 </head>
  61 <body class="body_top">
  62 <span class="title"><?php include_once("batch_navigation.php");?></span>
  63 <span class="title"><?php xl('SMS/Email Alert Settings','e')?></span>
  64 <br><br>
  65 <!-- for the popup date selector -->
  66 <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
  67 <FORM name="select_form" METHOD=POST ACTION="">
  68 <input type="Hidden" name="type" value="<?php echo $type;?>">
  69 <input type="Hidden" name="SettingsId" value="<?php echo $SettingsId;?>">
  70 <div class="text">
  71     <div class="main_box">
  72         <?php
  73         if ($form_err) {
  74             echo ("The following errors occurred<br>$form_err<br><br>");
  75         }
  76         if ($sql_msg) {
  77             echo ("$sql_msg<br><br>");
  78         }
  79         ?>
  80         <?php xl('SMS send before','e')?> :
  81         <INPUT TYPE="text" NAME="Send_SMS_Before_Hours" size="10" maxlength="3" value="<?php echo $Send_SMS_Before_Hours?>"> <strong>Hrs.</strong>
  82         <br>
  83         <?php xl('Email send before','e')?> :
  84         <INPUT TYPE="text" NAME="Send_Email_Before_Hours" size="10" maxlength="3" value="<?php echo $Send_Email_Before_Hours?>"> <strong>Hrs.</strong>
  85         <br>
  86         <?php xl('Username for SMS Gateway','e')?> :
  87         <INPUT TYPE="password" NAME="SMS_gateway_username" size="40" value="<?php $SMS_gateway_username?>">
  88         <br>
  89         <?php xl('Password for SMS Gateway','e')?> :
  90         <INPUT TYPE="password" NAME="SMS_gateway_password" size="40" value="<?php $SMS_gateway_password?>">
  91         <br>
  92         <?php xl('SMS Gateway API key','e')?> :
  93         <INPUT TYPE="text" NAME="SMS_gateway_apikey" size="40" value="<?php $SMS_gateway_apikey?>">
  94
  95         <br><br>
  96         <INPUT TYPE="submit" name="form_action" value="Save">
  97     </div>
  98 </div>
  99 </FORM>