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 <script type="text/javascript" src="../../library/overlib_mini.js"></script>
  59 <script type="text/javascript" src="../../library/calendar.js"></script>
  60
  61
  62 </head>
  63 <body class="body_top">
  64 <span class="title"><?php include_once("batch_navigation.php");?></span>
  65 <span class="title"><?php xl('SMS/Email Alert Settings','e')?></span>
  66 <br><br>
  67 <!-- for the popup date selector -->
  68 <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
  69 <FORM name="select_form" METHOD=POST ACTION="">
  70 <input type="Hidden" name="type" value="<?php echo $type;?>">
  71 <input type="Hidden" name="SettingsId" value="<?php echo $SettingsId;?>">
  72 <div class="text">
  73     <div class="main_box">
  74         <?php
  75         if ($form_err) {
  76             echo ("The following errors occurred<br>$form_err<br><br>");
  77         }
  78         if ($sql_msg) {
  79             echo ("$sql_msg<br><br>");
  80         }
  81         ?>
  82         <?php xl('SMS send before','e')?> :
  83         <INPUT TYPE="text" NAME="Send_SMS_Before_Hours" size="10" maxlength="3" value="<?php echo $Send_SMS_Before_Hours?>"> <strong>Hrs.</strong>
  84         <br>
  85         <?php xl('Email send before','e')?> :
  86         <INPUT TYPE="text" NAME="Send_Email_Before_Hours" size="10" maxlength="3" value="<?php echo $Send_Email_Before_Hours?>"> <strong>Hrs.</strong>
  87         <br>
  88         <?php xl('Username for SMS Gateway','e')?> :
  89         <INPUT TYPE="password" NAME="SMS_gateway_username" size="40" value="<?php $SMS_gateway_username?>">
  90         <br>
  91         <?php xl('Password for SMS Gateway','e')?> :
  92         <INPUT TYPE="password" NAME="SMS_gateway_password" size="40" value="<?php $SMS_gateway_password?>">
  93         <br>
  94         <?php xl('SMS Gateway API key','e')?> :
  95         <INPUT TYPE="text" NAME="SMS_gateway_apikey" size="40" value="<?php $SMS_gateway_apikey?>">
  96
  97         <br><br>
  98         <INPUT TYPE="submit" name="form_action" value="Save">
  99     </div>
 100 </div>
 101 </FORM>