modules/crm/include/crm.php (a7244bd) - webinterface.git

crm.php

<?php

require_once('inc/base.php');

return $return;
}

function find_users_for_customer($id)
{
  $id = (int) $id;
  $return = array();
  $result = db_query("SELECT uid, username FROM system.useraccounts WHERE ".
                     "kunde='{$id}';");
  while ($entry = mysql_fetch_assoc($result))
    $return[$entry['uid']] = $entry['username'];

return $return;
}

function hosting_contracts($cid)
{
  $cid = (int) $cid;
  $result = db_query("SELECT u.username, werber, beschreibung, betrag, brutto, monate, anzahl, startdatum, startdatum + INTERVAL laufzeit MONTH - INTERVAL 1 DAY AS mindestlaufzeit, kuendigungsdatum, gesperrt, notizen FROM kundendaten.hosting AS h LEFT JOIN system.useraccounts AS u ON (h.hauptuser=u.uid) WHERE h.kunde=".$cid);
  $ret = array();
  while ($x = mysql_fetch_assoc($result))
    array_push($ret, $x);
  DEBUG($ret);

}

webinterface.git

CRM still incomplete and unusable