ports/116708: New port: www/phprecipebook: Little web app to manage recipes

Fri Sep 28 12:30:03 UTC 2007

>Number:         116708
>Category:       ports
>Synopsis:       New port: www/phprecipebook: Little web app to manage recipes
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Fri Sep 28 12:30:02 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator:     Guido Falsi
>Release:        FreeBSD 6.2-STABLE i386
>Organization:
none
>Environment:
System: FreeBSD wedge.madpilot.net 6.2-STABLE FreeBSD 6.2-STABLE #38: Thu Jul 26 12:01:23 CEST 2007 root at wedge.madpilot.net:/usr/obj/usr/src/sys/WEDGE i386

>Description:

Created a little port for this php app. It's a recipe manager with access control and come shopping list functions.

I took the base port structure from the mediawiki port.

>How-To-Repeat:

>Fix:

# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	phprecipebook
#	phprecipebook/Makefile
#	phprecipebook/files
#	phprecipebook/files/patch-sql-recipedb.mysql
#	phprecipebook/distinfo
#	phprecipebook/pkg-descr
#	phprecipebook/pkg-message
#
echo c - phprecipebook
mkdir -p phprecipebook > /dev/null 2>&1
echo x - phprecipebook/Makefile
sed 's/^X//' >phprecipebook/Makefile << 'END-of-phprecipebook/Makefile'
X# New ports collection makefile for:   phprecipebook
X# Date created:        27 September 2007
X# Whom:                Guido Falsi <mad at madpilot.net>
X#
X# $FreeBSD$
X#
X
XPORTNAME=		phprecipebook
XPORTVERSION=		2.38
XCATEGORIES=		www deskutils
XMASTER_SITES=		${MASTER_SITE_SOURCEFORGE}
XMASTER_SITE_SUBDIR=	${PORTNAME}
X
XMAINTAINER=		mad at madpilot.net
XCOMMENT=		Small php webapp to manage your recipes
X
XNO_BUILD=		yes
XUSE_PHP=		xml
XWANT_PHP_WEB=		yes
XPHPRECIPEBOOKDIR?=	www/phprecipebook
X
XOPTIONS=		PGSQL "Use PostgreSQL instead of MySQL" off \
X
X.include <bsd.port.pre.mk>
X
X.if defined(WITH_PGSQL)
XUSE_PHP+=		pgsql
XUSE_PGSQL=		yes
X.else
XUSE_PHP+=		mysql
XUSE_MYSQL=		yes
X.endif
X
Xpost-extract:
X	@${CHMOD} -R u+w ${WRKSRC}
X
Xdo-install:
X	@${MKDIR} ${PREFIX}/${PHPRECIPEBOOKDIR}
X	@if [ -f ${WRKSRC}/custom_inc.php ]; then \
X		${MV} ${WRKSRC}/custom_inc.php ${WRKSRC}/custom_inc.php.sample ; \
X	fi
X	${CP} -r ${WRKSRC}/ ${PREFIX}/${PHPRECIPEBOOKDIR}
X	@if [ ! -f ${PREFIX}/${PHPRECIPEBOOKDIR}/custom_inc.php ]; then \
X		${CP} ${PREFIX}/${PHPRECIPEBOOKDIR}/custom_inc.php.sample ${PREFIX}/${PHPRECIPEBOOKDIR}/custom_inc.php ; \
X	fi
X	${CHOWN} -R ${WWWOWN}:${WWWGRP} ${PREFIX}/${PHPRECIPEBOOKDIR}
X
Xpost-install:
X	@${ECHO} "@unexec if cmp -s %D/${PHPRECIPEBOOKDIR}/custom_inc.php.sample %D/${PHPRECIPEBOOKDIR}/custom_inc.php; then rm -f %D/${PHPRECIPEBOOKDIR}/custom_inc.php; fi" >> ${TMPPLIST}
X	@${ECHO} "${PHPRECIPEBOOKDIR}/custom_inc.php.sample" >> ${TMPPLIST}
X	@${ECHO} "@exec if [ ! -f %D/${PHPRECIPEBOOKDIR}/custom_inc.php ] ; then cp -p %D/%F %B/custom_inc.php; fi" >> ${TMPPLIST}
X	@${ECHO} "@exec mkdir -p %D/${PHPRECIPEBOOKDIR}/modules/settings" >> ${TMPPLIST}
X	@${FIND} ${WRKSRC}/${file} -not -type d -not -name 'custom_inc.php*' \
X		| ${SED} -ne 's,^${WRKSRC},${PHPRECIPEBOOKDIR},p' >> ${TMPPLIST}
X	@${FIND} -d ${WRKSRC}/${file} -type d \
X		| ${SED} -ne 's,^${WRKSRC}, at dirrm ${PHPRECIPEBOOKDIR},p' >> ${TMPPLIST}
X	@${SED} -e 's|%%PHPRECIPEBOOKDIR%%|${PREFIX}/${PHPRECIPEBOOKDIR}|' ${PKGMESSAGE}
X
X.include <bsd.port.post.mk>
END-of-phprecipebook/Makefile
echo c - phprecipebook/files
mkdir -p phprecipebook/files > /dev/null 2>&1
echo x - phprecipebook/files/patch-sql-recipedb.mysql
sed 's/^X//' >phprecipebook/files/patch-sql-recipedb.mysql << 'END-of-phprecipebook/files/patch-sql-recipedb.mysql'
X--- sql/recipedb.mysql.orig	2007-03-31 20:22:08.000000000 +0200
X+++ sql/recipedb.mysql	2007-09-27 17:10:02.000000000 +0200
X@@ -154,7 +154,7 @@
X 	PRIMARY KEY (meal_id));
X 
X CREATE TABLE recipe_mealplans (
X-	mplan_date DATE NOT NULL DEFAULT 'now()',
X+	mplan_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
X 	mplan_meal INT NOT NULL REFERENCES recipe_meals(meal_id) ON DELETE CASCADE,
X 	mplan_recipe INT NOT NULL REFERENCES recipe_recipes(recipe_id) ON DELETE CASCADE,
X 	mplan_servings INT NOT NULL DEFAULT 0,
X@@ -164,7 +164,7 @@
X CREATE TABLE recipe_reviews (
X 	review_recipe INT NOT NULL REFERENCES recipe_recipes(recipe_id) ON DELETE CASCADE,
X 	review_comments VARCHAR(255) NOT NULL,
X-	review_date TIMESTAMP DEFAULT 'now()',
X+	review_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
X 	review_owner VARCHAR(32) NOT NULL REFERENCES security_users(user_login) ON DELETE SET NULL ON UPDATE CASCADE,
X 	PRIMARY KEY (review_recipe,review_comments,review_owner));
X 
END-of-phprecipebook/files/patch-sql-recipedb.mysql
echo x - phprecipebook/distinfo
sed 's/^X//' >phprecipebook/distinfo << 'END-of-phprecipebook/distinfo'
XMD5 (phprecipebook-2.38.tar.gz) = 864ae8fb66213c2796fdd4b7a58a053d
XSHA256 (phprecipebook-2.38.tar.gz) = c05d53f849ef84a0b6690c6d20e3f703e215a7ef0a0b1990354ffe14bd34d2b3
XSIZE (phprecipebook-2.38.tar.gz) = 556970
END-of-phprecipebook/distinfo
echo x - phprecipebook/pkg-descr
sed 's/^X//' >phprecipebook/pkg-descr << 'END-of-phprecipebook/pkg-descr'
XThis projects purpose is to provide a convenient way to construct
Xa weekly shopping list from a known list of recipes. The user can
Xview, add, search and modify recipes like any decent web based
Xcookbook. This cookbook provides the extra functionality to add
Xrecipes to a shopping list. The shopping list then can be saved or
Xprinted out.
X
XWWW: http://phprecipebook.sourceforge.net/
END-of-phprecipebook/pkg-descr
echo x - phprecipebook/pkg-message
sed 's/^X//' >phprecipebook/pkg-message << 'END-of-phprecipebook/pkg-message'
X
X        **** NOTE ****
X
XPlease read:
X
X%%PHPRECIPEBOOKDIR%%/docs/INSTALL.UNIX
X
XIf you are upgrading then read this too:
X
X%%PHPRECIPEBOOKDIR%%/docs/UPGRADE.TXT
END-of-phprecipebook/pkg-message
exit

>Release-Note:
>Audit-Trail:
>Unformatted: