File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/backup2609/API/IPO/V3/IPOCalendar/IPOCalandar.php
Back
<?php if(isset($_GET['c'])) $color = '#'.$_GET['c']; else $color = "#F16334"; require_once("Connection.php"); $sql = "SELECT `c_name` AS 'NAME',`TYPE` AS 'TYPE',`ipo_open` AS 'OPEN',`ipo_close` AS 'CLOSE',`ipo_allotment` AS 'ALLOTMENT',`ipo_refund` AS 'REFUND',`ipo_credit` AS 'CREDIT',`ipo_listing` AS 'LISTING' FROM `ipo_post` WHERE `status` = 'PRESENT';"; $Orirows = $con->query($sql); $resultArray = $Orirows->fetch_all(MYSQLI_ASSOC); date_default_timezone_set("Asia/Calcutta"); $today = date("d-m-Y"); $cur = new DateTime( $today ); ?> <!DOCTYPE html> <html lang="en" > <head> <meta charset="UTF-8"> <title>IPO Calendar</title> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/meyer-reset/2.0/reset.min.css"> <link rel='stylesheet' href='https://cdn.jsdelivr.net/jquery.slick/1.6.0/slick.css'> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous"> <link rel='stylesheet' href='https://cdn.jsdelivr.net/jquery.slick/1.6.0/slick-theme.css'> <link rel="stylesheet" href="./style.css"> <style> a { text-decoration: none; color: <?php echo $color; ?>; } .right-border { border-right: 1px solid <?php echo $color;?>; } .left-border { border-left: 1px solid <?php echo $color;?>; } .top-border { border-top: 1px solid <?php echo $color;?>; } .bottom-border { border-bottom: 1px solid <?php echo $color;?>; } .clash-card__unit-stats--barbarian .bottom-border { border-bottom: 1px solid <?php echo $color;?>; } .clash-card__unit-stats--barbarian { border-top: 1px solid <?php echo $color;?>; } @supports (-webkit-touch-callout: none) { #heading { display:none; } } </style> </head> <body style="background-color: <?php echo $color;?>"> <!-- partial:index.partial.html --> <div class="slide-container"> <div class="wrapper" id="heading" > <div class="clash-card barbarian" > <div class="clash-card__unit-stats"> <div class="one-third" style="width: 100%;" > <div class="stat" style="color: <?php echo $color; ?>"> IPO Calendar </div> </div> </div> </div> </div> <?php if(count($resultArray) > 0) { $cnt = 1; while($cnt <= 30) { $rows = $resultArray; $day = $cur->format("d-m-Y"); $hasEvent = false; foreach($rows as $row) { if($row["OPEN"] == "") continue; if($day == $row["OPEN"] || $day == $row["CLOSE"] || $day == $row["ALLOTMENT"] || $day == $row["REFUND"] || $day == $row["CREDIT"] || $day == $row["LISTING"]) { $hasEvent = true; break; } } if($hasEvent) { ?> <div class="wrapper" > <div class="clash-card barbarian" > <div class="clash-card__unit-stats"> <div class="one-third" style="width: 100%" > <div class="stat" style="color: <?php echo $color; ?>"><?php $timestamp = strtotime($day); $tday = date('l', $timestamp); echo $tday . ' , ' . $day; ?></div> </div> <?php $InsideRows = $resultArray; foreach($InsideRows as $InsideRow) { $ipoName = $InsideRow["NAME"]; $ipoType = $InsideRow["TYPE"]; if($ipoType == "S") $ipoType = "SME"; else $ipoType = "Mainline"; $event = ""; $clr = "#FFF"; if("" == $row["OPEN"]) { continue; } if($day == $InsideRow["OPEN"]) { $event = "OPEN"; $clr = "#004d00"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } if($day == $InsideRow["CLOSE"]) { $event = "CLOSE"; $clr = "#990000"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } if($day == $InsideRow["ALLOTMENT"]) { $event = "ALLOTMENT"; $clr = "#CC7A00"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } if($day == $InsideRow["REFUND"]) { $event = "REFUND"; $clr = "#009933"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } if($day == $InsideRow["CREDIT"]) { $event = "CREDIT"; $clr = "#0099e6"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } if($day == $InsideRow["LISTING"]) { $event = "LISTING"; $clr = "#5cd6d6"; ?> <div class="one-third top-border right-border" style="width: 27%; background-color: <?php echo $clr; ?>" > <div class="stat" style="color: <?php echo "#FFFFFF"; ?>"><?php echo $event; ?></div> </div> <div class="one-third right-border top-border" style="width: 53%"> <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoName; ?></div> </div> <div class="one-third top-border" style="width: 20%" > <div class="stat" style="color: <?php echo $color; ?>"><?php echo $ipoType; ?></div> </div> <?php } } ?> </div> </div> </div> <?php } $cnt = $cnt + 1; $cur = $cur->modify('+1 day'); } } mysqli_close($con); ?> </div> <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/2.2.2/jquery.min.js'></script> <script src='https://cdn.jsdelivr.net/jquery.slick/1.6.0/slick.min.js'></script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings