function pencapaian($kota)
{
$q = mysql_query("SELECT \n\t\t\t\t\t\tMONTH(tgl_transaksi) AS bulan, \n\t\t\t\t\t\tSUM(transaksi) AS pencapaian ,\n\t\t\t\t\t\tkantor\n\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\tcorez_transaksi a\n\t\t\t\t\t\tINNER JOIN hcm_kantor b ON b.`id_kantor` = a.`id_kantor_transaksi`\n\t\t\t\t\t\tWHERE kantor='{$kota}' AND YEAR(tgl_transaksi)=2015 GROUP BY MONTH(tgl_transaksi)\n\t\t\t\t\t");
$f = target($kota);
$i = 0;
while ($row = mysql_fetch_array($q)) {
$rows[] = $row;
}
foreach ($rows as $fields) {
$g[$fields['bulan']] = (double) $fields['pencapaian'];
}
for ($i = 1; $i <= 12; $i++) {
$pencapaian2[] = $g[$i] ? (double) $g[$i] : 0;
$target2[] = (double) $f[$i] ? (double) $f[$i] : 0;
$bulan[] = date('M', strtotime('2015-' . $i . '-25'));
}
$array = array(array("name" => "Pencapaian", "data" => $pencapaian2), array("name" => "Target", "data" => $target2));
return array("data" => $array, "bulan" => $bulan);
}
function skill($caster)
{
global $player, $computer;
for (;;) {
$skill = rand(0, count($caster->skillPower) - 1);
if ($caster->skillPower[$skill]->level && $caster->skillPower[$skill]->store) {
break;
}
}
$target = target($caster);
switch ($skill) {
case 0:
case 1:
case 2:
if ($caster->skillPower[$skill]->level < 5) {
$target = target($caster);
$harm = rand(1, 100) * $caster->skillPower[$skill]->level * $caster->skillPower[$skill]->times * (rand(0, 100) / 100 > $caster->rate ? 1 : $caster->criticalTimes) + $caster->realDamage;
$target->hp -= $harm - $target->magicResist > 0 ? $harm - $target->magicResist : 0;
} else {
$otherSide = $player->side == ${$caster}->side ? $computer : $player;
}
break;
//buff
//buff
case 3:
case 4:
case 5:
case 6:
case 7:
$target = target($caster, 1);
$target->buff[$skill - 3]->level = $caster->skillPower[$skill]->level;
$target->buff[$skill - 3]->roundTime = $caster->skillPower[$skill]->level;
break;
case 8:
case 9:
case 10:
default:
# code...
break;
}
}
<dt style="width:80px; float:left;">Sampai:</dt>
<dd>: <?php
echo $model->PERIOD_END;
?>
</dd>
</dl>
</div>
</div>
<!-- TARGET !-->
<div class="row">
<div class="col-xs-5 col-sm-5 col-md-5" style="font-family: tahoma ;font-size: 9pt;padding-left:30px">
<div>
<?php
echo target($model);
?>
</div>
<dl>
<dt style="width:80px;"><h6><u><b>TARGET :</b></u></h6></dt>
<dd style="width:80px"> Rp.<?php
echo $model->TARGET_VALUE;
?>
</dd>
<dd><?php
echo $model->TARGET_TEXT;
?>
Rupiah</dd>
</dl>
</div>
/**
* Build MS SQL Query untuk input Usulan Program Rutin
* @param array() $arr
* @return string $query
* @todo - kelompok sasaran
* - status kegiatan
* - waktu pelaksanaan
* - sumber masuh DAU
*/
function createQueryUsulanKegiatanPrioritas($arr)
{
$query = "";
$i = 0;
foreach ($arr as $v) {
$i++;
$dt = pecahSkpd($v["skpdTujuan"], $v["urusan"], $v["bidang"]);
$ds = target($v["volume2"]);
$duit = $v["apbdKota2"] + $v["apbdProp2"] + $v["apbn2"] + $v["danaLain2"];
$query .= " begin tran if exists ( select * from [tests].[dbo].[kegiatan] with (updlock,serializable)";
$query .= " where [tahun] = " . $v["Thn"];
$query .= " and [kd_urusan] = " . $dt["urusan"];
$query .= " and [kd_bidang] = " . $dt["bidang"];
$query .= " and [kd_unit] = " . $dt["unit"];
$query .= " and [kd_sub] = " . $dt['sub'];
$query .= " and [id_prog] = " . $dt["id_prog"];
$query .= " and [kd_prog] = " . intval($v["program"]);
$query .= " and [kd_keg] = " . intval($v["kegiatan"]) . ")";
$query .= " begin update [tests].[dbo].[kegiatan]";
$query .= " set [ket_kegiatan] = " . "'" . removeQuote($v["namaKegiatan"]) . "',";
$query .= " [lokasi] = " . "'" . removeQuote($v["lokasi"]) . "',";
$query .= " [pagu_anggaran] = " . "'" . $duit . "'";
$query .= " where [tahun] = " . $v["Thn"];
$query .= " and [kd_urusan] = " . $dt["urusan"];
$query .= " and [kd_bidang] = " . $dt["bidang"];
$query .= " and [kd_unit] = " . $dt["unit"];
$query .= " and [kd_sub] = " . $dt['sub'];
$query .= " and [id_prog] = " . $dt["id_prog"];
$query .= " and [kd_prog] = " . intval($v["program"]);
$query .= " and [kd_keg] = " . intval($v["kegiatan"]) . ";";
$query .= " end else begin ";
$query .= "INSERT INTO [tests].[dbo].[kegiatan] ([tahun], [kd_urusan], [kd_bidang],\n [kd_unit], [kd_sub], [kd_prog], [id_prog], [kd_keg], [ket_kegiatan], [lokasi], \n [kelompok_sasaran], [status_kegiatan], [pagu_anggaran], \n [waktu_pelaksanaan], [kd_sumber]) VALUES";
$query .= "('" . $v["Thn"] . "',";
$query .= "'" . $dt["urusan"] . "',";
$query .= "'" . $dt["bidang"] . "',";
$query .= "'" . $dt["unit"] . "',";
$query .= "'" . $dt["sub"] . "',";
$query .= "'" . intval($v["program"]) . "',";
$query .= "'" . $dt["id_prog"] . "',";
$query .= "'" . intval($v["kegiatan"]) . "',";
$query .= "'" . removeQuote($v["namaKegiatan"]) . "',";
$query .= "'" . removeQuote($v["lokasi"]) . "',";
$query .= "' ',";
//kelompok sasaran
$query .= "'B',";
//status kegiatan
$query .= "'" . $duit . "',";
//pagu anggaran
$query .= "' ',";
// waktu pelaksanaan
$query .= "'3');";
// sumber DAU
$query .= " end commit tran";
// if ($i == 52) break;
}
return $query;
}
