ken-muturi

WITH total_loans AS (
    SELECT 
        branch_id, 
        SUM(amount) AS amount
    FROM loans
    WHERE disbursement_date::date BETWEEN '2025-08-01' AND DATE '2025-08-12'
    GROUP BY branch_id
),
cycles_summary AS (
    SELECT 

ken-muturi

Jekyll & Liquid Cheatsheet

A list of the most common functionalities in Jekyll (Liquid). You can use Jekyll with GitHub Pages, just make sure you are using the proper version.

Running

Running a local server for testing purposes:

ken-muturi

Jekyll CMSs / Editors

• Siteleaf
• CloudCannon
• Prose.io
• Forestry.io
• DatoCMS
• BowTie.io
• GitHub
• jekyll-admin

ken-muturi

	public function xml()
	{
		$url = '';
		$this->load->helper('curl');
		$response = curl::get("{$url}:8080/services/user/devices.xml");
		
		$devices = new SimpleXMLElement($response);
		util::printr( $devices );
		foreach ($devices->id as $device)
		{

ken-muturi

<?php

/**
 * This class contains a collection of useful functions used all over the place
 * */
class Util
{
	/**
     * Generate a random string
     * @param  integer $xters string length

ken-muturi

<?php

class Curl 
{
    var $headers;
    var $user_agent;
    var $compression;
    var $cookie_file;
    var $proxy;
    

ken-muturi

<?php
preg_match_all("/\/([^\/]+)\//i", $_SERVER['REQUEST_URI'], $match);

define('REQUEST_URI', $_SERVER['REQUEST_URI']);

define('BASE_DIR', $match[1][0] . '/');

define ('FS_PATH', str_replace('//', '/', $_SERVER['DOCUMENT_ROOT'] . '/' . BASE_DIR));

define ('BASE_URL', 'http://' . str_replace('//', '/', $_SERVER['SERVER_NAME'] . '/' . BASE_DIR));

ken-muturi

<?php
require("../config.php");
require("../util.php");

if( ! isset( $_SERVER['PHP_AUTH_DIGEST'] ) || empty($_SERVER['PHP_AUTH_DIGEST']) )
{
	http_response_code(401);
	header("HTTP/1.1 401 Unauthorized");
	header('WWW-Authenticate: Digest realm="'. $realm .'",qop="auth",nonce="'.uniqid().'",opaque="'. md5($realm) .'"');

ken-muturi

<?php
class Util 
{   
    public static $realm = 'PHP ODK Aggregate';
    public static $users = [
        'admin' => 'mypass', 
        'guest' => 'guest'
    ];

    // function to parse the http auth header

ken-muturi

<?php
require("../config.php");
require("../util.php");

if ( ! empty($_FILES) )
{
    header('Server: Apache-Coyote/1.1');
    header('Content-Type: application/xml;charset=UTF-8');
    header( "Date: ".date('r'));
    header('Content-Length: 1000000');