/**
* Print the contract costs
*
* @param $contract Contract object
* @param $withtemplate boolean Template or basic item (default '')
*
* @return Nothing (call to classes members)
**/
static function showForContract(Contract $contract, $withtemplate = '')
{
global $DB, $CFG_GLPI;
$ID = $contract->fields['id'];
if (!$contract->getFromDB($ID) || !$contract->can($ID, READ)) {
return false;
}
$canedit = $contract->can($ID, UPDATE);
echo "<div class='center'>";
$query = "SELECT *\n FROM `glpi_contractcosts`\n WHERE `contracts_id` = '{$ID}'\n ORDER BY `begin_date`";
$rand = mt_rand();
if ($canedit) {
echo "<div id='viewcost" . $ID . "_{$rand}'></div>\n";
echo "<script type='text/javascript' >\n";
echo "function viewAddCost" . $ID . "_{$rand}() {\n";
$params = array('type' => __CLASS__, 'parenttype' => 'Contract', 'contracts_id' => $ID, 'id' => -1);
Ajax::updateItemJsCode("viewcost" . $ID . "_{$rand}", $CFG_GLPI["root_doc"] . "/ajax/viewsubitem.php", $params);
echo "};";
echo "</script>\n";
echo "<div class='center firstbloc'>" . "<a class='vsubmit' href='javascript:viewAddCost" . $ID . "_{$rand}();'>";
echo __('Add a new cost') . "</a></div>\n";
}
if ($result = $DB->query($query)) {
echo "<table class='tab_cadre_fixehov'>";
echo "<tr><th colspan='5'>" . self::getTypeName($DB->numrows($result)) . "</th></tr>";
if ($DB->numrows($result)) {
echo "<tr><th>" . __('Name') . "</th>";
echo "<th>" . __('Begin date') . "</th>";
echo "<th>" . __('End date') . "</th>";
echo "<th>" . __('Budget') . "</th>";
echo "<th>" . __('Cost') . "</th>";
echo "</tr>";
Session::initNavigateListItems(__CLASS__, sprintf(__('%1$s = %2$s'), Contract::getTypeName(1), $contract->getName()));
$total = 0;
while ($data = $DB->fetch_assoc($result)) {
echo "<tr class='tab_bg_2' " . ($canedit ? "style='cursor:pointer' onClick=\"viewEditCost" . $data['contracts_id'] . "_" . $data['id'] . "_{$rand}();\"" : '') . ">";
$name = empty($data['name']) ? sprintf(__('%1$s (%2$s)'), $data['name'], $data['id']) : $data['name'];
echo "<td>";
printf(__('%1$s %2$s'), $name, Html::showToolTip($data['comment'], array('display' => false)));
if ($canedit) {
echo "\n<script type='text/javascript' >\n";
echo "function viewEditCost" . $data['contracts_id'] . "_" . $data["id"] . "_{$rand}() {\n";
$params = array('type' => __CLASS__, 'parenttype' => 'Contract', 'contracts_id' => $data["contracts_id"], 'id' => $data["id"]);
Ajax::updateItemJsCode("viewcost" . $ID . "_{$rand}", $CFG_GLPI["root_doc"] . "/ajax/viewsubitem.php", $params);
echo "};";
echo "</script>\n";
}
echo "</td>";
echo "<td>" . Html::convDate($data['begin_date']) . "</td>";
echo "<td>" . Html::convDate($data['end_date']) . "</td>";
echo "<td>" . Dropdown::getDropdownName('glpi_budgets', $data['budgets_id']) . "</td>";
echo "<td class='numeric'>" . Html::formatNumber($data['cost']) . "</td>";
$total += $data['cost'];
echo "</tr>";
Session::addToNavigateListItems(__CLASS__, $data['id']);
}
echo "<tr class='b noHover'><td colspan='3'> </td>";
echo "<td class='right'>" . __('Total cost') . '</td>';
echo "<td class='numeric'>" . Html::formatNumber($total) . '</td></tr>';
} else {
echo "<tr><th colspan='5'>" . __('No item found') . "</th></tr>";
}
echo "</table>";
}
echo "</div><br>";
}
$html .= '<td><a href="' . edkURI::page('system_detail', $row['id'], 'sys_id') . '">' . $row['name'] . "</td><td align=center><button id=submit name=submit onClick=\"window.location.href='" . $editURL . "'\">Select</button></td>";
break;
}
$html .= "</tr>";
}
if ($qry->recordCount()) {
$html .= "</table>";
}
}
} else {
$page->setTitle("Administration - Edit Campaign");
$contract = new Contract($ctrID);
$html .= "<div class=block-header2>Details</div>";
$html .= '<form id=detail_edit name=detail_edit method=post action="' . edkuri::build(array(array('ctr_id', $ctrID, false), array('op', 'edit', false))) . '">';
$html .= "<table class=kb-subtable width=98%>";
$html .= "<tr><td width=80><b>Name:</b></td><td><input type=text name=ctr_name id=ctr_name size=38 maxlength=38 value=\"" . htmlspecialchars($contract->getName(), ENT_QUOTES) . "\"></td></tr>";
$html .= "<tr><td width=80><b>Start date:</b></td><td><input type=text name=ctr_started id=ctr_started size=10 maxlength=10 value=\"" . substr($contract->getStartDate(), 0, 10) . "\"> (yyyy-mm-dd)</td></tr>";
$html .= "<tr><td width-80><b>End date:</b></td><td><input type=text name=ctr_ended id=ctr_ended size=10 maxlength=10 value=\"" . substr($contract->getEndDate(), 0, 10) . "\"> (yyyy-mm-dd or blank)</td></tr>";
$html .= "<tr><td><b>Comment:</b></td><td><input type='text' name='ctr_comment' value='" . htmlspecialchars($contract->getComment(), ENT_QUOTES) . "' size='100'/></td></tr>";
$html .= "<tr><td></td></tr>";
$html .= "<tr><td></td><td><input type=submit name=detail_submit value=\"Save\"></td></tr>";
$html .= "</table>";
$html .= "</form>";
$html .= "<div class=block-header2>Targets</div>";
$html .= "<table class=kb-table cellspacing=1>";
$html .= "<tr class=kb-table-header><td class=kb-table-cell width=160>Target</td><td class=kb-table-cell width=80 align=center>Corporation</td><td class=kb-table-cell width=80 align=center>Alliance</td><td class=kb-table-cell width=80 align=center>Region</td><td class=kb-table-cell width=80 align=center>System</td><td class=kb-table-cell width=80 align=center>Action</td></tr>";
$c = 0;
while ($contracttarget = $contract->getContractTarget()) {
$c++;
$type = $contracttarget->getType();
$typeURL = false;
popup| <?php
/**
* @package EDK
*/
require_once 'mods/forum_post/class.killsummarytable.php';
if (isset($_GET['ctr_id'])) {
$ctr_id = intval($_GET['ctr_id']);
$contract = new Contract($ctr_id);
$klist = $contract->getKillList();
$llist = $contract->getLossList();
$killsummary = new KillSummaryTable($klist, $llist);
$killsummary->setBreak(6);
if ($_GET['view'] == "") {
$killsummary->setFilter(false);
}
$name = $contract->getName();
}
if (isset($_GET['kll_id'])) {
$kll_id = intval($_GET['kll_id']);
// this is a fast query to get the system and timestamp
$rqry = DBFactory::getDBQuery();
$rsql = 'SELECT kll_timestamp, kll_system_id from kb3_kills where kll_id = ' . $kll_id;
$rqry->execute($rsql);
$rrow = $rqry->getRow();
$system = new SolarSystem($rrow['kll_system_id']);
// now we get all kills in that system for +-12 hours
$query = 'SELECT kll.kll_timestamp AS ts FROM kb3_kills kll WHERE kll.kll_system_id=' . $rrow['kll_system_id'] . '
AND kll.kll_timestamp <= date_add( \'' . $rrow['kll_timestamp'] . '\', INTERVAL \'12\' HOUR )
AND kll.kll_timestamp >= date_sub( \'' . $rrow['kll_timestamp'] . '\', INTERVAL \'12\' HOUR )
ORDER BY kll.kll_timestamp ASC';
$qry = DBFactory::getDBQuery();
