library/DBC_cron.php

   1 <?php
   2 /** DBC DUTCH SYSTEM
   3  *  Cron only functions
   4  *
   5  * @author Cristian NAVALICI (lemonsoftware [..] gmail [.] com)
   6  * @version 1.0
   7  */
   8
   9 require_once('DBC_cfunctions.php');
  10
  11 dc_yearly_closing();
  12
  13 // ----------------------------------------------------------------------------
  14 /**
  15
  16
  17 @param
  18 @return
  19 */
  20 function dc_yearly_closing() {
  21     dc_connect();
  22
  23     // take all opened DBC
  24     $r = mysql_query("SELECT * FROM cl_axes WHERE ax_open = 1");
  25     while ( $row = mysql_fetch_array($r) ) {
  26         // and calculate the age
  27         $age = df_dbc_age($row['ax_id']);
  28         if ( $age >= 365 ) {
  29             $newid = duplicate_dbc($row['ax_id']);
  30             df_cronlog("DBC id: {$row['ax_id']} was duplicated with DBC id: $newid ");
  31         }
  32     }
  33 }
  34
  35 //-----------------------------------------------------------------------------
  36 /**
  37 CONNECT TO DATABASE
  38
  39 make the connections to openemr database
  40 the variables are taken from sqlconf.php
  41
  42 @param none
  43 @return void
  44 */
  45 function dc_connect() {
  46     require_once(dirname(__FILE__) . '/sqlconf.php');
  47     global $host, $login, $pass, $dbase;
  48
  49     $link = mysql_connect($host, $login, $pass);
  50     if (!$link) {
  51         die('Could not connect: ' . mysql_error());
  52     }
  53
  54     mysql_query("USE " . $dbase);
  55 }
  56 ?>