ayminarm > Jeg ville håbe det kunne løses men jeg er desværre ikke så dygtig til php. Herunder kan i se hvilke fejl det er der kommer:
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 341
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 343
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 346
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 349
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 351
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 356
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 367
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 377
Warning: Division by zero in /home/sv_gymfinderdk/crm/index.php on line 482
Herunder er så index.php så håber jeg at i kan hjælpe mig med at rette fejlene.
<?
// ----------------------------------------------------------------------
// CUSTOMER-TOUCH CRM
// Copyright (C) 2003 by the Customer-Touch Development Team.
//
http://www.customer-touch.com// ----------------------------------------------------------------------
// Based on:
// CRM COMMERCIAL TRACKING TOOL -
http://sourceforge.net/projects/crm-ctt/// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// To read the license please visit
http://www.gnu.org/copyleft/gpl.html or
// take a look in the Doc directory
// ----------------------------------------------------------------------
// Original Author of this file: Alessandro Grassi
// ----------------------------------------------------------------------
session_start();
if (filesize("config.inc.php")==0) {
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
document.location='install.php';
//-->
</SCRIPT>
<?
}
include("includes/header2.inc.php");
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
function popupdater(i) {
newWindow = window.open('edit.php?NoMenu=1&e=' + i, 'Update' + i,'width=640,height=630,directories=0,status=0,menuBar=0,scrollBars=1,resizable=1');
}
//-->
</SCRIPT>
<?
// Variables to expect are $prio, $cat, $conten, $owner, $assignee, $add, $CRMcustomer, $status
if ($add) {
$sql = "INSERT INTO CRMentity(priority,category,content,owner,assignee,CRMcustomer,status) VALUES('$prio', '$cat', '$content', '$owner', '$assignee', '$CRMcustomer','$status')";
mysql_query($sql) or die (mysql_error());
}
if ($CloseEntity) {
$sqldate = date('Y-m-d');
$sql = "UPDATE CRMentity SET status='5' WHERE eid='$CloseEntity'";
mysql_query($sql) or die (mysql_error());
$sql = "UPDATE CRMentity SET closedate='$sqldate' WHERE eid='$CloseEntity'";
mysql_query($sql) or die (mysql_error());
print "<br>Entity $CloseEntity was closed, closedate variable was set.";
exit;
}
if ($ShowEntitiesOpen) {
$date = date('d-m-Y');
$sqldate = date('Y-m-d');
print "<i>$date</i><br><font size=+1>Brief entity overview</font><font size=-2><br><i>option!</i><br> </font>";
print "<table border='1' width='100%' bgcolor='#F2F2F2' cellspacing='0' cellpadding='4' bordercolor='#CECECE'><tr><td><b>ID</b></td><td><b>Customer</b>";
print "</td><td><b>Owner</b></td><td><b>Assignee</b></td><td><b>Status</b></td><td><b>Priority</b>";
print "</td><td><b>Category</b></td><td><b>Due date</b></td><td><b>Alarm date<b></td></tr>";
if ($query) {
$sql = $query;
} else {
$sql= "SELECT * FROM CRMentity,CRMcustomer,CRMusers WHERE CRMcustomer.cr_id=CRMentity.CRMcustomer AND CRMusers.us_id=CRMentity.owner AND deleted='n'ORDER BY sqldate,status,priority";
}
$result= mysql_query($sql) or die (mysql_error());
while ($e= mysql_fetch_array($result)) {
$html = "<table width=\'100%\' cellspacing=\'0\' cellpadding=\'3\' border=\'0\'><tr><td bgcolor=\'#CCCCCC\'><b>$e[category]</b></td></tr>";
$html .= "<tr><td><a class=\'bigsort\' href=\'java script:popupdater($e[eid]);\' title=\'$lang[editthis]\'>$lang[edit]</a></td></tr>";
$sql4 = "SELECT value FROM CRMsettings WHERE setting='Extra fields list'";
$result4 = mysql_query($sql4) or die (mysql_error());
$list = mysql_fetch_array($result4);
$list = $list[value];
if ($list<>"") {
$html .= "<tr><td><a class=\'bigsort\' href=\'edit_entity_values.php?eid=$e[eid]\' title=\'$lang[editthis]\'>$lang[editextras]</a></td></tr>";
}
$html .= "<tr><td><a class=\'bigsort\' href=\'date.php?eID=$e[eid]\' title=\'$lang[alarmsettings]\'>$lang[alarmsettings]</a></td></tr>";
if ($e[status] <> "close") {
$html .= "<tr><td><a class=\'bigsort\' href=\'index.php?CloseEntity=$e[eid]\' title=\'$lang[closethisentity]\'>$lang[close]</A></td></tr>";
}
$html .= "<tr><td><a class=\'bigsort\' href=\'edit.php?d=$e[eid]\' title=\'$lang[deletethisentity]\'>$lang[delete]</a></td></tr>";
$html .= "<tr><td><a class=\'bigsort\' title=\'$lang[downloadpdf]\' href=\'sumpdf.php?pdf=$e[eid]\'>$lang[pdfreport]</a> <a OnClick=\'java script:pophelp(19);\' class=\'topnav\' cursor=\'click\' style=\'cursor: help\'><img src=\'info.gif\'></a></td></tr>";
$html .= "</table>";
print "<tr onmouseover=\"java script:style.background='#CCCCCC';return overlib('" . $html . "', STICKY)\" onmouseout=\"java script:style.background='#F2F2F2';nd();\"><td><b>$e[eid]</b></td><td>$e[cr_fastname]</td><td>$e[us_name]</td><td>";
$sql1 = "SELECT us_name FROM CRMusers WHERE us_id='$e[assignee]'";
$rult= mysql_query($sql1) or die (mysql_error());
$e1= mysql_fetch_array($rult);
print "$e1[us_name]</td>";
if ($e[status]=='5') {
print "<td bgcolor='FF3300'>";
} elseif ($e[status]=='1') {
print "<td bgcolor='#33FF00'>";
} else {
print "<td bgcolor='#3300FF'>";
}
print "$e[status]</td>";
if ($e[priority]=="critica") {
print "<td bgcolor='#FFFF00'><font color='#FF0000'>";
} elseif ($e[priority]=="alta") {
print "<td bgcolor='#FFFF66'>";
} elseif ($e[priority]=="media") {
print "<td bgcolor='#FFFF99'>";
} else {
print "<td bgcolor='#FFFFCC'>";
}
print "$e[priority]</td><td><b>$e[category]</b></td>";
if ($e[duedate]==$date) {
$tmp="</font>";
print "<td><font color='FF3300' width='70'>";
}
elseif ($e[sqldate]<$sqldate) {
$tmp="</u></font>";
print "<td><font color='FF3300' width='70'><u>";
}
else
{
print "<td width='70'>";
}
if ($e[duedate]=="") {
$e[duedate] = "<font color='FF3300'>none</font>";
}
print "$e[duedate]$tmp</td>";
$sql3 = "SELECT basicdate FROM CRMcalendar WHERE eID='$e[eid]'";
$rult2= mysql_query($sql3) or die (mysql_error());
if ($e5= mysql_fetch_array($rult2)) {
$e5[basicdate] = substr($e5[basicdate],0,2) . "-" . substr($e5[basicdate],2,2) . "-" . substr($e5[basicdate],4,4);
print "<td width='70'>$e5[basicdate]</td>";
} else {
print "<td><font color='FF3300'>none</font></td>";
}
print "<td width='70'><a class='bigsort' href='$PHP_SELF?CloseEntity=$e[eid]' title='Close this entity'>C</A> | <a class='bigsort' href='java script:popupdater($e[eid])' title='Edit this entity'>E</a> | <a class='bigsort' href='date.php?eID=$e[eid]' title='Alarm settings'>A</a> | <a class='bigsort' href='edit.php?d=$e[eid]' title='Delete this entity'>D</a></td></tr>";
}
print "</table></></html>";
exit;
}
$sql = "SELECT COUNT(*) FROM CRMusers";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxU = $maxU1[0];
$sql = "SELECT COUNT(*) FROM CRMentity";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxE = $maxU1[0];
$sql = "SELECT COUNT(*) FROM CRMcustomer";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxC = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='1' ";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEoNc = $maxU1[0];
print "<span class='st1'>$arr[WELCOME] $title.<br>$arr[BRIEF]</span><br><br>";
//<img src='ibridge.gif' align='center'>";
print "<table border='1' cellpadding='2' cellspacing='0' bordercolor='#b16519' style='border-style:thin; border:1px'><tr><td bgcolor='#eeeeee' width='612'>$arr[THIS_MOM] $maxU $arr[USERS_ADM_EN_COUNT] <b>$maxE</b> $arr[ENTITIES_FOR] <b>$maxC</b> $arr[CLIENTS_IN_DB]</td></tr></table>";
//print "<br>";
$date = date('d-m-Y');
$toprint0 = "$arr[TOPPR0]";
$sql = "SELECT CRMentity.eid AS id, CRMentity.category AS cat,CRMusers.us_name AS name, CRMcustomer.cr_fastname AS cust FROM CRMentity,CRMcustomer,CRMusers WHERE duedate='$date' AND CRMcustomer.cr_id=CRMentity.CRMcustomer AND CRMusers.us_id=CRMentity.assignee AND CRMentity.deleted='n' AND CRMentity.status<>'5' ORDER BY CRMcustomer.cr_fastname";
print "<table>";
$result= mysql_query($sql) or die (mysql_error());
while ($today= mysql_fetch_array($result)) {
// <a class='topnav' title='Update in new window' href='java script:popupdater(eid])'>[update in new window]</a>
$toprint1 .= "<tr><td><b> - $today[id]</td><td><a href='java script:popupdater($today[id])' class='bigsort'>$today[cust] : $today[cat] ($arr[ASS_TO] $today[name])</a></b></td></tr>";
}
if ($toprint1) {
print $toprint0 . $toprint1;
print "</table>";
} else {
print "$arr[WELCOME3] $maxEoNc $arr[ENT_OP_NO_AW]";
}
print "<br><br>";
$cdate = date('Y-m-d');
$time_start = microtime();
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMusers";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxU = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxo = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxE = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='1'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEo = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status<>'5' AND deleted<>'y'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEoNc = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='5' AND deleted<>'y'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEc = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='2' OR status='21' OR status='22'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEa = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='4'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxEr = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE deleted='y'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$delE = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE status='3'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$obsE = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE waiting='y'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$waiE = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMcustomer";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$maxC = $maxU1[0];
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE sqldate<'$cdate' AND deleted<>'y' and status<>'5'";
$result= mysql_query($sql) or die (mysql_error());
$maxU1 = mysql_fetch_array($result);
$expE = $maxU1[0];
$time_end = microtime();
$seconds = $time_end - $time_start;
$seconds = number_format($seconds,3);
print "<table border='1' cellpadding='2' cellspacing='0' bordercolor='#b16519' style='border-style:thin; //border:1px'><tr><td bgcolor='#E5CC74' width=\"100%\">";
print "<tr>";
$sql= "SELECT us_type FROM CRMusers WHERE us_name='$name'";
$result= mysql_query($sql) or die (mysql_error());
$result= mysql_fetch_array($result);
internav($result[us_type]);
global $sqlcounter,$maxU,$maxo,$maxE,$maxEo,$maxEc,$maxEa,$delE,$obsE,$maxC,$expE,$waiE,$password,$maxEoNc;
print "<td colspan=4><table width=\"60%\" bgcolor='#E5CC74' align='right' ><tr><td>";
print "<b>::: KM OWERVIEW :::</b><br><br>";
print "<tr><td>$arr[TOT_EN_STAT]</td><td>$maxE</td></tr>";
print "<tr><td><i>$arr[OF_STAT]</i></td></tr>";
$pc1 = ($maxE/100); // dit is 1 procent
$pc2 = ($maxEoNc/100); // dit is 1 procent van Not Closed Not Deleted
$apc = round($maxEo/$pc1); // dit is het percentage
print "<tr><td> $arr[OPENED]</td><td width=\"20%\">$maxEo</td><td width=\"20%\">$apc%</td></tr>";
$apc = round($maxEa/$pc1); // dit is het percentage
print "<tr><td> $arr[AWAITING]</td><td>$maxEa</td><td>$apc%</td></tr>";
$apc = round($maxEr/$pc1); // dit is het percentage
print "<tr><td> $arr[REJECTED]</td><td>$maxEr</td><td>$apc%</td></tr>";
$apc = round($maxEc/$pc1); // dit is het percentage
print "<tr><td> $arr[CLOSED]</td><td>$maxEc</td><td>$apc%</td></tr>";
$apc = round($delE/$pc1); // dit is het percentage
print "<tr><td> $arr[DELETED]</td><td>$delE</td><td>$apc%</td></tr>";
print "<tr><td> </td></tr>";
$apc = round($expE/$pc2); // dit is het percentage
if ($apc>30) {
$a1 = "<font color='ff0000'>";
$a2 = "</font>";
} else {
unset($a1);
unset($a2);
}
print "<tr><td>$arr[EXPIRED]</td><td>$expE</td><td>$a1$apc%$a2</td></tr>";
$apc = round($obsE/$pc1); // dit is het percentage
if ($apc>30) {
$a1 = "<font color='ff0000'>";
$a2 = "</font>";
} else {
unset($a1);
unset($a2);
}
print "<tr><td>$arr[NON_EXISTING_AND_DEL]</td><td>$obsE</td><td>$a1$apc%$a2</td></tr>";
$apc = round($waiE/$pc1); // dit is het percentage
if ($apc>30) {
$a1 = "<font color='ff0000'>";
$a2 = "</font>";
} else {
unset($a1);
unset($a2);
}
if (!$thisweek) { $thisweek=0; }
print "<tr><td>$arr[ADD_TH_WK]:</td><td>$thisweek</td></tr>";
$sqlcounter++;
$sql = "SELECT eid,closedate FROM CRMentity WHERE closedate<>'0000-00-00' AND status='5'";
$result= mysql_query($sql) or die (mysql_error());
while ($e= mysql_fetch_array($result)) {
$t = $e[closedate];
$tjaar = substr($t,0,4);
$year = date("Y");
if ($tjaar == $year) {
$tmaand = substr($t,5,2);
$tdag = substr($t,8,2);
$tmp = date ("W", mktime (0,0,0,$tmaand,$tdag,$tjaar));
// print "<tr><td>Matching $tmp against $weeknumber</td></tr>";
if ($weeknumber == $tmp) {
$thisweek2++;
}
}
}
if (!$thisweek2) { $thisweek2=0; }
print "<tr><td>$arr[CL_TH_WK]:</td><td>$thisweek2</td></tr>";
$month = date("F");
$sqlcounter++;
$sql = "SELECT eid,cdate FROM CRMentity";
$result= mysql_query($sql) or die (mysql_error());
while ($e= mysql_fetch_array($result)) {
$t = $e[cdate];
$tjaar = substr($t,0,4);
$year = date("Y");
if ($tjaar == $year) {
$tmaand = substr($t,5,2);
$tdag = substr($t,8,2);
$tmp = date ("F", mktime (0,0,0,$tmaand,$tdag,$tjaar));
// print $tmp;
if ($month == $tmp) {
$thismonth++;
}
}
}
if (!$thismonth) { $thismonth=0; }
print "<tr><td>$arr[ADD_TH_M]:</td><td>$thismonth</td></tr>";
$month = date("F");
$sqlcounter++;
$sql = "SELECT eid,closedate FROM CRMentity WHERE closedate<>'0000-00-00' and status='5'";
$result= mysql_query($sql) or die (mysql_error());
while ($e= mysql_fetch_array($result)) {
$t = $e[closedate];
$tjaar = substr($t,0,4);
$year = date("Y");
if ($tjaar == $year) {
$tmaand = substr($t,5,2);
$tdag = substr($t,8,2);
$tmp = date ("F", mktime (0,0,0,$tmaand,$tdag,$tjaar));
// print "<tr><td>Matching $tmp against $month. Date is $e[closedate] </td></tr>";
// print $tmp;
if ($month == $tmp) {
$thismonth2++;
}
}
}
if (!$thismonth2) { $thismonth2=0; }
print "<tr><td>$arr[CL_TH_M]:</td><td>$thismonth2</td></tr>";
//print "<tr><td><a href='$PHP_SELF?password=$password&summonth=1' class='topnav'>$arr[ANNUAL_SM]</a></tr>";
$sqlcounter++;
$sql = "SELECT * FROM CRMentity WHERE cdate<>'0000-00-00' AND closedate<>'0000-00-00' AND status='5'";
$result= mysql_query($sql) or die (mysql_error());
while ($e= mysql_fetch_array($result)) {
$t = $e[closedate];
$tjaar = substr($t,0,4);
$tmaand = substr($t,5,2);
$tdag = substr($t,8,2);
$tmp = date ("U", mktime (0,0,0,$tmaand,$tdag,$tjaar));
$t = $e[cdate];
$tjaar = substr($t,0,4);
$tmaand = substr($t,5,2);
$tdag = substr($t,8,2);
$tmp2 = date ("U", mktime (0,0,0,$tmaand,$tdag,$tjaar));
$avg = $avg + round((($tmp-$tmp2)/86400));
$avgc++;
}
print "<tr><td> </td></tr>";
$sqlcounter++;
$sql = "SELECT COUNT(*) FROM CRMentity WHERE closedate='0000-00-00' AND status='5'";
$result= mysql_query($sql) or die (mysql_error());
$maxW = mysql_fetch_array($result);
$maxWc = $maxW[0];
print "<tr><td colspan=5>$arr[ON_AVER] $avgc $arr[AN_EN] " . round($avg/$avgc) . " $arr[DDAYS] ";
print "<br>";
print "<i>$arr[DATA_OBT1] $maxWc $arr[DATA_OBT2]</i></td></tr>";
print "</td></tr></table></td></tr>";
print "</td></tr></tr></table>";
print "</body></html>";
?>
På forhånd mange tusind tak.
Mhv Jonas
Ny bruger
Nybegynder
Opret
Preview
