customizeData: function(data) {
for(var i = 0; i < data.body.length; i++) {
for(var j = 0; j < data.body[i].length; j++) {
data.body[i][j] = '\u200C' + data.body[i][j];
}
}
}
GAME PORTS ——————— PUBG Mobile TCP : 7889,10012,17500,18081
UDP : 8011,9030,10010-10650,11000-14000,17000,20000,20001,20002
PUBG PC TCP: 27015-27030,27036-27037
UDP: 4380,27000-27031,27036
FREE FIRE TCP : 7006,14000,20561,39698,39779,39003 UDP : 7008,10000-10009,17000 MOBILE LEGENDS TCP : 5500-5700,8001,30000-30300,9000-9010 30097-30147,30000-30150,9001,30101-30105,5057,5228,5001-5009, 5520-5529,5551,5651,5153 UDP : 5000-5200,5500-5700,8001,30000-30300,9000-9010 5601-5602,5025,5605,5005,5503,5101-5109,5001-5009,30101, 5520-5529,5020-5024,5501-5509,5517
POINT BLANK TCP : 39190-39200,49001-49190
UDP : 40000-40010 AOV TCP : 10001-10094 UDP : 10101-10201,10080-10110,17000-18000 GARENA LEAGUE OF LEGEND (LOL): TCP : 2080-2099 UDP : 5100 DOTA 2 TCP : 9100-9200,8230-8250,8110-8120,27000-28998 UDP : 27000-28998,39000
foreach($data as $f )
{
//$worksheet->getStyle('A'.$row1)->getNumberFormat()->setFormatCode($textFormat);
$worksheet->setCellValue('A'.$row1, $no.chr(46));
$worksheet->setCellValue('B'.$row1,' '.$f['nama']);
$spreadsheet->getActiveSheet()->getStyle('A'.$row1)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
$row1++; $no++;
}
// set the font style for the entire workbook
$phpExcel->getDefaultStyle()->getFont()
->setName('Arial')
->setSize(14)
->setBold(true);
// custom style with different font than the global one
$styleArray = array(
'font' => array(
'bold' => true,
'color' => array('rgb' => 'FF0000'),
'size' => 15,
'name' => 'Verdana'
));
// create some cells
$phpExcel->getActiveSheet()->getCell('A1')->setValue('Hello world');
$phpExcel->getActiveSheet()->getCell('A2')->setValue('Hello again');
$phpExcel->getActiveSheet()->getCell('A3')->setValue('Goodbye');
// apply custom style to single cell
$phpExcel->getActiveSheet()->getStyle('A3')->applyFromArray($styleArray);
SELECT * FROM t1 WHERE (id,rev) IN ( SELECT id, MAX(rev) FROM t1 GROUP BY id )
SELECT * FROM Employee where Employee.Salary in (select max(salary) from Employee group by Employe_id) ORDER BY Employee.Salary
<style type="text/css">
<!--
/* @group Blink */
.blink {
-webkit-animation: blink .75s linear infinite;
-moz-animation: blink .75s linear infinite;
-ms-animation: blink .75s linear infinite;
-o-animation: blink .75s linear infinite;
animation: blink .75s linear infinite;
}
@-webkit-keyframes blink {
0% { opacity: 1; }
50% { opacity: 1; }
50.01% { opacity: 0; }
100% { opacity: 0; }
}
@-moz-keyframes blink {
0% { opacity: 1; }
50% { opacity: 1; }
50.01% { opacity: 0; }
100% { opacity: 0; }
}
@-ms-keyframes blink {
0% { opacity: 1; }
50% { opacity: 1; }
50.01% { opacity: 0; }
100% { opacity: 0; }
}
@-o-keyframes blink {
0% { opacity: 1; }
50% { opacity: 1; }
50.01% { opacity: 0; }
100% { opacity: 0; }
}
@keyframes blink {
0% { opacity: 1; }
50% { opacity: 1; }
50.01% { opacity: 0; }
100% { opacity: 0; }
}
/* @end */
-->
</style>
$('select[name="kode2"]').find('option[value="<?= $model->kode2 ?>"]').attr("selected",true);
$('select[name="kode3"]').find('option[value="<?= $model->kode3 ?>"]').attr("selected",true);
$('select[name="kode4"]').find('option[value="<?= $model->kode4 ?>"]').attr("selected",true);
$('select[name="kode5"]').find('option[value="<?= $model->kode5 ?>"]').attr("selected",true);
$('select[name="kode6"]').find('option[value="<?= $model->kode6 ?>"]').attr("selected",true);