From f6823259241484a761bc7e69ce44db281a6cb825 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Mon, 17 Aug 2015 22:20:10 -0700 Subject: provide ability to export by month as well as by year --- include/identity.php | 17 ++++++++++++++--- 1 file changed, 14 insertions(+), 3 deletions(-) (limited to 'include/identity.php') diff --git a/include/identity.php b/include/identity.php index 23c099bbd..daa985c2f 100644 --- a/include/identity.php +++ b/include/identity.php @@ -601,14 +601,25 @@ function identity_basic_export($channel_id, $items = false) { -function identity_export_year($channel_id,$year) { +function identity_export_year($channel_id,$year,$month = 0) { if(! $year) return array(); + if($month && $month <= 12) { + $target_month = sprintf('%02d',$month); + $target_month_plus = sprintf('%02d',$month+1); + } + else + $target_month = '01'; + $ret = array(); - $mindate = datetime_convert('UTC','UTC',$year . '-01-01 00:00:00'); - $maxdate = datetime_convert('UTC','UTC',$year+1 . '-01-01 00:00:00'); + $mindate = datetime_convert('UTC','UTC',$year . '-' . $target_month . '-01 00:00:00'); + if($month && $month < 12) + $maxdate = datetime_convert('UTC','UTC',$year . '-' . $target_month_plus . '-01 00:00:00'); + else + $maxdate = datetime_convert('UTC','UTC',$year+1 . '-01-01 00:00:00'); + $r = q("select * from item where (item_flags & %d) > 0 and (item_restrict & %d) = 0 and uid = %d and created >= '%s' and created < '%s' order by created ", intval(ITEM_WALL), intval(ITEM_DELETED), -- cgit v1.2.3