1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351:
<?php
defined('ICMS_ROOT_PATH') or die("ImpressCMS root path not defined");
class icms_data_avatar_Handler extends icms_core_ObjectHandler {
public function &create($isNew = true) {
$avatar = new icms_data_avatar_Object();
if ($isNew) {
$avatar->setNew();
}
return $avatar;
}
public function &get($id) {
$avatar = false;
$id = (int) $id;
if ($id > 0) {
$sql = "SELECT * FROM " . $this->db->prefix('avatar')
. " WHERE avatar_id='" . $id . "'";
if (!$result = $this->db->query($sql)) {
return false;
}
$numrows = $this->db->getRowsNum($result);
if ($numrows == 1) {
$avatar = new icms_data_avatar_Object();
$avatar->assignVars($this->db->fetchArray($result));
return $avatar;
}
}
return $avatar;
}
public function insert(&$avatar) {
if (!is_a($avatar, 'icms_data_avatar_Object')) {
return false;
}
if (!$avatar->isDirty()) {
return true;
}
if (!$avatar->cleanVars()) {
return false;
}
foreach ($avatar->cleanVars as $k => $v) {
${$k} = $v;
}
if ($avatar->isNew()) {
$avatar_id = $this->db->genId('avatar_avatar_id_seq');
$sql = sprintf(
"INSERT INTO %s (avatar_id, avatar_file, avatar_name, avatar_created, avatar_mimetype, avatar_display, avatar_weight, avatar_type)
VALUES ('%u', %s, %s, '%u', %s, '%u', '%u', %s)",
$this->db->prefix('avatar'),
(int) $avatar_id,
$this->db->quoteString($avatar_file),
$this->db->quoteString($avatar_name),
time(),
$this->db->quoteString($avatar_mimetype),
(int) $avatar_display,
(int) $avatar_weight,
$this->db->quoteString($avatar_type)
);
} else {
$sql = sprintf(
"UPDATE %s SET
avatar_file = %s,
avatar_name = %s,
avatar_created = '%u',
avatar_mimetype= %s,
avatar_display = '%u',
avatar_weight = '%u',
avatar_type = %s
WHERE avatar_id = '%u'",
$this->db->prefix('avatar'),
$this->db->quoteString($avatar_file),
$this->db->quoteString($avatar_name),
(int) $avatar_created,
$this->db->quoteString($avatar_mimetype),
(int) $avatar_display,
(int) $avatar_weight,
$this->db->quoteString($avatar_type),
(int) $avatar_id
);
}
if (!$result = $this->db->query($sql)) {
return false;
}
if (empty($avatar_id)) {
$avatar_id = $this->db->getInsertId();
}
$avatar->assignVar('avatar_id', $avatar_id);
return true;
}
public function delete(&$avatar) {
if (!is_a($avatar, 'icms_data_avatar_Object')) {
return false;
}
$id = (int) $avatar->getVar('avatar_id');
$sql = sprintf(
"DELETE FROM %s WHERE avatar_id = '%u'",
$this->db->prefix('avatar'), $id
);
if (!$result = $this->db->query($sql)) {
return false;
}
$sql = sprintf(
"DELETE FROM %s WHERE avatar_id = '%u'",
$this->db->prefix('avatar_user_link'), $id
);
$result = $this->db->query($sql);
return true;
}
public function &getObjects($criteria = null, $id_as_key = false) {
$ret = array();
$limit = $start = 0;
$sql = "SELECT a.*, COUNT(u.user_id) AS count FROM "
. $this->db->prefix('avatar') . " a LEFT JOIN "
. $this->db->prefix('avatar_user_link') . " u ON u.avatar_id=a.avatar_id";
if (isset($criteria) && is_subclass_of($criteria, 'icms_db_criteria_Element')) {
$sql .= " " . $criteria->renderWhere();
$sql .= " GROUP BY a.avatar_id ORDER BY avatar_weight, avatar_id";
$limit = $criteria->getLimit();
$start = $criteria->getStart();
}
$result = $this->db->query($sql, $limit, $start);
if (!$result) {
return $ret;
}
while ($myrow = $this->db->fetchArray($result)) {
$avatar = new icms_data_avatar_Object();
$avatar->assignVars($myrow);
$avatar->setUserCount($myrow['count']);
if (!$id_as_key) {
$ret[] =& $avatar;
} else {
$ret[$myrow['avatar_id']] =& $avatar;
}
unset($avatar);
}
return $ret;
}
public function getCount($criteria = null) {
$sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('avatar');
if (isset($criteria) && is_subclass_of($criteria, 'icms_db_criteria_Element')) {
$sql .= ' ' . $criteria->renderWhere();
}
if (!$result =& $this->db->query($sql)) {
return 0;
}
list($count) = $this->db->fetchRow($result);
return $count;
}
public function addUser($avatar_id, $user_id) {
$avatar_id = (int) $avatar_id;
$user_id = (int) ($user_id);
if ($avatar_id < 1 || $user_id < 1) {
return false;
}
$sql = sprintf(
"DELETE FROM %s WHERE user_id = '%u'",
$this->db->prefix('avatar_user_link'), $user_id
);
$this->db->query($sql);
$sql = sprintf(
"INSERT INTO %s (avatar_id, user_id) VALUES ('%u', '%u')",
$this->db->prefix('avatar_user_link'), $avatar_id, $user_id
);
if (!$result =& $this->db->query($sql)) {
return false;
}
return true;
}
public function getUser(&$avatar) {
$ret = array();
if (!is_a($avatar, 'icms_data_avatar_Object')) {
return false;
}
$sql = "SELECT user_id FROM " . $this->db->prefix('avatar_user_link')
. " WHERE avatar_id='". (int) $avatar->getVar('avatar_id') . "'";
if (!$result = $this->db->query($sql)) {
return $ret;
}
while ($myrow = $this->db->fetchArray($result)) {
$ret[] =& $myrow['user_id'];
}
return $ret;
}
public function getList($avatar_type = null, $avatar_display = null) {
$criteria = new icms_db_criteria_Compo();
if (isset($avatar_type)) {
$avatar_type = ($avatar_type == 'C') ? 'C' : 'S';
$criteria->add(new icms_db_criteria_Item('avatar_type', $avatar_type));
}
if (isset($avatar_display)) {
$criteria->add(new icms_db_criteria_Item('avatar_display', (int) $avatar_display));
}
$avatars =& $this->getObjects($criteria, true);
$ret = array('blank.gif' => _NONE);
foreach (array_keys($avatars) as $i) {
$ret[$avatars[$i]->getVar('avatar_file')] = $avatars[$i]->getVar('avatar_name');
}
return $ret;
}
static public function getListFromDir($avatar_dir="") {
$avatars = array();
if ($avatar_dir != "") {
$avatars = icms_core_Filesystem::getFileList(ICMS_ROOT_PATH . "/images/avatar/" . $avatar_dir . "/", $avatar_dir . "/", array('gif', 'jpg', 'png'));
} else {
$avatars = icms_core_Filesystem::getFileList(ICMS_ROOT_PATH . "/images/avatar/", '', array('gif', 'jpg', 'png'));
}
return $avatars;
}
static public function getAllFromDir() {
$avatars = array();
$dirlist = array();
$dirlist = icms_core_Filesystem::getDirList(ICMS_ROOT_PATH . "/images/avatar/");
if (count($dirlist) > 0) {
foreach ($dirlist as $dir) {
$avatars[$dir] =& icms_core_Filesystem::getFileList(ICMS_ROOT_PATH . "/images/avatar/" . $dir . "/", $dir . "/", array('gif', 'jpg', 'png'));
}
} else {
return false;
}
return $avatars;
}
}