public function count($type = "posts")
{
if (isLang()) {
$year = isYear(segment(1)) ? segment(1) : FALSE;
$month = isMonth(segment(2)) ? segment(2) : FALSE;
$day = isDay(segment(3)) ? segment(3) : FALSE;
} else {
$year = isYear(segment(0)) ? segment(0) : FALSE;
$month = isMonth(segment(1)) ? segment(1) : FALSE;
$day = isDay(segment(2)) ? segment(2) : FALSE;
}
if ($type === "posts") {
if ($year and $month and $day) {
$count = $this->Db->countBySQL("Language = '{$this->language}' AND Year = '{$year}' AND Month = '{$month}' AND Day = '{$day}' AND Situation = 'Active'", $this->table);
} elseif ($year and $month) {
$count = $this->Db->countBySQL("Language = '{$this->language}' AND Year = '{$year}' AND Month = '{$month}' AND Situation = 'Active'", $this->table);
} elseif ($year) {
$count = $this->Db->countBySQL("Language = '{$this->language}' AND Year = '{$year}' AND Situation = 'Active'", $this->table);
} else {
$count = $this->Db->countBySQL("Language = '{$this->language}' AND Situation = 'Active'", $this->table);
}
} elseif ($type === "comments") {
$count = 0;
} elseif ($type === "tag") {
$data = $this->getByTag(segment(3));
$count = count($data);
} elseif ($type === "categories") {
$data = $this->getByCategory(segment(3));
$count = count($data);
}
return isset($count) ? $count : 0;
}
private function limit($type = "posts")
{
$start = 0;
if ($type === "posts") {
if (isLang()) {
if (segment(2) === "page" and segment(3) > 0) {
$start = segment(3) * _maxLimit - _maxLimit;
}
} else {
if (segment(1) === "page" and segment(2) > 0) {
$start = segment(2) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$count = $this->Blog_Model->count();
$URL = path("blog/page/");
} elseif ($type === "categories") {
if (isLang()) {
if (segment(2) === "category" and segment(3) !== "page" and segment(4) === "page" and segment(5) > 0) {
$start = segment(5) * _maxLimit - _maxLimit;
}
} else {
if (segment(1) === "category" and segment(2) !== "page" and segment(3) === "page" and segment(4) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$URL = path("blog/category/" . segment(3) . "/page");
$count = $this->Blog_Model->count("categories");
} elseif ($type === "day") {
if (isLang()) {
if (isYear(segment(2)) and isMonth(segment(3)) and isDay(segment(4)) and segment(5) === "page" and segment(6) > 0) {
$start = segment(6) * _maxLimit - _maxLimit;
}
} else {
if (isYear(segment(1)) and isMonth(segment(2)) and isDay(segment(3)) and segment(4) === "page" and segment(5) > 0) {
$start = segment(5) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$count = $this->Blog_Model->count("posts");
$URL = path("blog/" . segment(2) . "/" . segment(3) . "/" . segment(4) . "/page/");
} elseif ($type === "month") {
if (isLang()) {
if (isYear(segment(2)) and isMonth(segment(3)) and segment(4) === "page" and segment(5) > 0) {
$start = segment(5) * _maxLimit - _maxLimit;
}
} else {
if (isYear(segment(1)) and isMonth(segment(2)) and segment(3) === "page" and segment(4) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$count = $this->Blog_Model->count("posts");
$URL = path("blog/" . segment(2) . "/" . segment(3) . "/page/");
} elseif ($type === "year") {
if (isLang()) {
if (isYear(segment(2)) and segment(3) === "page" and segment(4) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
} else {
if (isYear(segment(1)) and segment(2) === "page" and segment(3) > 0) {
$start = segment(3) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$count = $this->Blog_Model->count("posts");
$URL = path("blog/" . segment(2) . "/page/");
} elseif ($type === "tag") {
if (isLang()) {
if (segment(2) === "tag" and segment(3) and segment(4) === "page" and segment(5) > 0) {
$start = segment(5) * _maxLimit - _maxLimit;
}
} else {
if (segment(1) === "tag" and segment(2) and segment(3) === "page" and segment(4) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
}
$limit = $start . ", " . _maxLimit;
$count = $this->Blog_Model->count("tag");
$URL = path("blog/tag/" . segment(3) . "/page/");
}
if ($count > _maxLimit) {
$this->pagination = paginate($count, _maxLimit, $start, $URL);
} else {
$this->pagination = NULL;
}
return $limit;
}
// yearEntered;yearLeft;null;null;FullName;Esq;Deceased;initials;FirstName;LastName;DOB;rollNo
array_shift($argv);
$pcount = 0;
$persons = $forms = $links = $doubles = $uniques = [];
foreach ($argv as $file) {
// распарсим загруженный файл
$lines = file($file);
$count = count($lines);
for ($i = 0; $i < $count; $i++) {
$pcount++;
//$line = iconv( "windows-1251", "UTF-8", $lines[$i] );
$el = preg_split("/[;\n\r]/", $lines[$i], -1);
for ($j = 0; $j < count($el); $j++) {
$el[$j] = trim($el[$j]);
}
if (!isYear($el[0]) || !isYear($el[0]) || !isDOB($el[10]) || count($el) != 13) {
print "Error in {$file} line {$i} " . print_r($el, true);
exit;
}
if ($el[0] && $el[1] && $el[1] < $el[0]) {
print "Error in {$file} line {$i} " . print_r($el, true);
exit;
}
$el[12] = gen_uuid();
$persons[] = $el;
}
}
$uniques = [];
// clean the tables
//$sql = "DELETE FROM `resources` WHERE type='person' AND id IN (SELECT `source` FROM `links` WHERE `type` = 'pupil');";
//$sql .= "DELETE FROM `persons_keys` WHERE personId IN (SELECT `source` FROM `links` WHERE `type` = 'pupil');";
private function limit($type = "posts")
{
$start = 0;
$count = $this->Blog_Model->count("posts");
if ($type === "posts") {
if (segment(1, isLang()) === "page" and segment(2, isLang()) > 0) {
$start = segment(2, isLang()) * _maxLimit - _maxLimit;
}
$URL = path("blog/page/");
} elseif ($type === "categories") {
if (segment(1, isLang()) === "category" and segment(2, isLang()) !== "page" and segment(3, isLang()) === "page" and segment(4, isLang()) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
$URL = path("blog/category/" . segment(3, isLang()) . "/page");
$count = $this->Blog_Model->count("categories");
} elseif ($type === "day") {
if (isYear(segment(1, isLang())) and isMonth(segment(2, isLang())) and isDay(segment(3, isLang())) and segment(4, isLang()) === "page" and segment(5, isLang()) > 0) {
$start = segment(5) * _maxLimit - _maxLimit;
}
$URL = path("blog/" . segment(2, isLang()) . "/" . segment(3, isLang()) . "/" . segment(4, isLang()) . "/page/");
} elseif ($type === "month") {
if (isYear(segment(1, isLang())) and isMonth(segment(2, isLang())) and segment(3, isLang()) === "page" and segment(4, isLang()) > 0) {
$start = segment(4) * _maxLimit - _maxLimit;
}
$URL = path("blog/" . segment(2, isLang()) . "/" . segment(3, isLang()) . "/page/");
} elseif ($type === "year") {
if (isYear(segment(1, isLang())) and segment(2, isLang()) === "page" and segment(3, isLang()) > 0) {
$start = segment(3, isLang()) * _maxLimit - _maxLimit;
}
$URL = path("blog/" . segment(2) . "/page/");
} elseif ($type === "tag") {
if (segment(1, isLang()) === "tag" and segment(2, isLang()) and segment(3, isLang()) === "page" and segment(4, isLang()) > 0) {
$start = segment(4, isLang()) * _maxLimit - _maxLimit;
}
$count = $this->Blog_Model->count("tag");
$URL = path("blog/tag/" . segment(2, isLang()) . "/page/");
}
$limit = $start . ", " . _maxLimit;
$this->pagination = $count > _maxLimit ? paginate($count, _maxLimit, $start, $URL) : NULL;
return $limit;
}
