Alex (SirShurf) Frenkel's Blog

A web log of a PHP professional

Posts Tagged ‘ZF

A new generic module for Zend framework – Menu Module

leave a comment »

I have created a new generic self containing module that works with Zend framework MVC application.

The module is a Menu Module, it manages menu for MVC application and using a bootstrap and substitutes it over the menu added in the config.

Here is the link to it:
https://github.com/sirshurf/MenuModule

Currently it depends on my jQGrid Library https://github.com/sirshurf/iphp and on Belleron-Frenkel library (an extension on Zend Framework standard modules) https://github.com/sirshurf/Belleron-Frenkel

Any help/idea is welcomed :)

Written by Alex (Shurf) Frenkel

October 22, 2011 at 12:10 pm

Posted in IDE, jQGrid, Uncategorized, Zend Framework

Tagged with , , ,

JQuery & CSS Dropw down menu

leave a comment »

I have been looking for a long time for a JQuery/CSS drop down menu that would not clash with Zend Framework, and especially with Zend Navigation.

This is the one that comes closest:

http://www.noupe.com/tutorial/drop-down-menu-jquery-css.html

Written by Alex (Shurf) Frenkel

August 23, 2011 at 10:17 am

Posted in Uncategorized

Tagged with , , , , ,

jQGrid with Zend Framework Updated

with 9 comments

Recently I had some time to update the fork I have of the jQGrid encapsulation for Zend Framework.

Among the things updated is:
* Support for jQGrid 4.1.
* Support for methods in options.
* 2 new decorators
* New special decorator, a multi select element on grid search.
* Support for advanced search

And many more…
You can locate the code at my GitHub:

If you dont use jQGrid it is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the web.

Written by Alex (Shurf) Frenkel

August 22, 2011 at 7:19 pm

How to use Zend-Framework-PDF-Table-Helper

with 10 comments

Here is the example of how to user ZendFramework PDF-Table-Helper.

You can get the code from GitHub here:

One of the prerequisites is that you mast have the zf_autoloader on and configured since I am relaying on it to auto load files.

first you have to in instantiate the class:

$pdf = new SirShurf_Pdf_TableSet ();

You can instantiate it with a Zend_PDF object and without it, in which case it will be created for you, but if you are instantating with Zend_PDF you have to tell the system on what page you are working (Default is page 0).

Now what you need it to initialise a Table you are going to work with:
$objTableRow = $table->addRow ();

Each table can have his own number of columns and settings.
Each table can have a different number of rows a row can be added using this method:

And as with HTML a row has a number of cells (or columns):
$objTableRow->addCol ( $strCourseId, array (
'bold' => false, 'colspan' => 1, 'align' => 'center'
) );
$objTableRow->addCol ( Labadmin_Models_Static::convertHebrew ( $this->view->translate ( 'LBL_GRADE_FORM_COURSE_ID' ) ), array (
'bold' => false, 'colspan' => 1, 'align' => 'center', 'font' => 'arial.ttf', 'fontBold' => 'arialbd.ttf'
) );

The Cell can have each own definitions as the example here shows, and you can iterate over the data to create it.

And finally you can call render(); in order to render the changes to PDF, or build(‘fileName’) to save the finale PDF to a file.

$pdf->build ( $strGradeFileLocation . $intTimeStamp . ".grade.pdf" );

Written by Alex (Shurf) Frenkel

July 26, 2011 at 3:15 pm

Library to create a tables in Zend Framework PDF

with 2 comments

I had to create a PDF with a tables in a Zend Framework project I am making.

I have searched the web and have not found any library that can be used for this from the box, but I have found on GitHub a start of the library I was needed:
https://github.com/btm6084/Zend_PDF_Helper

Unfortunately the library was incomplete and not maintained, so I contacted the owner and he gave me the permission to take the code and do what I like with it.

So here is my version (working one) of the library that can create tables in PDF using Zend Framework PDF library.

Zend Framework PDF Table Helper

I will write a working example soon and post it here and on GitHub.

Written by Alex (Shurf) Frenkel

July 24, 2011 at 11:04 am

Grouping orWhere elements in Zend Framework Zend_Db_select

leave a comment »

Practicly each time I am working with Zend_Db_Select (with Table or without it) I am searching for how easy to group orWhere elements.

After lot’s of searching and try and error’s I have come to this code:


if (false !== $this->_customSearchKeyword) {

$searchFields = array(‘p.photo_name’, ‘p.photo_desc’);


$keywordWhere = array();


if (!empty($searchFields)) {


foreach ($searchFields as $searchField) {

$searchField = $db0->quoteIdentifier($searchField);
$keywordWhere[] = ‘(‘ . $db0->quoteInto(“$searchField = ?”,

$this->_customSearchKeyword) . ‘)';

}
$select->where( implode(‘ OR ‘, $keywordWhere) );

}

}

I hope that would be of some help to somebody :) more then me I mean

Written by Alex (Shurf) Frenkel

May 13, 2010 at 7:11 pm

Get Microsoft Sql table list form PHP

leave a comment »

One of the things I lost time today was how to get the list of table from Ms SQL server from PHP on Unix (Ubuntu).

I will write another post how to connect to it later, but currently what I have found is that MsSQL does not have “SHOW TABLES” command like MySQL do.

In order to get the list of table we need to send:
select name from sysobjects where xtype = ‘U’

This way we would get all of the user tables in our database.

Written by Alex (Shurf) Frenkel

May 12, 2010 at 2:20 pm

Posted in Uncategorized

Tagged with , , , , ,

Follow

Get every new post delivered to your Inbox.