public static function checkIfIPIsTaken($ip)
{
if (MySql::returnSingleValue("SELECT COUNT( ContactID ) FROM tblContact WHERE tblContact.CompanyName = :ip", ['ip' => $ip])) {
return false;
}
return true;
}
protected function afterSave()
{
parent::afterSave();
if ($this->Order == null && $this->GalleryID != 0) {
$this->Order = intval(MySql::returnSingleValue("SELECT tblImage.Order FROM tblImage WHERE GalleryID = " . intval($this->GalleryID) . " ORDER BY tblImage.Order DESC LIMIT 1")) + 1;
$this->save();
}
}
public function getDefaultImage()
{
if ($this->DefaultImageID && $this->DefaultImageID !== 0) {
$id = $this->DefaultImageID;
} else {
$id = MySql::returnSingleValue("SELECT ImageID FROM tblImage WHERE GalleryID = :GalleryID ORDER BY tblImage.Order ", ["GalleryID" => $this->GalleryID]);
}
try {
return (new Image($id))->GetResizedImage(1);
} catch (RecordNotFoundException $ex) {
return '/static/images/no-thumb.png';
}
}
public function testSingleResultCanBeFetched()
{
$value = MySql::returnSingleValue("SELECT :number", ["number" => 5]);
$this->assertEquals(5, $value);
}
protected function printViewContent()
{
$user = CustomLoginProvider::getLoggedInUser();
$firstImg = 0;
?>
<div class="__container" style="padding-bottom: 10px">
<?php
parent::printViewContent();
?>
<div class="gallery-collection-images">
<ul>
<?php
$counter = 0;
foreach ($this->images as $image) {
if ($firstImg === 0) {
$firstImg = $image->ImageID;
}
$class = $counter === 0 ? 'selected' : '';
$commentNums = MySql::returnSingleValue("SELECT COUNT( CommentID ) FROM tblComment WHERE ImageID = '" . $image->ImageID . "'");
$commentNums = $commentNums == 1 ? $commentNums . " komentārs" : $commentNums . " komentāri";
print '<li class="thumbnail-image-container">
<a href="#' . $counter . '">
<img id="img' . $counter . '" class="thumbnail-image img-thumbnail ' . $class . '" thumb="' . $counter . '" imgID="' . $image->ImageID . '" src="' . $image->GetResizedImage(1) . '">
</a>
<span>' . $commentNums . ' </span>
</li>';
$counter++;
}
?>
</ul>
</div>
</div>
<div class="row">
<div class="__container">
<div class="row">
<div class="col-xs-6 center-align">
<a href="/img/?g=<?php
echo $this->images[0]->ImageID;
?>
" id="downloadButton" ><i class="fa fa-download"></i> Lejuplādēt </a>
</div>
<div class="col-xs-6 center-align">
<a href="#" class="" data-toggle="modal" data-target="#myModal"><i class="fa fa-upload"></i> Pievienot bilde(s)</a>
</div>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel">Pievienot bildes galerijai</h4>
</div>
<div id="dropzone">
<div action="/portal/gallery/<?php
echo $this->images[0]->GalleryID;
?>
/?a=<?php
echo $this->images[0]->GalleryID;
?>
" class="dropzone" id="image-upload">
<div class="dz-message">Bildes parādisies šeit<br />
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="button" class="btn btn-primary" data-dismiss="modal" id="save-mode-button">Saglabāt!</button>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="comments-bound __container" style="min-height: 46px;">
<?php
self::getCommentsForImageID($this->images[0]->ImageID);
?>
</div>
<div class="comments-section-new __container">
<div class="comment-outer-image">
<img src="<?php
echo $user->Image;
?>
">
</div>
<textarea id="comment-input"></textarea>
<button type="submit" id="comment-input-submit">Pievienot</button>
<div class="__clear-floats"></div>
</div>
</div>
<?php
}
