Georgi.Budinov.com in English

The CArrayDataProvider problem of Yii

Georgi Budinov — Sun, 18 Sep 2011 19:19:58 +0000

Recently I started digging in the YiiFramework. The first things I want to know about the framework were the basics – how the MVC is accomplished, database connections, ready to use component and so on. As the development team is actually the team that was engaged with the Prado framework before, I assumed that Yii will be very similar which actually is not very true. Well I won’t talk now about all the stuff I noticed and I will go straight to one of the first things I got a little irritating.

The thing is that all core components are bind or connected in some way to Active Records which is something I don’t use. That is a choice I have made and you can not sue me for that. I don’t like the concept and prefer to make my own queries – perhaps this is some for another post.

This is the case with the CArrayDataProvider. Actually they have CActiveDataProvider which is bind to AR and working like a charm. It is making two queries one with the data and one with the count of rows so you get a nice pagination component when using with a gridview or listview. Well this is not the case with CArrayDataProvider. They didn’t assume that someone like me would want to make himself the two queries and set the current page, total count of raws and pass the excerpt of them. What they actually do is using the array_slice method to get the needed portion of the page when using with a CPager. Well I can see that this has been done in the old ages. The component needs all the records from the database and will cut off the needed portion. This is insane. That is why I modified it a little bit … yeah it is almost nothing so it suits my needs. Just extend the CArrayDataProvider and include it.

class ArrayDataProvider extends CArrayDataProvider
{
	/**
	 * Fetches the data from the persistent data storage.
	 * @return array list of data items
	 */
	protected function fetchData()
	{
		if(($sort=$this->getSort())!==false && ($order=$sort->getOrderBy())!='')
			$this->sortData($this->getSortDirections($order));

		if(($pagination=$this->getPagination())!==false)
		{
			$pagination->setItemCount($this->getTotalItemCount());
			return $this->rawData;
			//return array_slice($this->rawData, $pagination->getOffset(), $pagination->getLimit());
		}
		else
			return $this->rawData;
	}
}

Usage:

$viewData['dataProvider'] = new ArrayDataProvider(
			$array['rows'],
			array(
				'totalItemCount' => $array['count'],
				'pagination'=>array(
					'pageSize' => 10,
				),
			)
		);

Bookmark It

Hard drive lost memory headaches on an old XP machine

Georgi Budinov — Thu, 15 Sep 2011 21:27:00 +0000

Hello, it’s been a long time since my last post. I have been really busy … doing a lot of stuff … so you can expect some new stuff from me right away but please be patient. Now straight to the problem:

I have a old laptop (actually 3 years old Dell Inspiron 1520, well guarantee just dropped ) and I had problems with it for the last few months. I have partitioned the 140GB hard drive like C: – 20GB and D: – 120GB. That was decision some time ago so don’t judge me for that please. 6 months ago I noticed I am running low on C so I started trying optimize stuff, actually for that time I did a lot of tweaks like switching off hybernation, moving page file to D, reinstalling programs from C: to D: … and so on. Tried DSKCHK with no success. Tried defragmenting it – again no success because of the low free space – less than 15%. Yesterday I got really pissed with this and downloaded a piece of software – WinDirStat and started checking where are the biggest files on C: … finally I concluded that I have used actually like 5 GB of memory, have 2 GB free and the rest is missing. Then I thought ok … what is left … system restore problem ?

Noo … I turned it off 6 months ago, it is not that. But then I tried turning it on, lowering the size of system restore, restarting the laptop, turning it of and guess what … 14GB free space. WTF!? For some reason last time when I have turned it off the laptop didn’t restarted normally and these 10GB have been held in the ‘System Volume Information’ folder.

Bookmark It

PostgreSQL and network operators

Georgi Budinov — Fri, 25 Feb 2011 12:37:38 +0000

I am working on a couple of projects that require the use of PostgreSQL and I really like dealing with it. Full of features that are sometimes quite usefull. One of them is the <<= network operator.

is contained within or equals – inet ’192.168.1/24′ <<= inet ’192.168.1/24′

This way one can check if an ip is in the range of a given network. Pretty simple, yeah! But I had the need to query ip address that are not in a specific network range . Well there is no opposite operator – at least I couldn’t find one. So what I did is is the following:


SELECT COUNT(*) FROM ips WHERE  CASE WHEN ip <<= inet '192.168.1/24' THEN false ELSE true END

Bookmark It

Adding a number of random generated unique strings into db

Georgi Budinov — Wed, 05 Jan 2011 13:47:34 +0000

Today I accidentally got to a piece of code I have written long ago and really got surprised from me. I have created a not conventional solution to a interesting problem. Imagine you have to add a bunch of rows into a db table, for example promo codes, that has column holding randomly generated strings. The strings should be unique of course, so we have unique key in the db! So instead of generating the string, checking if it is already in the table and if not -> adding it to the table, I have just written this:

$j = 0;
for($i=0; $i<$count; $i++)
{
	while(true)
	{
		try
		{
			$code = str_makerand();
			$codeID = $this->addItem(
				$this->tableNameCodes,
				array('code'),
				array($code)
			);

			break;
		}
		catch(Exception $e){
			$j++;
			if($j=10) break;
		}
	}
}

Bookmark It

YouTube’s policy for inappropriate content and the embed function

Georgi Budinov — Mon, 03 Jan 2011 13:05:22 +0000

Recently I noticed something in the way YouTube manages the videos flagged as inappropriate by some users. You know such videos you want to watch but you must be logged in. This way you accept and confirm you are older than 18 years. On my facebook profile I had a post with such a video – it is embed of the video as you know. And guess what – everyone can play it. It doesn’t matter it you are logged in or not. Here is the example:

The YouTube video – http://www.youtube.com/watch?v=bJvIWGMe61E

Try this html code for the embed:

And what I am thinking is : Is this a bug or feature ?

Bookmark It

Integrating PHPList and CodeIgniter

Georgi Budinov — Sun, 31 Oct 2010 10:10:37 +0000

Hello to all. It was a busy month ,so I haven’t updated this blog for soo loong. Now I give you a small bonus . I was busy with a lot of stuff including writing a library for CodeIgniter dealing with PHPList integration. Before implementing it, I googled a lot for a ready to use library on this particular subject. No luck. So I found myself writing it for an hour and think it is pretty good in doing its job, at least for me Here is the library and enjoy.

NOTE: Have in mind that the CI and PHPLIST have a common function named “redirect”. You either need to rename that in CI or in PHPLIST.

CI))
		{
			$this->CI =& get_instance();
		}

		$rootPath = $this->CI->config->item('root_path');

		define('BULLETIN_ROOT_PATH', $rootPath.'bulletin/');

		$phplist_root_path = (defined('PHPLIST_ROOT_PATH')) ? PHPLIST_ROOT_PATH : BULLETIN_ROOT_PATH;

		// Include needed files
		include($phplist_root_path . 'admin/defaultconfig.inc');
		include($phplist_root_path . 'config/config.php');
		include($phplist_root_path . 'admin/mysql.inc');
		include($phplist_root_path . 'admin/connect.php');
    }

    /**
     *
     * @param $email
     * @param $lists
     * @return mixed
     */
    public function user_add($email, $lists = array())
    {
    	if(!$email) return false;

    	if(is_array($lists) && count($lists))
    	{
    		$userID = addNewUser($email);

    		if($userID > 0)
    		{
    			foreach($lists as $list)
    			{
    				$this->userAddToList($userID, $list);
    			}
    		}
    	}
    	else
    	{
        	return addNewUser($email);
    	}
    }

	public function get_lists()
    {
    	$results = $this->getLists();

    	return $results;
    }

	public function user_add_list($email, $list)
    {
    	if(!$email || !$list) return;

    	$userid = $this->getUserIDByEmail($email);

    	if($userid > 0)
    	{
    		$this->userAddToList($userid, $list);
    	}
    	else
    	{
    		return;
    	}
    }

	public function user_remove_list($email, $list)
    {
    	if(!$email || !$list) return;

    	$userid = $this->getUserIDByEmail($email);

    	if($userid > 0)
    	{
    		$this->userRemoveToList($userid, $list);
    	}
    	else
    	{
    		return;
    	}
    }

    /**
     *
     * @param $email
     * @return mixed
     */
    public function user_blacklist($email)
    {
    	if(!$email) return;

    	return addUserToBlackList($email);
    }

	/**
     *
     * @param $email
     * @return mixed
     */
    public function user_unblacklist($email)
    {
    	if(!$email) return;

    	$userid = $this->getUserIDByEmail($email);

    	if($userid > 0)
    	{
    		return unBlackList($userid);
    	}
    	else
    	{
    		return false;
    	}
    }

	private function getUserIDByEmail($email = '') {
	  global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;
	  if (!$email) return;

	  # workaround for integration webbler/phplist
	  if (!isset($table_prefix))
	    $table_prefix = "phplist_";

	  if (isset($tables["attribute"])) {
	    $att_table = $tables["attribute"];
	    $user_att_table = $tables["user_attribute"];
	    $usertable = $tables["user"];
	  } else {
	    $att_table = "attribute";
	    $user_att_table = "user_attribute";
	    $usertable = "user";
	  }
	  $email = mysql_real_escape_string($email, $database_connection);
	  $userid = Sql_Fetch_Row_Query("select id from {$usertable} where email = \"$email\"");
	  $id = $userid[0];

	  return $id;
	}

	private function userAddToList($id = 0, $listID = 0)
	{
		global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

		$id = intval($id);
		$listID = intval($listID);
		if(!$id || !$listID) return false;

		$query = "replace into ".$tables["listuser"]." (userid,listid,entered) values($id,$listID,now())";
	    $result = Sql_query($query);
	}

	private function userRemoveToList($id = 0, $listID = 0)
	{
		global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

		$id = intval($id);
		$listID = intval($listID);
		if(!$id || !$listID) return false;

		$query = "delete from ".$tables["listuser"]." where userid = $id and listid = $listID";
	    $result = Sql_query($query);
	}

	private function getLists()
	{
		global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

		$results = array();
		$result = Sql_query("SELECT * FROM {$tables['list']} order by listorder");
		while ($row = Sql_fetch_array($result))
		{
			$results[$row['id']] = $row;
		}

		return $results;
	}
}

/* End of file phplist_library.php */
/* Location: ./application/libraries/phplist_library.php */

/**
* CodeIgniter phplist Library
*
* CodeIgniter phplist bridge allowing adding users to lists and blacklisting them
*
* @author Georgi Budinov
* @version 1.0
* @link http://georgi.budinov.com
*/
class Phplist_library
{
public $CI;

/**
* Constructor.
*/
public function __construct()
{
global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;
if (!isset($this->CI))
{
$this->CI =& get_instance();
}

$rootPath = $this->CI->config->item(‘root_path’);

define(‘BULLETIN_ROOT_PATH’, $rootPath.’bulletin/’);

$phplist_root_path = (defined(‘PHPLIST_ROOT_PATH’)) ? PHPLIST_ROOT_PATH : BULLETIN_ROOT_PATH;

// Include needed files
include($phplist_root_path . ‘admin/defaultconfig.inc’);
include($phplist_root_path . ‘config/config.php’);
include($phplist_root_path . ‘admin/mysql.inc’);
include($phplist_root_path . ‘admin/connect.php’);
}

/**
*
* @param $email
* @param $lists
* @return mixed
*/
public function user_add($email, $lists = array())
{
if(!$email) return false;

if(is_array($lists) && count($lists))
{
$userID = addNewUser($email);

if($userID > 0)
{
foreach($lists as $list)
{
$this->userAddToList($userID, $list);
}
}
}
else
{
return addNewUser($email);
}
}

public function get_lists()
{
$results = $this->getLists();

return $results;
}

public function user_add_list($email, $list)
{
if(!$email || !$list) return;

$userid = $this->getUserIDByEmail($email);

if($userid > 0)
{
$this->userAddToList($userid, $list);
}
else
{
return;
}
}

public function user_remove_list($email, $list)
{
if(!$email || !$list) return;

$userid = $this->getUserIDByEmail($email);

if($userid > 0)
{
$this->userRemoveToList($userid, $list);
}
else
{
return;
}
}

/**
*
* @param $email
* @return mixed
*/
public function user_blacklist($email)
{
if(!$email) return;

return addUserToBlackList($email);
}

/**
*
* @param $email
* @return mixed
*/
public function user_unblacklist($email)
{
if(!$email) return;

$userid = $this->getUserIDByEmail($email);

if($userid > 0)
{
return unBlackList($userid);
}
else
{
return false;
}
}

private function getUserIDByEmail($email = ”) {
global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;
if (!$email) return;

# workaround for integration webbler/phplist
if (!isset($table_prefix))
$table_prefix = “phplist_”;

if (isset($tables["attribute"])) {
$att_table = $tables["attribute"];
$user_att_table = $tables["user_attribute"];
$usertable = $tables["user"];
} else {
$att_table = “attribute”;
$user_att_table = “user_attribute”;
$usertable = “user”;
}
$email = mysql_real_escape_string($email, $database_connection);
$userid = Sql_Fetch_Row_Query(“select id from {$usertable} where email = \”$email\”");
$id = $userid[0];

return $id;
}

private function userAddToList($id = 0, $listID = 0)
{
global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

$id = intval($id);
$listID = intval($listID);
if(!$id || !$listID) return false;

$query = “replace into “.$tables["listuser"].” (userid,listid,entered) values($id,$listID,now())”;
$result = Sql_query($query);
}

private function userRemoveToList($id = 0, $listID = 0)
{
global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

$id = intval($id);
$listID = intval($listID);
if(!$id || !$listID) return false;

$query = “delete from “.$tables["listuser"].” where userid = $id and listid = $listID”;
$result = Sql_query($query);
}

private function getLists()
{
global $tables, $table_prefix, $config, $usertable_prefix, $database_connection;

$results = array();
$result = Sql_query(“SELECT * FROM {$tables['list']} order by listorder”);
while ($row = Sql_fetch_array($result))
{
$results[$row['id']] = $row;
}

return $results;
}
}

/* End of file phplist_library.php */
/* Location: ./application/libraries/phplist_library.php */

Bookmark It

WAMP not working on localhost without active network connection

Georgi Budinov — Mon, 20 Sep 2010 08:28:28 +0000

Until recently I experienced strange problems with my WAMP server. It is not working when my machine is not connected to the internet. That was a piece of mystery for me. Actually the problem is still unknown for me although I fixed it My problem was that I had set the WAMP’s option – ‘Put online’. It took me reaaaally long time until I figure that this was causing the problems. It has to do something with the configurations in the httpd.conf but I am still unclear which setting it is enabling/disabling. Found a lot of threads on the internet about this so thought to share it.

Update: I feel stupid but actually the problem was just in FF. I am still a bit confused why changing the setting of WAMP has effect on the way FF is working …

Bookmark It

Non-latin characters in the url and ajax problems

Georgi Budinov — Sun, 19 Sep 2010 08:08:42 +0000

These troubles have some history for me. In a month a go I experienced problems with calling ajax scripts with url holding utf8 characters – bulgarian alphabet for example. So I wrote a javascript function which actually was a bit messy that could handle the problem using encodeURIComponent. Afterwards I found that I simply could use urlencode in php which was a better choice according to me at that time. It looked far more clear to me, so I rewrote the functionality. Guess what – IE 6 problems. No matter that in the output of the javascript function encodeURIComponent and the php function urlencode seemed to be the same! So I had to revert back the functionality and thought to improve my javascript function and will just share that to you as it seems to be a very generic solution that will work with any url … Here it goes:

function encodeCyrillicURIComponent(str)
{
	str = str.replace(
		new RegExp( "[^a-zA-Z\/-:_]", "g" ),
		function($0)
		{
			return encodeURIComponent($0);
		}
	);

	return str;
}

Bookmark It

Yet another case for lawer’s opinion on UniCredit Bulbank’s queue

Georgi Budinov — Thu, 16 Sep 2010 13:01:05 +0000

Today I was waiting for around 45 minutes in order to get to the cashier to pay my rent for the apartment.While waiting on the queue I had to be a witness of a conversation between the operator and a customer. They argued on the following situation:

The customer had gone the EasyPay cash desk and forgot his credit card there.
The EasyPay operator gave a call to the bank about the lost card.
The bank blocked the credit card and called the customer
He got to the EasyPay office and got back the card.
The bank opeator on the cash desk wanted 2BGN tax in order to activate the credit card
The customer went mad (he stated that he never called the bank to block the card and it is their fault and he should’t be paying. He also said that he will raise a case against the bank)

At the end the cash desk operator paid the tax of 2 BGN but the customer gave her 5 BGN to ‘buy a coffee’.

What do you think? Which one is the right side?

Bookmark It

Happy programmer’s day to all!

Georgi Budinov — Mon, 13 Sep 2010 09:53:25 +0000

Happy programmer’s day to all of us coding all the day and drinking beer. Cheers! Should we count the 128th day of the year for another programmer’s day ? Here in Bulgaria it is not a holiday at all but anyway

+ 1 vote from me!

Bookmark It