public function runTags($tag)
{
$query = Image::query();
$query->join('imagetag', 'image.image_id', '=', 'imagetag.image_id')->join('tag', 'imagetag.tag_id', '=', 'tag.tag_id')->join('location', 'image.location_id', '=', 'location.location_id')->select('image.image_id', 'thumbnail_url', 'standard_url', 'count_comment', 'count_likes', 'posted_at', 'link_url', 'author_image_url', 'author_name', 'author_link_url', 'source_id', 'location.location_id', 'image.created_at', 'image.updated_at', 'tag.tag_id', 'tag', 'pull_from_ig', 'name', 'latitude', 'longitude')->distinct()->where('tag.tag', $tag)->orderBy('image.image_id', 'DESC');
$images = $query->get();
return View::make('tag')->with(array('tag' => $tag, 'querys' => $images));
}
function getImageList($offset = 0, $limit = null, $size = 0)
{
$qry = 'SELECT image.* ' . 'FROM image ' . 'WHERE portfolio_id = %d ' . 'AND size = %d ' . 'ORDER BY created DESC ';
if ($offset > 0 && !is_null($limit)) {
if ($offset) {
if (common_config('db', 'type') == 'pgsql') {
$qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
} else {
$qry .= ' LIMIT ' . $offset . ', ' . $limit;
}
}
}
$image = new Image();
$image->query(sprintf($qry, $this->id, $size));
return $image;
}
<?php
header("Content-type:text/html;charset=utf-8");
require_once "../web.config.php";
require_once $realLibPath . "model/image.model.php";
require_once $realLibPath . "model/dict.model.php";
$img = new Image();
$id = $_POST['id'];
echo "我的id：" . $id;
//$dataArray=$article->query(array("id"=>6),array())[0];
//echo $dataArray;
$dataArray = current($img->query(array("ID" => $id), array()));
$imgCatArray = $img->getImgCat();
//var_dump($dataArray);
//@$currentPage = $_POST['currentPage'];
$imgArray = $img->query(array(), array());
$dict = new Dict();
$tplb = $dict->query(array("lxjp" => "tplb"), array("code", "name"));
//var_dump($tplb);
?>
<style>
#tab2 li{
float:left;
margin:5px;
}
#tab2 li span{
position:absolute;
left:70px;
top:70px;
}
#tab2 li img{
public function postData()
{
$query = Image::query();
if (Input::has('tag')) {
$tag = Input::get('tag');
$query->join('imagetag', 'image.image_id', '=', 'imagetag.image_id')->join('tag', 'imagetag.tag_id', '=', 'tag.tag_id')->join('location', 'image.location_id', '=', 'location.location_id')->select('image.image_id', 'thumbnail_url', 'standard_url', 'count_comment', 'count_likes', 'posted_at', 'link_url', 'author_image_url', 'author_name', 'author_link_url', 'source_id', 'location.location_id', 'image.created_at', 'image.updated_at', 'tag.tag_id', 'tag', 'pull_from_ig', 'name', 'latitude', 'longitude')->distinct()->where('tag.tag', $tag)->orderBy('image.image_id', 'DESC')->take(50);
}
$images = $query->get();
return Response::json($images);
}
public function bloc_gestion()
{
$image = new Image();
$query = "select * from {$image->table} where {$this->typeobjet}='{$this->idobjet}' order by classement";
$resul = $image->query($query);
while ($resul && ($row = $image->fetch_object($resul))) {
$imagedesc = new Imagedesc();
$imagedesc->charger($row->id, $this->lang);
?>
<form action="<?php
echo $this->nompageadmin;
?>
" method="post">
<input type="hidden" name="action" value="modifierphoto" />
<input type="hidden" name="id_photo" value="<?php
echo $row->id;
?>
" />
<input type="hidden" name="id" value="<?php
echo $this->idobjet;
?>
" />
<input type="hidden" name="lang" value="<?php
echo $this->lang;
?>
" />
<?php
$this->form_hidden_fieds();
?>
<ul>
<li class="lignesimple">
<div class="cellule_designation" style="height:208px;"> </div>
<div class="cellule_photos" style="height:200px; overflow:hidden;"><a href="<?php
echo $this->chemin_objet($row->fichier);
?>
" target="_blank"><img src="../fonctions/redimlive.php?type=<?php
echo $this->typeobjet;
?>
&nomorig=<?php
echo $row->fichier;
?>
&width=&height=200&opacite=&nb=" border="0" /></a></div>
<div class="cellule_supp"><a onclick="return confirm('<?php
echo trad('Supprimer définitivement cette image ?', 'admin');
?>
');" href="<?php
echo $this->url_page_admin();
?>
&id_photo=<?php
echo $row->id;
?>
&action=supprimerphoto"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></div>
</li>
<li class="lignesimple">
<div class="cellule_designation" style="height:30px;"><?php
echo trad('Titre', 'admin');
?>
</div>
<div class="cellule">
<input type="text" name="titre_photo" style="width:219px;" class="form" value="<?php
echo htmlspecialchars($imagedesc->titre);
?>
" />
</div>
</li>
<li class="lignesimple">
<div class="cellule_designation" style="height:50px;"><?php
echo trad('Chapo', 'admin');
?>
</div>
<div class="cellule"><textarea name="chapo_photo" rows="2"class="form" style="width:219px;"><?php
echo $imagedesc->chapo;
?>
</textarea></div>
</li>
<li class="lignesimple">
<div class="cellule_designation" style="height:65px;"><?php
echo trad('Description', 'admin');
?>
</div>
<div class="cellule"><textarea name="description_photo" class="form" rows="3"><?php
echo $imagedesc->description;
?>
</textarea></div>
</li>
<li class="lignesimple">
<div class="cellule_designation" style="height:30px;"><?php
echo trad('Classement', 'admin');
?>
</div>
<div class="cellule">
<div class="classement">
<a href="<?php
echo $this->url_page_admin() . "&id_photo=" . $row->id . "&action=modclassementphoto&type=M";
?>
"><img src="gfx/up.gif" border="0" /></a></div>
<div class="classement">
<a href="<?php
echo $this->url_page_admin() . "&id_photo=" . $row->id . "&action=modclassementphoto&type=D";
?>
"><img src="gfx/dn.gif" border="0" /></a></div>
</div>
</li>
<li class="lignesimple">
<div class="cellule_designation" style="height:30px;"> </div>
<div class="cellule" style="height:30px; border-bottom: 1px dotted #9DACB6"><input type="submit" value="<?php
echo trad('Enregistrer', 'admin');
?>
" /></div>
</li>
</ul>
</form>
<?php
}
}
public function testJson()
{
$query = Image::query();
$query->join('imagetag', 'image.image_id', '=', 'imagetag.image_id')->join('tag', 'imagetag.tag_id', '=', 'tag.tag_id')->join('location', 'image.location_id', '=', 'location.location_id')->select('image.image_id', 'thumbnail_url', 'standard_url', 'count_comment', 'count_likes', 'posted_at', 'link_url', 'author_image_url', 'author_name', 'author_link_url', 'source_id', 'location.location_id', 'image.created_at', 'image.updated_at', 'tag.tag_id', 'tag', 'pull_from_ig', 'name', 'latitude', 'longitude')->distinct()->where('tag.tag', 'khaokho')->orderBy('image.image_id', 'DESC')->take(50);
$images = $query->get();
echo $images;
return View::make('test');
}
<?php
require_once "../web.config.php";
require_once $realLibPath . "model/image.model.php";
$array = array("status" => "Y");
$array2 = array();
$img = new Image();
$imgArray = $img->query($array, $array2);
//echo "length:".$virtualAdminPath.length;
?>
<script type="text/javascript" src="/htdocs/admin/res/jquery-1.11.3.min.js"></script>
<style type="text/css">
.imgSelect{
border-style:solid;
border-color:#F00;
}
</style>
<div class="am-u-sm-7">
<table class="am-table am-table-default">
<tr>
<?php
$i = 0;
foreach ($imgArray as $item) {
if ($i < 5) {
$i++;
//显示td
?>
<td><img height="100" class="home_imageinfo_seclect" width="100" src="<?php
echo $virtualAdminPath . $item['URL'];
?>
"/><div><?php
function liste_produits($rubrique, $critere, $order, $alpha)
{
$produit = new Produit();
$produitdesc = new Produitdesc();
if ($alpha == "alpha") {
$query = "select p.* from {$produit->table} p LEFT JOIN {$produitdesc->table} pd ON pd.produit = p.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where p.rubrique=\"{$rubrique}\" order by pd.{$critere} {$order}";
} else {
$query = "select * from {$produit->table} where rubrique=\"{$rubrique}\" order by {$critere} {$order}";
}
$resul = $produit->query($query);
$i = 0;
while ($resul && ($row = $produit->fetch_object($resul))) {
$produit->charger($row->ref);
$produitdesc = new Produitdesc();
$produitdesc->charger($row->id);
if (!$produitdesc->affichage_back_office_permis()) {
continue;
}
$fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce");
$image = new Image();
$query_image = "select * from {$image->table} where produit=\"" . $row->id . "\" order by classement limit 0,1";
$resul_image = $image->query($query_image);
$row_image = $image->fetch_object($resul_image);
?>
<ul class="<?php
echo $fond;
?>
">
<li><div class="vignette"><?php
if ($row_image) {
?>
<img src="../fonctions/redimlive.php?nomorig=<?php
echo $row_image->fichier;
?>
&type=produit&width=51&height=51&exact=1" title="<?php
echo $produit->ref;
?>
" /><?php
}
?>
</div></li>
<li style="width:61px;"><span class="texte_noedit" title="<?php
echo $row->ref;
?>
"><?php
echo substr($row->ref, 0, 9);
if (strlen($row->ref) > 9) {
echo " ...";
}
?>
</span></li>
<li style="width:225px;"><span id="titreprod_<?php
echo $row->id;
?>
" <?php
if ($produitdesc->est_langue_courante()) {
echo 'class="texte_edit"';
}
?>
><?php
echo substr($produitdesc->titre, 0, 35);
if (strlen($produitdesc->titre) > 35) {
echo " ...";
}
?>
</span></li>
<li style="width:39px;"><span id="stock_<?php
echo $row->id;
?>
" class="texte_edit"><?php
echo $row->stock;
?>
</span></li>
<li style="width:30px;"><span id="prix_<?php
echo $row->id;
?>
" class="texte_edit"><?php
echo $row->prix;
?>
</span></li>
<li style="width:68px;"><span id="prix2_<?php
echo $row->id;
?>
" class="texte_edit"><?php
echo $row->prix2;
?>
</span></li>
<li style="width:64px;"><input id="promo_<?php
echo $row->id;
?>
" type="checkbox" name="promo[]" class="sytle_checkbox" onchange="checkvalues('promo','<?php
echo $row->id;
?>
')" <?php
if ($row->promo) {
?>
checked="checked" <?php
}
?>
/></li>
<li style="width:64px;"><input type="checkbox" id="nouveaute_<?php
echo $row->id;
?>
" name="nouveaute[]" class="sytle_checkbox" onchange="checkvalues('nouveaute','<?php
echo $row->id;
?>
')" <?php
if ($row->nouveaute) {
?>
checked="checked" <?php
}
?>
/></li>
<li style="width:53px;"><input type="checkbox" id="prod_ligne_<?php
echo $row->id;
?>
" name="ligne[]" class="sytle_checkbox" onchange="checkvalues('ligneprod','<?php
echo $row->id;
?>
')" <?php
if ($row->ligne) {
?>
checked="checked" <?php
}
?>
/></li>
<li style="width:41px;"><a href="produit_modifier.php?ref=<?php
echo $produit->ref;
?>
&rubrique=<?php
echo $produit->rubrique;
?>
" class="txt_vert_11"><?php
echo trad('editer', 'admin');
?>
</a></li>
<li style="width:78px; text-align:center;">
<div class="bloc_classement">
<div class="classement">
<a href="produit_modifier.php?ref=<?php
echo $produit->id;
?>
&action=modclassement&parent=<?php
echo $rubrique;
?>
&type=M"><img src="gfx/up.gif" border="0" /></a>
</div>
<div class="classement"><span id="classementprod_<?php
echo $produit->id;
?>
" class="classement_edit"><?php
echo $row->classement;
?>
</span></div>
<div class="classement">
<a href="produit_modifier.php?ref=<?php
echo $produit->id;
?>
&action=modclassement&parent=<?php
echo $rubrique;
?>
&type=D"><img src="gfx/dn.gif" border="0" /></a>
</div>
</div>
</li>
<li style="width:37px; text-align:center;"><a href="javascript:supprimer_produit('<?php
echo $produit->ref;
?>
','<?php
echo $rubrique;
?>
')"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li>
</ul>
<?php
}
}
/**
*
* Return an array of content for the current folder
*
* @param string $dossier id of the current folder
* @param string $critere order by clause
* @param string $order ASC or DESC
* @param string $alpha if order is alpha pu "alpha"
* @return Array
*/
public function getList($dossier, $critere, $order, $alpha)
{
$return = array();
if ($alpha == "alpha") {
$query = "select c.id, c.dossier, c.ligne, c.classement from " . Contenu::TABLE . " p LEFT JOIN " . Contenudesc::TABLE . " pd ON cd.contenu = c.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where c.dossier=\"{$dossier}\" order by cd.{$critere} {$order}";
} else {
$query = "select id, dossier, ligne, classement from " . Contenu::TABLE . " where dossier=\"{$dossier}\" order by {$critere} {$order}";
}
$resul = $this->query($query);
$i = 0;
while ($resul && ($row = $this->fetch_object($resul))) {
$contenudesc = new Contenudesc();
$contenudesc->charger($row->id);
if (!$contenudesc->affichage_back_office_permis()) {
continue;
}
$image = new Image();
$query_image = "select * from " . Image::TABLE . " where contenu=\"" . $row->id . "\" order by classement limit 0,1";
$resul_image = $image->query($query_image);
$row_image = $image->fetch_object($resul_image, 'image');
$return[] = array("id" => $row->id, "dossier" => $row->dossier, "ligne" => $row->ligne, "classement" => $row->classement, "titre" => $contenudesc->titre, "langue_courante" => $contenudesc->est_langue_courante(), "image" => array("fichier" => $row_image->fichier));
}
return $return;
}
*/
if (isset($_FILES['image']) && isset($_POST["image-upload"])) {
$Image = new Image();
$Image->uploadTo = $baseDir . 'images/posts/';
$uploadedImage = $Image->upload($_FILES['image']);
if ($uploadedImage) {
$path = $Image->resize();
try {
//Set the appropriate hour
if ($_POST["half"] == 'PM') {
$hour = $_POST["image-hour"] == 12 ? $hour = 12 : $_POST["image-hour"] + 12;
} else {
$hour = $_POST["image-hour"];
}
$Image->setPath($path, $url);
$Image->setDescription($_POST["image-description"]);
$Image->setLocation($_POST["image-location"]);
$Image->setMonth($_POST["image-month"]);
$Image->setDay($_POST["image-day"]);
$Image->setYear($_POST["image-year"]);
$Image->setHour($_POST["image-hour"]);
$Image->setMinute($_POST["image-minute"]);
$Image->setPrivacy($_POST["image-privacy"]);
$Image->query($user["id"], $user["username"], $user["name"]);
echo '1';
} catch (Exception $e) {
echo $e->getMessage();
}
}
}
}
$Image = new Image($Database);
//Prepare the facebook sql for getting photos
$fql = "SELECT src_big, created, caption FROM photo WHERE owner = me()";
$param = array('method' => 'fql.query', 'query' => $fql, 'callback' => '');
$result = $Facebook->api($param);
//Get the results
foreach ($result as $row) {
//Check to see if a video is already posted
$Statement = $Database->prepare("SELECT id FROM statuses WHERE month = ? AND day = ? AND year = ? AND calendar_id = ?");
$Statement->execute(array(gmdate("m", $row["created"]), gmdate("d", $row["created"]), gmdate("Y", $row["created"]), $calendar["id"]));
$rowCount = $Statement->rowCount();
//If it is then skip
if ($rowCount != 0) {
continue;
}
//Update the database with the photos
try {
$Image->setUrlPath($row["src_big"]);
$Image->setContent(substr($row["caption"], 0, 900) . ' Photo taken ' . gmdate("m-d-Y", $row["created"]));
$Image->setCategory('image');
$Image->setTags($row["caption"]);
$Image->setMonth(gmdate("m", $row["created"]));
$Image->setDay(gmdate("d", $row["created"]));
$Image->setYear(gmdate("Y", $row["created"]));
$Image->setLocation('');
$Image->setCalendarId($calendar["id"]);
$Image->query($user["id"]);
} catch (Exception $e) {
echo $e->getMessage();
}
}
/**
*
* Return an array of product for the current category
*
* @param string $rubrique id of the current category
* @param string $critere order by clause
* @param string $order ASC or DESC
* @param string $alpha if order is alpha pu "alpha"
* @return Array
*/
public function getList($rubrique, $critere, $order, $alpha)
{
$return = array();
if ($alpha == "alpha") {
$query = "select p.id, p.ref, p.rubrique, p.stock, p.prix, p.prix2, p.promo, p.ligne, p.nouveaute, p.classement, p.tva from " . Produit::TABLE . " p LEFT JOIN " . Produitdesc::TABLE . " pd ON pd.produit = p.id and lang=" . ActionsLang::instance()->get_id_langue_courante() . " where p.rubrique=\"{$rubrique}\" order by pd.{$critere} {$order}";
} else {
$query = "select id, ref, rubrique, stock, prix, prix2, promo, ligne, nouveaute, classement, tva from " . Produit::TABLE . " where rubrique=\"{$rubrique}\" order by {$critere} {$order}";
}
$resul = $this->query($query);
$i = 0;
while ($resul && ($row = $this->fetch_object($resul))) {
$produitdesc = new Produitdesc();
$produitdesc->charger($row->id);
if (!$produitdesc->affichage_back_office_permis()) {
continue;
}
$image = new Image();
$query_image = "select * from " . Image::TABLE . " where produit=\"" . $row->id . "\" order by classement limit 0,1";
$resul_image = $image->query($query_image);
$row_image = $image->fetch_object($resul_image, 'image');
$return[] = array("ref" => $row->ref, "id" => $row->id, "rubrique" => $row->rubrique, "stock" => $row->stock, "variants" => $this->getVariants($row->id), "prix" => $row->prix, "prix2" => $row->prix2, "promo" => $row->promo, "ligne" => $row->ligne, "nouveaute" => $row->nouveaute, "classement" => $row->classement, "tva" => $row->tva, "titre" => $produitdesc->titre, "langue_courante" => $produitdesc->est_langue_courante(), "image" => array("fichier" => $row_image->fichier));
}
return $return;
}