You can easily edit the component to allow for this feature:

- comment the line bellow from the TAB DATA-API

// e.preventDefault()


- add the following code below the TAB DATA-API

$('ul.nav-tabs li a[data-toggle="tab"]').each(function(){
if ($(this).attr("href") == window.location.hash) {
$(this).tab('show')
}
});

- add an anchor to all your tabs links


You would need some Version Control and of course you will need some deployment strategy. This is Springloops comes in. Not only does it give you an version control repository (Git or Subversion) for your project but it also provides an automatic process of deploying your app, either by FTP, SFTP, FTP over SSH and even to Amazon S3.

If version control and one click automatic deployments were not enough to convince you, Springloops also has project management features: milestones, tickets and even time tracking.

Another cool thing is they have a free plan witch gives you access to all the features for only one active project. So you have a project starting up give it a try i promise you wont be disappointed.

So i started thinking of a database structure that will enable me to accomplish this. As i started to research i also posted a question on stackoverflow to see what others had in mind.

The design

After a bit of thought i came up with this design.

Design Details

Products have an id_configuration
A configurable products actually is a collection of products witch have the same id_configuration (witch is auto-generated).

Features linked to products
Rather then categories, which seems more naturally to me. This enables me to easily move products between categories.

Product features values is stored in the link table
I decided to store the feature value for a product in the link table. This helps with more simple queries and also it means that you don’t have to insert all the options in the feature options table (think of features that have different values for all products)

Name and Label for features
The name is used internally in the admin section and Label is used in the site front-end. This is useful for features with same name. Ex: Size for clothes, size for hardisks etc.

Filterable flag on features
A Yes/No flag that shows witch filters are filtrable.

Examples of use

Selecting products
The most important thing is how do we select products, and how do we only show one product for the configurable ones. For this we use GROUP BY.

SELECT * FROM `products`
GROUP BY CASE `products`.`configurable` WHEN 'yes' THEN `products`.`id_configuration` ELSE `products`.`id` END


Filtering products
The bellow example shows the query for a single filter/feature (with id 38) and 2 values selected:

SELECT * FROM `products`
WHERE `id` IN (SELECT id_product FROM `product-features` WHERE `id_feature` = 38 AND `value` IN ('Test value', 'New Value') GROUP BY id_product HAVING COUNT(*) >= 1)
GROUP BY CASE `products`.`configurable` WHEN 'yes' THEN `products`.`id_configuration` ELSE `products`.`id` END


Get active filters
After you have a list of filter products you will want to print out a list of filters that are applicable to this list, since not all are available to the current selected products.

SELECT `id_feature` FROM `product-features`
WHERE `id_product` IN (SELECT `id` FROM `products` WHERE ___YOUR_CONDITIONS____) GROUP BY `id_feature`

Notice that i left out the GROUP BY from the product subselect.

Associate count of products for a filter
Its very useful to show the count of products for a certain value of a filter. The bellow query is how you can select that count for one filter.

SELECT *, COUNT(*) AS `count` FROM (
SELECT *
FROM `product-features`
WHERE
`id_product` IN (SELECT `id` FROM `products` WHERE ___YOUR_CONDITIONS____) AND
`id_feature` = 36
) AS `tbl` GROUP BY `value`

Notice that i left out the GROUP BY from the product subselect.

Conclusions

I think this database model works best for what i wanted and it has all the flexibility i needed:
- it allows for any 2 products to group as configurable
- you can add promotions and separate images for each variation
- have separate stocks on each variation (witch make more sense to me)
- get sales report cumulate or separate on each variation.

Hope you like this approach and i await you comments on it.

svn attempt to write a readonly database
commit failed

Although if i looked at the repo the commited files were there.

After hunting Google a bit, I found the problem to be with the “/svn/repopath/db/rep-cache.db” file that did not have write permissions for the user subversion uses.
After fixing permissions, committing went perfectly with no errors.

Hope it helps.

So add this to your hosts:
174.36.30.71 www.dropbox.com

Hope it works for you.

The project can be found here:
http://code.google.com/p/php-adwords-api/

It is still a work in progress and does not yet support all the services and functions of the API, but we hope to add more services as soon as possible. And if you need a certain service or function please dont hesitate to add a ticket on google code and request it.

You will find examples of usage in the folder examples of the library.

Generating print-ready well-formatted PDF documents with PHP is not an easy task. Traditionally, there are two main approaches to PDF generation with PHP. Given sufficient time and patience, both partially get the job done, but still leave a lot to be desired:

HTML-to-PDF: This approach is widely used in mainstream applications. Here an HTML document is programmatically created and converted to a PDF, using one of the many open source libraries ¹. Since HTML, however, is not a page-oriented format (as is PDF), it is impossible to perform a 1-to-1 mapping between HTML and PDF. Typical word processing file format features, such as header and footers, orphans and widows or even page numbers can simply not be represented in HTML.

Table of contents

• A completely new approach
• Introducing LiveDocx
• Templates and documents
• Using LiveDocx
  • Creating a template in Microsoft® Word 2007
  • Assigning scalar data types in LiveDocx
  • Assigning compound data types in LiveDocx
  • Generating image files with LiveDocx
• Deploying LiveDocx in your own applications
• Learn more
  • LiveDocx in PHP 5
  • LiveDocx SOAP service
• Footnotes

Programmatic: This approach offers total control of the resulting PDF. However, it requires that the x and y coordinates of every line of text, every geometrical shape and graphic be set from program code ². Not only is this an extremely time-consuming solution, but is also very brittle: Every time a graphical designer changes the layout of a document, a programmer must re-work his or her program code.

A completely new approach

In this article, the author presents an entirely new, third approach. It relies on templates being created in a WYSIWYG environment, such as Microsoft® Word or Open Office, and then being populated with data in PHP. The resulting document can be saved not only to PDF, but also DOCX, DOC and RTF.

Before we delve into a technical discussion on the inner workings of this new approach, let us first take a look at a practical example. The following PHP 5 code illustrates PDF generation, in which the merge fields software, licensee and company in the template template.docx [46.7 KB] are populated with scalar data in PHP. The resulting document document.pdf [104.7 KB] is created and written to disk.

The code demonstrated in this article will be shipped with the Zend Framework 1.10 when it becomes available. Although at the time of writing, there is no official release date, 1.10 is expected to release in Q4 2009. In the meantime, you can check the components out of the Standard Incubator SVN repository.

Introducing LiveDocx

LiveDocx is a SOAP-based document generation service, based on the market-leading, word processing component TX Text Control .NET. LiveDocx allows word processing templates to be populated in any programming language that supports SOAP. The resulting document can be saved to any supported format. This article, however, concentrates on using LiveDocx in PHP 5.

The components of the Zend Framework implementation of LiveDocx are located at /Zend/Service/LiveDocx/ in the standard Zend Framework distribution file. It is possible to use LiveDocx directly with the PHP 5 SoapClient, without the Zend Framework, and with the third party library NuSOAP. The NuSOAP approach even allows LiveDocx to be used in PHP 4. This article, however, concentrates on the official Zend Framework components in PHP 5.

Templates and documents

Throughout this article, we refer to the terms templates and documents. It is important to understand the difference between the two.

Templates: The term template is used to refer to the input file, containing formatting and text fields. Templates can be in any one of the following file formats:

• DOCX - Office Open XML Format
• DOC - Microsoft® Word DOC Format
• RTF - Rich Text Format
• TXD - TX Text Control® Format

Templates can be stored either locally on the client machine (the one from which the SOAP request is initiated) or remotely on the backend server. The decision on which one you should use depends upon the kind of application you are developing.

If you store the templates locally, you have to transfer the template together with the data that should be populated on every request. In the case that the template remains the same on every request, this approach is very inefficient. It would be better to upload the template to the backend server once and then reference it on all subsequent requests. This way, only the data that should be populated is transfered from the client to the backend server. Most applications, using LiveDocx fall into this category.

On the other hand, if you have a template that is constantly changing, or an application in which you enable end-users to upload templates, you may consider storing templates locally and transfer them every request. This approach, is obviously slower, as every request contains the template itself, in addition to the data to populate it.

Documents: The term document is used to refer to the generated output file that contains the template file, populated with data - i.e. the finished document. Documents can be saved in any one of the following file formats:

• DOCX - Office Open XML Format
• DOC - Microsoft® Word DOC Format
• HTML - XHTML 1.0 Transitional Format
• RTF - Rich Text Format
• PDF - Acrobat® Portable Document Format
• TXD - TX Text Control Format
• TXT - ANSI Plain Text

In addition to the above word processing file formats, documents can also be saved to the following image file formats:

• BMP - Bitmap Image Format
• GIF - Graphics Interchange Format
• JPG - Joint Photographic Experts Group Format
• PNG - Portable Network Graphics Format
• TIFF - Tagged Image File Format
• WMF - Windows Meta File Format

Using LiveDocx

In this section, we are going to look at the entire process of creating a document using LiveDocx from scratch.

Creating a template in Microsoft® Word 2007

The first step in any LiveDocx project is the creation of a template. To do this, you can use either Open Office or Microsoft® Word. For the purpose of this article, we are going to use Microsoft® Word 2007. For instructions on using Open Office, please take a look at the LiveDocx Blog.

Start off by creating a new file in Microsoft® Word 2007 and save the template file as template.docx.

You can then start to compose the template, inserting text, graphics and merge fields with the Field dialog box, shown to the right.

After a while, you will have a template, which contains images, text and a number of merge fields. The merge fields are represented by { MERGEFIELD name } and will be populated with scalar data in the next step. The follow screenshot of the template in Microsoft® Word 2007 illustrates how your template may look:

Save the template template.docx [46 KB] when you are done.

Assigning scalar data types in LiveDocx

Now that we have the template file, the next step is to populate it with data. In the following example, we are going to assign scalar data types - in this case strings - to the template.

For many applications, in particular those in which PDF files are used of archiving purposes, you may wish to set the meta data of the PDF file. You can do this, by specifying an associative array with the meta data that should be embedded into the PDF file. The setDocumentProperties() method must be called before createDocument():

The resulting document document.pdf [104 KB] is written to disk and can now be opened in your favorite PDF reader, such as the shipped Document Viewer in Ubuntu:

Assigning compound data types in LiveDocx

In addition to the scalar data types, which were assigned to the template in the previous example, you can also assign compound data types, such as an associative array. Consider the template template.doc [20.5 KB] and the resulting document document.pdf [77.6 KB]. In particular, take a look at the following section of the template (click to enlarge):

The section of the template between the bookmarks

and is repeated in the final document to produce rows of a table. One sub-array of the following associate array is used for each row.

Using the following PHP 5 code, we are going to populate the template with an associative array of telephone connection data. For clarity, this example shows only the part in which an associative array is assigned. The instantiation of LiveDocx and the document creation and retrievable processes are identical to the previous examples and have been omitted:

The resulting document contains the following table with the data from the assigned associate array (click to zoom):

Generating image files with LiveDocx

In addition to the word processing file formats listed above that are supported by LiveDocx, you can also save the resulting documents as one or more image files. For this purpose, Zend_Service_LiveDocx_MailMerge offers the methods getAllBitmaps() and getBitmaps():

Similarly, it is possible to retrieve images for pages in a specific range:

Note that zoomFactor parameter. This is a per cent value, in the range of 10% to 400%. These methods are ideally suited to generating thumbnail images of the created document, for example, to display in the browser as a preview.

The actual image files can be written to disk by iterating through the $bitmaps array. There is one page of binary data per record in the array:

Deploying LiveDocx in your own applications

The code, which constitutes the PHP 5 implementation of LiveDocx, shipped in the Zend Framework, is released under the New BSD license and thus may be deployed, modified and redistributed in most projects, according to that terms of the license. The actual LiveDocx SOAP server, however, is proprietary software. There are three ways in which the SOAP service can be deployed in your own applications.

1. Free public server
   For the vast majority of applications, developers choose this approach. The default LiveDocx server that is referenced in the Zend Framework components is the free public server. It may be used in your own applications completely free of charge. Sign up for a LiveDocx account.
2. Premium hosted server
   In the case that your application generates several thousand documents per hour, you may consider paying a small monthly fee to have access to your own personal LiveDocx server. In association with leading hosting providers, you can rent such a premium hosted server.
3. Local licensed server
   In the case that your application generates more than about ten thousand documents her hour, you may consider installing a LiveDocx server in your local network. Having direct access in a local gigabit network is by far the fastest way of deploying LiveDocx.

Learn more

This article has scratched the surface of what you can do with LiveDocx. If you would like to learn more about this new powerful document generation platform, please take a look at the following resources:

LiveDocx in PHP 5

• phpLiveDocx blog.
• phpLiveDocx technical articles.

LiveDocx SOAP service

• LiveDocx blog.
• LiveDocx API reference.

Please do not hesitate to contact the author or request technical support in the support forum (free of charge) at any time.

Footnotes

[1]
domPDF, HTML 2 (F)PDF, HTML_ToPDF, mPDF etc.

[2] Zend_Pdf, PDFlib, FPDF, Cpdf etc.

]]> http://www.gsdesign.ro/blog/pdf-generation-with-zend-framework/feed/ 0 http://www.gsdesign.ro/blog/pdf-generation-with-zend-framework/ http://feedproxy.google.com/~r/gsdesign/bzmE/~3/vGiN5RvNmfk/ http://www.gsdesign.ro/blog/running-for-charity/#comments Wed, 09 Sep 2009 05:00:30 +0000 Gabi Solomon http://www.gsdesign.ro/blog/?p=400 I havent posted in a while, will try and restart, but for now i am writing this non-geek related post.

I'm taking part in the Berlin Marathon 2009 on 20/09/2009 to raise money for British Heart Foundation and would really welcome your support.

Please take a moment to sponsor me. It's really easy - you can donate online by credit or debit card at the following address:

http://original.justgiving.com/gabrielsolomon

All donations are secure and sent electronically to British Heart Foundation. If you are a UK taxpayer, Justgiving will add an automatic 28% bonus to your donation at no cost to you. Please join me in supporting British Heart Foundation and a fabulous cause!

Thanks and best wishes.

]]> http://www.gsdesign.ro/blog/running-for-charity/feed/ 3 http://www.gsdesign.ro/blog/running-for-charity/ http://feedproxy.google.com/~r/gsdesign/bzmE/~3/PC7xqTm5F-o/ http://www.gsdesign.ro/blog/replication-mirroring-as-master-master-with-subversion-using-svnsync/#comments Fri, 26 Jun 2009 20:29:38 +0000 Gabi Solomon http://www.gsdesign.ro/blog/?p=398 For me it all started when my VPS had an error and all my SVN repos were lost. Plus even though i had purchased a backup system from the hosting company that was suppose to do a full server backup automatic and incrementally, i only had a backup from 20 days earlier because the system failed at that point in time and didnt run since.

But enough with my problems, at that point i decided to make a copy of my repos from the remote server to my local machine.
And i would commit into the local one and it should automaticly sync to the remote one. Plus it would need to do this both ways and in real time since i had some external people commiting in the remote server. Easier said then done i camed to find out.

The reasons why

Well for me there are 3 main reasons:
1. as a backup system ( dont want to be put in the 20 days old backup situation again )
2. for faster commits and updates
3. independent of the internet connection ( it hasnt failed in quite a while, but just in case, or for the times its a bit slow )

The alternatives

It seems that this topic is a bit popular, and there are a few places on the internet where people are interested in this. You can check out this question on stackoverflow for one.

1. Git-SVN
This is one alternative that a lot of people have been recommended. The benefits they are you get the best out of both worlds, you can still use the Subversion in the main repo, but you get the power of GIT for your local copy.
Although this sounds very cool, i am more of a GUI guy and really enjoy the subversion integration in my IDE ( Netbeans ) so i would have to pass this options.

2. SVK

svk is a decentralized version control system built with the robust Subversion filesystem. It supports repository mirroring, disconnected operation, history-sensitive merging, and integrates with other version control systems, as well as popular visual merge tools.

At first i read this article about SVK and it seemed to be what i was looking for. But after playing with it for a while i saw that i would need to have a single repo where all my comits would go and that would be synced to several outside repos. But i was looking for a way to have the exact replica of what it is on the remote server so in the case of a failure i could restore them from my backup.

If you are still interested in this you can also read this and this.

3. svnsync + webdav proxy
I knew about svnsync but it only supports read-only copies of your repo. But after reading a small comment on stackoverflow i started looking and find out you can have read-write copies using svnsync and webdav proxy.
What is basicly happening is that your local copy handles the read operations and it forwards the commits to the main repo.

There are a few tricky parts on this solution, that involve the locks and updating of all the replicas of the main repo. This are done by a series of hooks in the main repo.
If youre interested in this solution you can find information about implementing it in this articles:
Subversion transparent proxy with svnsync + webdav proxy
subversion diy write through proxy
Subversion on-the-fly replication

conclusion

Honestly i don't have one yet , but i plant to try using svnsnyc and see how that goes.
I hope you got a big picture of what your options are and now you can decide what suits you best.

Cheers

]]> http://www.gsdesign.ro/blog/replication-mirroring-as-master-master-with-subversion-using-svnsync/feed/ 7 http://www.gsdesign.ro/blog/replication-mirroring-as-master-master-with-subversion-using-svnsync/ http://feedproxy.google.com/~r/gsdesign/bzmE/~3/R1e8J2yUz0E/ http://www.gsdesign.ro/blog/audit_log_user_command-connection-refused/#comments Fri, 26 Jun 2009 18:54:22 +0000 Gabi Solomon http://www.gsdesign.ro/blog/?p=396 This error happend to me when i runned a command on my Centos VPS.

audit_log_user_command(): Connection refused

And after some googling it seems that a lot of Centos users are running into this when executing SUDO.
But it seens that this is a bug in Centos kernel, and its not fixed yet.
My problem was that i was running the commands logged as root ( silly me ).
Hope you are too, because otherwise i have no sollution for you .

Cheers

]]> http://www.gsdesign.ro/blog/audit_log_user_command-connection-refused/feed/ 0 http://www.gsdesign.ro/blog/audit_log_user_command-connection-refused/