root/contributed_modules/modules/bosssecretary/functions.inc.php

<?php


/********************************************************
*                           *
*           API FUNCTIONS           *
*                           *
********************************************************/


define("BOSSSECRETARY_PARAM_PREFIX", "bsgroup-");
define("BOSSSECRETARY_LABEL_DEFAULT", "Group ");
define("BOSSSECRETARY_CONTEXT", "ext-bosssecretary");
define("BOSSSECRETARY_MACRO_LOCKED", "macro-bosssecretary-locked");
define("BOSSSECRETARY_MACRO_LOCKED_NAME", "bosssecretary-locked");
define("BOSSSECRETARY_TOGGLE", "app-bosssecretary-toggle");
define("BOSSSECRETARY_ON", "app-bosssecretary-on");
define("BOSSSECRETARY_OFF", "app-bosssecretary-off");
define("BOSSSECRETARY_HINTS", "app-bosssecretary-hints");


function bosssecretary_get_config($engine){
  global $db;
  global $ext;
  global $amp_conf;
  global $astman;

  switch($engine) {
    case "asterisk":




      $fcc_toggle = bosssecretary_get_fcc_toggle();
      $fcc_on  = bosssecretary_get_fcc_on();
      $fcc_off  = bosssecretary_get_fcc_off();
      $groups = bosssecretary_get_all_groups();

      $ctx_app_toggle =   BOSSSECRETARY_TOGGLE;
      $ctx_app_on     =   BOSSSECRETARY_ON;
      $ctx_app_off    =   BOSSSECRETARY_OFF;
      $ctx_app_hints  = BOSSSECRETARY_HINTS;
      $ctx_bsc    = BOSSSECRETARY_CONTEXT;

      $ext->addInclude('from-internal-additional', $ctx_bsc);
      $ext->addInclude($ctx_bsc, $ctx_app_toggle);
      $ext->addInclude($ctx_bsc, $ctx_app_on);
      $ext->addInclude($ctx_bsc, $ctx_app_off);
      $ext->addInclude($ctx_bsc, $ctx_app_hints);

      if (!empty($groups))
      {

        $astman->database_deltree("bosssecretary/group");
        $groups = bosssecretary_to_group($groups);



        foreach ($groups as $group)
        {
          $id_group = $group["id_group"];

          foreach ($group["bosses"] as $extension)
          {
            $astman->database_put("bosssecretary","group/$id_group/member/$extension", "boss");
            $astman->database_put("bosssecretary","group/member/$extension", $id_group);
          }
          foreach ($group["secretaries"] as $extension)
          {
            $astman->database_put("bosssecretary","group/$id_group/member/$extension", "secretary");
            $astman->database_put("bosssecretary","group/member/$extension", $id_group);
          }
          foreach ($group["chiefs"] as $extension)
          {
            $astman->database_put("bosssecretary","group/$id_group/member/$extension", "chief");
          }
        }
        // :::: BSC Off [app-bosssecretary-on] ::::

        $ext->add($ctx_app_on, $fcc_on, '', new ext_noop("Bosssecretary on starts..."));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_answer());
        $ext->add($ctx_app_on, $fcc_on, '', new ext_macro ('user-callerid'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_wait ('2'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/member/${AMPUSER})}','on','exit'));
        $ext->add($ctx_app_on, $fcc_on, 'on', new ext_setvar('GROUP','${DB(bosssecretary/group/member/${AMPUSER})}'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_dbdel('bosssecretary/group/${GROUP}/locked'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_setvar('STATE','NOT_INUSE'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_gosub('1','sstate',$ctx_app_on));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_playback('activated'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_hangup());
        $ext->add($ctx_app_on, $fcc_on, 'exit', new ext_noop('${AMPUSER} doesn\\\'t belongs bosssecretary group'));
        $ext->add($ctx_app_on, $fcc_on, '', new ext_hangup());
        $ext->add($ctx_app_on, 'sstate', '', new ext_setvar('DEVSTATE(Custom:BSC${GROUP})','${STATE}'));
        $ext->add($ctx_app_on, 'sstate', 'return', new ext_return());


        // :::: BSC Off [app-bosssecretary-off] ::::
        $ext->add($ctx_app_off, $fcc_off, '', new ext_noop("Bosssecretary off starts..."));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_answer());
        $ext->add($ctx_app_off, $fcc_off, '', new ext_macro ('user-callerid'));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_wait ('2'));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/member/${AMPUSER})}','off','exit'));
        $ext->add($ctx_app_off, $fcc_off, 'off', new ext_setvar('GROUP','${DB(bosssecretary/group/member/${AMPUSER})}'));
        $ext->add($ctx_app_off, $fcc_off, "", new ext_setvar('DB(bosssecretary/group/${GROUP}/locked)',"1"));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_setvar('STATE','BUSY'));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_gosub('1','sstate',$ctx_app_off));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_playback('de-activated'));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_hangup());
        $ext->add($ctx_app_off, $fcc_off, 'exit', new ext_noop('${AMPUSER} doesn\\\'t belongs bosssecretary group'));
        $ext->add($ctx_app_off, $fcc_off, '', new ext_hangup());
        $ext->add($ctx_app_off, 'sstate', '', new ext_setvar('DEVSTATE(Custom:BSC${GROUP})','${STATE}'));
        $ext->add($ctx_app_off, 'sstate', 'return', new ext_return());

        // :::: BSC Toggle [app-bosssecretary-toggle] ::::
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_noop("Bosssecretary toggle starts..."));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_answer());
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_macro ('user-callerid'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_wait ('2'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/member/${AMPUSER})}','check','exit' ));
        $ext->add($ctx_app_toggle, $fcc_toggle, 'check', new ext_setvar('GROUP','${DB(bosssecretary/group/member/${AMPUSER})}'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/${GROUP}/locked)}','unlock', 'lock'));
        $ext->add($ctx_app_toggle, $fcc_toggle, "lock", new ext_setvar('DB(bosssecretary/group/${GROUP}/locked)',"1"));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_setvar('STATE','BUSY'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_gosub('1','sstate',$ctx_app_toggle));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_playback('de-activated'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_hangup());
        $ext->add($ctx_app_toggle, $fcc_toggle, 'unlock', new ext_dbdel('bosssecretary/group/${GROUP}/locked'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_setvar('STATE','NOT_INUSE'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_gosub('1','sstate',$ctx_app_toggle));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_playback('activated'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_hangup());
        $ext->add($ctx_app_toggle, $fcc_toggle, 'exit', new ext_noop('${AMPUSER} doesn\\\'t belongs bosssecretary group'));
        $ext->add($ctx_app_toggle, $fcc_toggle, '', new ext_hangup());
        $ext->add($ctx_app_toggle, 'sstate', '', new ext_setvar('DEVSTATE(Custom:BSC${GROUP})','${STATE}'));
        $ext->add($ctx_app_toggle, 'sstate', 'return', new ext_return());

        // :::: BSC Hints [app-bosssecretary-hints] ::::
        foreach ($groups as $group)
        {

          $id_group = $group["id_group"];
          foreach ($group["bosses"] as $extension)
          {
            $hint = "Custom:BSC$id_group";
            $ext_subscribed = $fcc_toggle . $extension;
            $ext->add($ctx_app_hints, $ext_subscribed, '', new ext_goto(1, $fcc_toggle, $ctx_app_toggle));
            $ext->addHint($ctx_app_hints, $ext_subscribed, $hint);

          }
          foreach ($group["secretaries"] as $extension)
          {
            $hint = "Custom:BSC$id_group";
            $ext_subscribed = $fcc_toggle . $extension;
            $ext->add($ctx_app_hints, $ext_subscribed, '', new ext_goto(1, $fcc_toggle, $ctx_app_toggle));
            $ext->addHint($ctx_app_hints, $ext_subscribed, $hint);
          }

        }

        // :::: BSC Context [ext-bosssecretary] ::::
        foreach ($groups as $group)
        {
          $AllExtensions = array_merge($group["bosses"], $group["secretaries"]);
          $id_group = $group["id_group"];

          foreach ($group["bosses"] as $extension)
          {
            $ext->add($ctx_bsc, $extension, '', new ext_noop("Bosssecretary: Checking  lock for $extension extension"));
            $ext->add($ctx_bsc, $extension, '', new ext_macro ('user-callerid'));
            $ext->add($ctx_bsc, $extension, '', new ext_setvar('CALLER','${CALLERID(num)}'));
            $ext->add($ctx_bsc, $extension, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/'.$id_group.'/member/${CALLER})}','exit_module'));
            $ext->add($ctx_bsc, $extension, '', new ext_gotoif('${DB_EXISTS(bosssecretary/group/'.$id_group.'/locked)}','exit_module','run_module'));
            $ext->add($ctx_bsc, $extension, 'run_module', new ext_noop("Bosssecretary: Executing module"));
            $ext->add($ctx_bsc, $extension, '', new ext_sipaddheader("Alert-Info", "<http://nohost>\;info=alert-group\;x-line-id=0"));
            $extensions = array();
            foreach ($group["secretaries"] as $sip_extension)
            {
              $extensions[] = "$sip_extension";
            }
            $extensions[] = "$extension";
            /*
            exten => 105,n,Dial(SIP/108&SIP/105,)
            exten => 105,n,Macro(dial,20,${DIAL_OPTIONS},108-105)
            */
            $args = '${RINGTIMER},${DIAL_OPTIONS},' . implode ("-", $extensions);
            $ext->add($ctx_bsc, $extension, '', new ext_macro ("dial", $args));
            $ext->add($ctx_bsc, $extension, 'exit_module', new ext_noop("Bosssecretary: Exit") );
            $ext->add($ctx_bsc, $extension, '', new ext_goto(1, $extension, "ext-local") );
            $extensions = "";
          }
        }
      }

      break;
  }

}


/********************************************************
*                           *
*           DATABASE FUNCTIONS          *
*                           *
********************************************************/

function bosssecretary_get_groups()
{
  global $db;
  $sql = "SELECT * from bosssecretary_group";
  $results = $db->getAll($sql);
  if(DB::IsError($results)) {
    $results = null;
  }
  return $results;
}


function bosssecretary_get_fcc_toggle()
{
  $fcc = new featurecode('bosssecretary', 'bsc_toggle');
  $extLock = $fcc->getCodeActive();
  unset($fcc);
  return $extLock;
}

function bosssecretary_get_fcc_on()
{
  $fcc = new featurecode('bosssecretary', 'bsc_on');
  $extLock = $fcc->getCodeActive();
  unset($fcc);
  return $extLock;
}

function bosssecretary_get_fcc_off()
{
  $fcc = new featurecode('bosssecretary', 'bsc_off');
  $extLock = $fcc->getCodeActive();
  unset($fcc);
  return $extLock;
}



function bosssecretary_to_group($groups)
{
  $newGroup = array();
  foreach ($groups as $group)
  {
    if (!isset($newGroup[$group["id_group"]]))
    {
      $newGroup[$group["id_group"]] =  $group;
      $newGroup[$group["id_group"]]["bosses"] = array();
      // isset is so much faster than in_array ;)
      $newGroup[$group["id_group"]]["bosses"][$group["boss_extension"]] = $group["boss_extension"];

      $newGroup[$group["id_group"]]["secretaries"] = array();
      // isset is so much faster than in_array ;)
      $newGroup[$group["id_group"]]["secretaries"][$group["secretary_extension"]] = $group["secretary_extension"];

      if (isset($group["chief_extension"]))
      {
        $newGroup[$group["id_group"]]["chiefs"] = array();
        $newGroup[$group["id_group"]]["chiefs"][$group["chief_extension"]] = $group["chief_extension"];
      }
    }
    else
    {
      // isset is so much faster than in_array ;)
      if (!isset($newGroup[$group["id_group"]]["bosses"][$group["boss_extension"]]))
      {
        $newGroup[$group["id_group"]]["bosses"][$group["boss_extension"]] = $group["boss_extension"];
      }
      // isset is so much faster than in_array ;)
      if (!isset($newGroup[$group["id_group"]]["secretaries"][$group["secretary_extension"]]))
      {
        $newGroup[$group["id_group"]]["secretaries"][$group["secretary_extension"]] = $group["secretary_extension"];
      }
      if (!isset($newGroup[$group["id_group"]]["chiefs"][$group["chief_extension"]]))
      {
        $newGroup[$group["id_group"]]["chiefs"][$group["chief_extension"]] = $group["chief_extension"];
      }
    }
  }
  return $newGroup;
}

function bosssecretary_search($extensions)
{
  global $db;
  $extensions = explode(",", $extensions);
  foreach ($extensions as $extension)
  {
    if (is_numeric($extension))
    {
      $valid[]= trim($extension);
    }

  }
  if (!empty($valid))
  {
    $extensions = implode(",", $valid);
    $sql = "SELECT boss_extension AS extension, 'boss' as `type`, g.* FROM bosssecretary_group as g INNER JOIN bosssecretary_boss as b ON b.id_group = g.id_group  WHERE boss_extension IN ($extensions)
      UNION 
      SELECT secretary_extension AS extension, 'secretary' as `type`, g.* FROM bosssecretary_group as g INNER JOIN bosssecretary_secretary as s ON s.id_group = g.id_group  WHERE secretary_extension IN ($extensions)
      UNION
      SELECT chief_extension AS extension, 'chief' as `type`, g.* FROM bosssecretary_group as g INNER JOIN bosssecretary_chief as c ON c.id_group = g.id_group  WHERE chief_extension IN ($extensions)
";
    //echo $sql . "<br>";

    $results = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
    if(DB::IsError($results)) {
      $results = null;
    }
    return $results;
  }
  return null;

}


function bosssecretary_get_all_groups()
{
  global $db;
  $sql = "SELECT
      g.id_group, 
      boss_extension, 
      secretary_extension,
      chief_extension  
    FROM bosssecretary_group AS g  
    INNER JOIN bosssecretary_boss AS b ON g.id_group = b.id_group 
    INNER JOIN bosssecretary_secretary AS s ON g.id_group = s.id_group
    LEFT JOIN bosssecretary_chief AS c ON g.id_group = c.id_group
;";
  $results = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
  if(DB::IsError($results)) {
    $results = null;
  }
  return $results;
}

function bosssecretary_array_diff_with_db(array $exts, $group_number)
{
  global $db;


  if (!empty($exts))
  {
    if (bosssecretary_group_exists($group_number))
    {
      $sqlB = "AND id_group <> '" . $db->escapeSimple($group_number) . "'";
      $sqlS = "AND id_group <> '" . $db->escapeSimple($group_number) . "'";
    }
    else
    {
      $sqlB = $sqlS = "";
    }
    $exts = array_unique($exts);
    $strExts = bosssecretary_array_to_mysql_param_in($exts);

    $sql = "SELECT `boss_extension` AS `extension` FROM `bosssecretary_boss` WHERE boss_extension IN ($strExts) $sqlB
        UNION
        SELECT `secretary_extension` AS `extension` FROM `bosssecretary_secretary` WHERE secretary_extension IN ($strExts) $sqlS";

    $results = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
    if(DB::IsError($results))
    {
      $results = null;
    }
    else
    {
      foreach ($results as $record)
      {
        if (($key = array_search($record['extension'], $exts)) !== FALSE)
        {
          unset($exts[$key]);
        }
      }
      $strExts = bosssecretary_array_to_mysql_param_in($exts);
      $sql = "SELECT extension FROM `users` WHERE extension IN ($strExts)";
      $results = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
      if(DB::IsError($results))
      {
        $results = null;
      }
      else
      {
        $exts = array();
        foreach ($results as $record)
        {
          array_push($exts, current($record));
        }
      }

    }
  }
  return $exts;
}




function bosssecretary_clean_remove_duplicates( $bosses, $secretaries , $group_number = "")
{
  // Extraigo las extensiones de jefes del formulario
  $arr_bosses_extensions = bosssecretary_str_extensions_to_array($bosses);

  // Extraigo las extensiones de secretaria del formulario
  $arr_secretaries_extensions = bosssecretary_str_extensions_to_array($secretaries);

  // Quito de las extensiones de secretarias las extensiones que estan en los jefes
  $arr_secretaries_extensions = bosssecretary_array_diff($arr_secretaries_extensions, $arr_bosses_extensions);


  $extensionsCleaned = array();
  // Ahora quito de las extensiones de secretarias las extensiones que ya son jefes o secretarias segun la BD
  $extensionsCleaned["secretaries"] = bosssecretary_array_diff_with_db($arr_secretaries_extensions, $group_number);

  // Ahora quito de las extensiones de jefes las extensiones que ya son jefes o secretarias segun la BD
  $extensionsCleaned["bosses"] = bosssecretary_array_diff_with_db($arr_bosses_extensions, $group_number);
  return $extensionsCleaned;
}

function bosssecretary_get_group_number_free()
{
  global $db;
  $sql = "SELECT MIN(group_number) AS Bottom FROM bosssecretary_group_numbers_free ORDER BY group_number ASC LIMIT 1";
  $result = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
  if(DB::IsError($result)) {
    $result = null;
  }
  if (!isset($result[0]["Bottom"]))
  {
    $sql = "SELECT MAX(id_group) AS Top FROM bosssecretary_group";
    $result = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
    if(DB::IsError($result)) {
      $result = null;
    }
    if (!isset($result[0]["Top"]))
    {
      $next = 1;
    }
    else
    {
      $next = $result[0]["Top"] + 1;
    }
  }
  else
  {
    $next = $result[0]["Bottom"];
  }
  return $next;
}


function bosssecretary_set_group_number_free($number)
{
  global $db;
  $sql = "INSERT INTO bosssecretary_group_numbers_free VALUES ('$number')";
  //$result = $db->getAll($sql);
  return sql($sql);
}

function bosssecretary_remove_group_number_free($number)
{
  global $db;
  $sql = "DELETE FROM bosssecretary_group_numbers_free WHERE _rowid NOT IN (SELECT _rowid FROM bosssecretary_group) AND _rowid > (SELECT MAX(_rowid) FROM bosssecretary_group)";
  sql($sql);
  $sql = "DELETE FROM bosssecretary_group_numbers_free WHERE _rowid = '$number'";
  return sql($sql);
}



function bosssecretary_group_add ( $group_number, $group_label,  array $bosses, array $secretaries, $chiefs)
{
  global $db;
  $errors= array();
  if (is_numeric($group_number) or $group_number =="")
  {
    if (!bosssecretary_group_exists($group_number))
    {
      if (empty($bosses))
      {
        array_push($errors, "You must put one boss extension at least");
      }
      if (empty($secretaries))
      {
        array_push($errors, "You must put one secretary extension at least");
      }


      if (empty($errors))
      {
        $sql = "INSERT INTO bosssecretary_group (`id_group`, `label`) VALUES('".$db->escapeSimple($group_number)."', '".$db->escapeSimple($group_label)."')";
        sql($sql);
        //$group_number = mysql_insert_id();
        bosssecretary_remove_group_number_free($group_number);

        foreach ($bosses as $boss)
        {
          $boss = trim($boss);
          if (!empty($boss) and !(bosssecretary_extension_in_bosses_group($boss)))
          {
            $sql = "INSERT INTO bosssecretary_boss VALUES ('$group_number', '$boss')";
            sql($sql);
          }
          else
          {
            array_push($errors, "($boss) Extension exists already in another group like boss");
          }
        }
        foreach ($secretaries as $secretary)
        {
          $secretary = trim($secretary);
          if (!empty($secretary) and !(bosssecretary_extension_in_secretaries_group($secretary)))
          {
            $sql = "INSERT INTO bosssecretary_secretary VALUES ('$group_number', '$secretary')";
            sql($sql);
          }
          else
          {
            array_push($errors, "($secretary) Extension exists already in another group like secretary");
          }

        }
        if (is_array($chiefs))
        {
          foreach ($chiefs as $chief)
          {
            $chief = trim($chief);
            if (!empty($chief))
            {
              $sql = "INSERT INTO bosssecretary_chief VALUES ('$group_number', '$chief')";
              sql($sql);
            }
          }
        }
      }
    }
    else
    {
      array_push($errors, 'Group exists already');
    }
  }
  else
  {
    array_push($errors, 'Group number must be a numeric value');
  }
  return $errors;


}


function bosssecretary_group_edit ( $group_number, $group_label,  array $bosses, array $secretaries, array $chiefs)
{
  global $db;
  $errors= array();
  if (is_numeric($group_number))
  {
    if (bosssecretary_group_exists($group_number) )
    {
      if (empty($bosses))
      {
        array_push($errors, "You must put one boss extension at least");
      }
      if (empty($secretaries))
      {
        array_push($errors, "You must put one secretary extension at least");
      }

      if (empty($errors))
      {
        $sql = "DELETE FROM `bosssecretary_group` WHERE id_group = $group_number";
        sql($sql);

        $sql = "DELETE FROM `bosssecretary_boss` WHERE id_group = $group_number";
        sql($sql);

        $sql = "DELETE FROM `bosssecretary_secretary` WHERE id_group = $group_number";
        sql($sql);

        $sql = "DELETE FROM `bosssecretary_chief` WHERE id_group = $group_number";
        sql($sql);

        $sql = "INSERT INTO bosssecretary_group (`id_group`, `label`) VALUES('".$db->escapeSimple($group_number)."', '".$db->escapeSimple($group_label)."')";
        sql($sql);
        foreach ($bosses as $boss)
        {
          $boss = trim($boss);
          if (!empty($boss))
          {
            $sql = "INSERT INTO bosssecretary_boss VALUES ('$group_number', '$boss')";
            sql($sql);
          }
        }
        foreach ($secretaries as $secretary)
        {
          $secretary = trim($secretary);
          if (!empty($secretary))
          {
            $sql = "INSERT INTO bosssecretary_secretary VALUES ('$group_number', '$secretary')";
            sql($sql);
          }
        }

        foreach ($chiefs as $chief)
        {
          $chief = trim($chief);
          if (!empty($chief))
          {
            $sql = "INSERT INTO bosssecretary_chief VALUES ('$group_number', '$chief')";
            sql($sql);
          }
        }

      }
    }
    else
    {
      array_push($errors, "Group doesn't exists");
    }
  }
  else
  {
    array_push($errors, 'Group number must be a value numeric');
  }
  return $errors;


}

function bosssecretary_group_delete($group_number)
{
  global $db;
  $sql = "DELETE FROM `bosssecretary_group` WHERE id_group = '$group_number'";
  $group = sql($sql);


  $sql = "DELETE FROM `bosssecretary_boss` WHERE id_group = '$group_number'";
  $bosses = sql($sql);

  $sql = "DELETE FROM `bosssecretary_secretary` WHERE id_group = '$group_number'";
  $secretaries = sql($sql);

  $sql = "DELETE FROM `bosssecretary_chief` WHERE id_group = '$group_number'";
  $chiefs = sql($sql);

  bosssecretary_set_group_number_free($group_number);
  return (($group === $bosses) and ($group===$secretaries));
}

function bosssecretary_group_exists( $group)
{
  global $db;

  $sql = "SELECT 'true' from bosssecretary_group WHERE id_group='" . $db->escapeSimple($group). "' LIMIT 1";
  $results = $db->getAll($sql);
  if(DB::IsError($results)) {
    $results = null;
  }
  return count($results) == 1;
}





function bosssecretary_extension_in_bosses_group( $ext)
{
  global $db;
  $sql = "SELECT 'true' from bosssecretary_boss WHERE boss_extension='" . $db->escapeSimple($ext) . "' LIMIT 1";
  $results = $db->getAll($sql);
  if(DB::IsError($results)) {
    $results = null;
  }
  return count($results) == 1;
}


function bosssecretary_extension_in_secretaries_group( $ext)
{
  global $db;
  $sql = "SELECT 'true' from bosssecretary_secretary WHERE secretary_extension='" . $db->escapeSimple($ext) . "' LIMIT 1";
  $results = $db->getAll($sql);
  if(DB::IsError($results)) {
    $results = null;
  }
  return count($results) == 1;
}



function bosssecretary_get_data_of_group($group)
{
  global $db;

  // we use LEFT JOIN because at least we wanna to know info group (id_group and label)!
  $sql = "SELECT
      g.id_group, 
      g.label, 
      b.boss_extension, 
      s.secretary_extension,
      c.chief_extension  
    FROM bosssecretary_group AS g 
    LEFT JOIN bosssecretary_boss AS b ON b.id_group = g.id_group 
    LEFT JOIN bosssecretary_secretary AS s ON s.id_group = g.id_group
    LEFT JOIN bosssecretary_chief AS c ON c.id_group = g.id_group
    WHERE g.id_group='" .  $db->escapeSimple($group) . "'";

  $results = $db->getAll($sql, array(), DB_FETCHMODE_ASSOC);
  if(DB::IsError($results)) {
    $results = null;
  }
  return $results;
}



function bosssecretary_get_extension_data($ext){
  global $db;
  $sql = " SELECT extension, name FROM `users` u WHERE extension = '" .  $db->escapeSimple($ext) . "' LIMIT 1;";
  $results = $db->getAll($sql);

  if(DB::IsError($results)) {
    $results = array();
  }
  else{
    $results = current($results);
  }
  return $results;
}

function bosssecretary_extension_exists($ext){
  global $db;
  $sql = "SELECT 'true' FROM `users` WHERE extension = '" . $db->escapeSimple($ext) . "' LIMIT 1";
  $result = $db->getAll($sql);
  return count($result[0]) === 1;
}


/********************************************************
*                           *
*           UTILS FUNCTIONS           *
*                           *
********************************************************/

/*

$haystack = array('a','b','c', 'd');
$needle = array('b','c', 'd','e');

$result = bosssecretary_array_diff($haystack, $needle);

$result is equal to array('a').

Yeah! I know! array_diff is a php function BUT is broken since v4.0.4 and we need it!
http://www.php.net/array_diff

*/


function bosssecretary_array_diff(array $haystack, array $needle)
{
  foreach ($needle as $value)
  {
    if (($key = array_search($value, $haystack)) !== FALSE)
    {
      unset($haystack[$key]);
    }
  }
  return $haystack;
}

/*

$haystack = array('a', 'b', 1, 10);

echo  bosssecretary_array_to_mysql_param_in($haystack);

output is:
'a', 'b', '1', '10'

*/


function bosssecretary_array_to_mysql_param_in(array $params)
{
  global $db;
  $arrParams = array();
  foreach ($params as $value)
  {
    array_push($arrParams, "'" .$db->escapeSimple($value). "'");
  }
  return implode($arrParams, ", ");
}




function bosssecretary_str_extensions_to_array($strExtensions)
{
  $strExtensions = trim($strExtensions);
  $strExtensions = str_replace(" ", "\n", $strExtensions);
  $arrExtensions = explode("\n", $strExtensions);
  foreach ($arrExtensions as $key => &$ext)
  {
    $ext = str_replace('\n','', $ext);
    $ext = trim($ext);
    if (empty($ext) and $ext != '0') // 0 is considered an empty string by some versions of php
    unset($arrExtensions[$key]);
  }
  return $arrExtensions;
}

function bosssecretary_create_nav_groups_links($groups, $dispnum)
{
  $links = array();
  $link["url"] = "config.php?display=$dispnum&bsgroupdisplay=".BOSSSECRETARY_PARAM_PREFIX. "add";
  $link["text"] = "Add Group";
  array_push($links, $link);
  if (!empty($groups))
  {
    foreach ($groups as $group)
    {
      $link["url"] = "config.php?display=$dispnum&bsgroupdisplay=".BOSSSECRETARY_PARAM_PREFIX . $group[0];
      if (trim($group[1]) == "" )
      {
        $group[1] = BOSSSECRETARY_LABEL_DEFAULT . $group[0];
      }
      $link["text"] = $group[0] . " (". $group[1].")";
      array_push($links, $link);
    }
  }
  return $links;
}

function bosssecretary_extract_group_from_request( $param)
{
  return ltrim($param, BOSSSECRETARY_PARAM_PREFIX); // easy, isn't it?
}


function bosssecretary_set_params_to_edit( $records)
{
  $vars = array();
  $first = current($records);
  $vars["group_number"] =  $first["id_group"];
  $vars["group_label"] =  $first["label"];

  if (trim($vars["group_label"]) == "")
  {
    $vars["group_label"] = BOSSSECRETARY_LABEL_DEFAULT . $vars["group_number"];
  }

  $vars["bosses_extensions"] = "";
  $vars["secretaries_extensions"] = "";
  $vars["chiefs_extensions"] = "";
  $s = array();
  $b = array();
  $c = array();
  foreach ($records as $record)
  {

    if (!empty($record["boss_extension"]))
    {
      array_push($b, $record["boss_extension"]);
    }
    if (!empty($record["secretary_extension"]))
    {
      array_push($s, $record["secretary_extension"]);
    }
    if (!empty($record["chief_extension"]))
    {
      array_push($c, $record["chief_extension"]);
    }
  }
  $vars["bosses"] = array_unique($b);
  $vars["secretaries"] = array_unique($s);
  $vars["chiefs"] = array_unique($c);
  return $vars;
}

/********************************************************
*                           *
*           GUI FUNCTIONS           *
*                           *
********************************************************/


function bosssecretary_content($title, $content, $messages){
  echo <<<OUTPUT


<div class="content">
  <h2>$title</h2>
<script>
// AJAX to the SubCategory DropDown
function getExtensions(extensions)
{
  
  var url = "config.php?sid=" + Math.random() + "&display=bosssecretary&extensions=" + extensions + "&ajax=true";
  xmlHttp=GetXmlHttpObject(setExtensions);
  xmlHttp.open("GET", url , true);
  xmlHttp.send(null);
  document.getElementById('divExtensions').innerHTML = "Searching";
  return true;
}

function setExtensions()
{
  if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
  {
    var datos;
    datos = (xmlHttp.responseText);
    document.getElementById('divExtensions').innerHTML = datos;
  }
}


function GetXmlHttpObject(handler){
  var objXmlHttp=null
  if (navigator.userAgent.indexOf("Opera")>=0){
    alert("This doesn't work in Opera")
    return
  }
  if (navigator.userAgent.indexOf("MSIE")>=0){
    var strName="Msxml2.XMLHTTP"
    if (navigator.appVersion.indexOf("MSIE 5.5")>=0){
      strName="Microsoft.XMLHTTP"
    }
    try{
      objXmlHttp=new ActiveXObject(strName)
      objXmlHttp.onreadystatechange=handler
      return objXmlHttp
    }catch(e){
      alert("Error. Scripting for ActiveX might be disabled")
      return
    }
  }
  if (navigator.userAgent.indexOf("Mozilla")>=0){
    objXmlHttp=new XMLHttpRequest()
    objXmlHttp.onload=handler
    objXmlHttp.onerror=handler
    return objXmlHttp
  }
}

</script>
<form method="post" name=searchbosssecretary action="config.php?display=bosssecretary" onsubmit="getExtensions(document.getElementById('extensions').value); return false;">
<table>
      <tr>
        <td colspan="2"><h5>Buscar grupo</h5> <hr /> </td>
      </tr>     
      <tr>
        <td colspan="2"><label>Extension:</label> <input type="text" id="extensions" name= "extension" value=""/> <input type="button" name="submitSearch" onclick="getExtensions(document.getElementById('extensions').value);" value="Search" /></td>       
      </tr>

      <tr>
        <td colspan="2"><div id="divExtensions"></div></td>
      </tr>
      <tr>
        <td colspan="2"><hr /></td>
      </tr>     
</table>
</form>

  $messages
  $content

</div>

OUTPUT;

}


function bosssecretary_get_form_add( array $params)
{
  $vars["form_title"] = "Add Group";
  $vars["form_url"] = "config.php?display=bosssecretary&bsgroupdisplay=".BOSSSECRETARY_PARAM_PREFIX. "add";
  $vars["bosses_extensions"]    = (isset($params["bosses"])) ? implode($params["bosses"], "\n") : '';
  $vars["secretaries_extensions"] = (isset($params["secretaries"])) ? implode($params["secretaries"], "\n") : '';
  $vars["chiefs_extensions"]  = (isset($params["chiefs"])) ? implode($params["chiefs"], "\n") : '';
  $vars["group_label"] = (isset($params["group_label"])) ? $params["group_label"] : '';
  $vars["delete_button"] = "";
  $vars["action"] = "Add";
  $vars["message_details"] = $params["message_details"];
  $vars["message_title"] = $params["message_title"];
  return bosssecretary_get_form($vars);
}


function bosssecretary_get_form_edit( array $params)
{
  $vars["form_title"] = "Edit Group";
  $vars["form_url"] = "config.php?display=bosssecretary&bsgroupdisplay=".BOSSSECRETARY_PARAM_PREFIX. $params["group_number"];
  $vars["bosses_extensions"] = (isset($params["bosses"])) ? implode($params["bosses"], "\n") : '';
  $vars["secretaries_extensions"] = (isset($params["secretaries"])) ? implode($params["secretaries"], "\n") : '';
  $vars["chiefs_extensions"]  = (isset($params["chiefs"])) ? implode($params["chiefs"], "\n") : '';
  $vars["group_number"] = $params["group_number"];
  $vars["group_label"] = $params["group_label"];
  $vars["delete_button"] = bosssecretary_get_delete_button();
  $vars["action"] = "Edit";
  $vars["message_details"] = $params["message_details"];
  $vars["message_title"] = $params["message_title"];
  $vars["delete_question"] = "Do you really to want delete " . $vars["group_number"] . " (" .$vars["group_label"] . ") group?";
  $vars["delete_url"] = "config.php?display=bosssecretary&bsgroupdelete=".BOSSSECRETARY_PARAM_PREFIX. $params["group_number"];
  return bosssecretary_get_form($vars);
}


function bosssecretary_get_form ( array $vars)
{
  $sForm = file_get_contents(dirname(__FILE__). "/form_template.tpl");


  $vars["messages"] = "";
  if (!empty($vars["message_details"]))
  {
    $vars["messages"] = "<h5>".$vars["message_title"] . "</h5>";
    $vars["messages"] .= "<ul>";
    foreach ($vars["message_details"] as $details)
    {
      $vars["messages"] .= "<li>$details</li>";
    }
    $vars["messages"] .= "</ul>";
    unset($vars["message_details"]);
    unset($vars["message_title"]);
  }


  foreach ($vars as $var => $value)
  {
    $sForm = str_replace("{".$var. "}", $value, $sForm);
  }
  return $sForm;
}




function bosssecretary_get_delete_button()
{
  $sForm = file_get_contents(dirname(__FILE__). "/delete_button.tpl");
  return str_replace("{delete_button_label}", "Delete Group", $sForm);
}



function bosssecretary_show_nav_users($links){
  echo <<<OUTPUT

<div class="rnav">
  <ul>

OUTPUT;
  foreach ($links as $link){
    $url  = $link['url'];
    $text = $link['text'];

    echo <<<OUTPUT
    <li><a href="{$url}">{$text}</a></li>
  
OUTPUT;
}
echo <<<OUTPUT
  </ul>
</div>

OUTPUT;
}

?>