From 1c9299ed4224d37716079be173d75319d2501b71 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 15 Jan 2015 14:05:18 -0800 Subject: more backend work on poco rating --- boot.php | 2 +- include/socgraph.php | 7 +++++-- install/update.php | 12 +++++++++++- mod/connedit.php | 8 ++++++++ mod/poco.php | 3 ++- view/tpl/abook_edit.tpl | 8 ++++++++ view/tpl/poco_entry_xml.tpl | 1 + view/tpl/rating_slider.tpl | 4 ++++ 8 files changed, 40 insertions(+), 5 deletions(-) create mode 100644 view/tpl/rating_slider.tpl diff --git a/boot.php b/boot.php index e71f164a3..7d051e5f2 100755 --- a/boot.php +++ b/boot.php @@ -49,7 +49,7 @@ define ( 'RED_PLATFORM', 'redmatrix' ); define ( 'RED_VERSION', trim(file_get_contents('version.inc')) . 'R'); define ( 'ZOT_REVISION', 1 ); -define ( 'DB_UPDATE_VERSION', 1131 ); +define ( 'DB_UPDATE_VERSION', 1132 ); /** * Constant with a HTML line break. diff --git a/include/socgraph.php b/include/socgraph.php index 740886b1c..dbc25f9c1 100644 --- a/include/socgraph.php +++ b/include/socgraph.php @@ -117,6 +117,7 @@ function poco_load($xchan = '',$url = null) { $name = $entry['displayName']; $hash = $entry['hash']; $rating = ((array_key_exists('rating',$entry)) ? intval($entry['rating']) : 0); + $rating = ((array_key_exists('rating_text',$entry)) ? escape_tags($entry['rating_text']) :''); if(x($entry,'urls') && is_array($entry['urls'])) { foreach($entry['urls'] as $url) { @@ -188,17 +189,19 @@ function poco_load($xchan = '',$url = null) { ); if(! $r) { - q("insert into xlink ( xlink_xchan, xlink_link, xlink_rating, xlink_updated ) values ( '%s', '%s', %d, '%s' ) ", + q("insert into xlink ( xlink_xchan, xlink_link, xlink_rating, xlink_rating_text, xlink_updated ) values ( '%s', '%s', %d, '%s', '%s' ) ", dbesc($xchan), dbesc($hash), intval($rating), + dbesc($rating_text), dbesc(datetime_convert()) ); } else { - q("update xlink set xlink_updated = '%s', xlink_rating = %d where xlink_id = %d", + q("update xlink set xlink_updated = '%s', xlink_rating = %d, xlink_rating_text = '%s' where xlink_id = %d", dbesc(datetime_convert()), intval($rating), + dbesc($rating_text), intval($r[0]['xlink_id']) ); } diff --git a/install/update.php b/install/update.php index d6953cdbc..f7ccb8210 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ -10, + '$val' => (($contact['abook_rating']) ? $contact['abook_rating'] : 0), + )); + $perms = array(); $channel = $a->get_channel(); @@ -555,6 +561,8 @@ function connedit_content(&$a) { '$buttons' => (($self) ? '' : $buttons), '$viewprof' => t('View Profile'), '$lbl_slider' => t('Slide to adjust your degree of friendship'), + '$lbl_rating' => t('Rating (this information is public)'), + '$rating' => $rating, '$slide' => $slide, '$tabs' => $t, '$tab_str' => $tab_str, diff --git a/mod/poco.php b/mod/poco.php index 3f932e92f..892d79801 100644 --- a/mod/poco.php +++ b/mod/poco.php @@ -178,7 +178,8 @@ function poco_init(&$a) { if($fields_ret['photos']) $entry['photos'] = array(array('value' => $rr['xchan_photo_l'], 'mimetype' => $rr['xchan_photo_mimetype'], 'type' => 'profile')); if($fields_ret['rating']) { - $entry['rating'] = ((array_key_exists('abook_rating',$rr)) ? array(intval($rr['abook_rating'])) : 0); + $entry['rating'] = ((array_key_exists('abook_rating',$rr)) ? intval($rr['abook_rating'])) : 0); + $entry['rating_text'] = ((array_key_exists('abook_rating_text',$rr)) ? $rr['abook_rating_text'])) : ''); // maybe this should be a composite calculated rating in $system_mode if($system_mode) $entry['rating'] = 0; diff --git a/view/tpl/abook_edit.tpl b/view/tpl/abook_edit.tpl index 03b7e2440..c38cc8ffb 100755 --- a/view/tpl/abook_edit.tpl +++ b/view/tpl/abook_edit.tpl @@ -43,6 +43,14 @@ {{$slide}} {{/if}} + +{{if $rating}} +

{{$lbl_rating}}

+ +{{$rating}} + +{{/if}} + {{/if}} diff --git a/view/tpl/poco_entry_xml.tpl b/view/tpl/poco_entry_xml.tpl index 869894852..30b6268dc 100755 --- a/view/tpl/poco_entry_xml.tpl +++ b/view/tpl/poco_entry_xml.tpl @@ -2,6 +2,7 @@ {{if $entry.id}}{{$entry.id}}{{/if}} {{if $entry.displayName}}{{$entry.displayName}}{{/if}} {{if $entry.preferredUsername}}{{$entry.preferredUsername}}{{/if}} +{{if $entry.rating}}{{$entry.rating}}{{/if}} {{if $entry.urls}}{{foreach $entry.urls as $url}}{{$url.value}}{{$url.type}}{{/foreach}}{{/if}} {{if $entry.photos}}{{foreach $entry.photos as $photo}}{{$photo.value}}{{$photo.type}}{{/foreach}}{{/if}} diff --git a/view/tpl/rating_slider.tpl b/view/tpl/rating_slider.tpl new file mode 100644 index 000000000..6bdb57cd1 --- /dev/null +++ b/view/tpl/rating_slider.tpl @@ -0,0 +1,4 @@ +
+ -- cgit v1.2.3 From e7932d97a25bf621082e93f47816a2a107a6d05f Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 15 Jan 2015 16:37:47 -0800 Subject: editing stuff for poco reputation --- mod/connedit.php | 17 +++++++++++++++-- view/css/mod_connedit.css | 9 +++++++++ view/tpl/abook_edit.tpl | 8 ++++++++ view/tpl/rating_slider.tpl | 2 +- 4 files changed, 33 insertions(+), 3 deletions(-) diff --git a/mod/connedit.php b/mod/connedit.php index cf6ff6aad..87d5e9eca 100644 --- a/mod/connedit.php +++ b/mod/connedit.php @@ -107,6 +107,14 @@ function connedit_post(&$a) { if($closeness < 0) $closeness = 99; + $rating = intval($_POST['rating']); + if($rating < (-10)) + $rating = (-10); + if($rating > 10) + $rating = 10; + + $rating_text = escape_tags($_REQUEST['rating_text']); + $abook_my_perms = 0; foreach($_POST as $k => $v) { @@ -125,11 +133,13 @@ function connedit_post(&$a) { $new_friend = true; } - $r = q("UPDATE abook SET abook_profile = '%s', abook_my_perms = %d , abook_closeness = %d, abook_flags = %d + $r = q("UPDATE abook SET abook_profile = '%s', abook_my_perms = %d , abook_closeness = %d, abook_rating = %d, abook_rating_text = '%s', abook_flags = %d where abook_id = %d AND abook_channel = %d", dbesc($profile_id), intval($abook_my_perms), intval($closeness), + intval($rating), + dbesc($rating_text), intval($abook_flags), intval($contact_id), intval(local_user()) @@ -561,8 +571,11 @@ function connedit_content(&$a) { '$buttons' => (($self) ? '' : $buttons), '$viewprof' => t('View Profile'), '$lbl_slider' => t('Slide to adjust your degree of friendship'), - '$lbl_rating' => t('Rating (this information is public)'), + '$lbl_rating' => t('Rating (this information may be public)'), + '$lbl_rating_txt' => t('Optionally explain your rating (this information may be public)'), + '$rating_txt' => $contact['abook_rating_text'], '$rating' => $rating, + '$rating_val' => $contact['abook_rating'], '$slide' => $slide, '$tabs' => $t, '$tab_str' => $tab_str, diff --git a/view/css/mod_connedit.css b/view/css/mod_connedit.css index 98c53602b..44a0a1abf 100644 --- a/view/css/mod_connedit.css +++ b/view/css/mod_connedit.css @@ -52,6 +52,15 @@ width: 600px !important; } +#rating-slider { + width: 600px !important; +} + +#rating-text { + width: 400px; + height: 60px; +} + .abook-edit-them, .abook-edit-me { float: left; margin-left: 10px; diff --git a/view/tpl/abook_edit.tpl b/view/tpl/abook_edit.tpl index c38cc8ffb..3709944e9 100755 --- a/view/tpl/abook_edit.tpl +++ b/view/tpl/abook_edit.tpl @@ -49,6 +49,7 @@ {{$rating}} + {{/if}} {{/if}} @@ -65,6 +66,7 @@ + @@ -74,6 +76,12 @@ {{/if}} +{{if $notself}} +

{{$lbl_rating_txt}}

+ +{{/if}} + + {{if $multiprofs }}

{{$lbl_vis1}}

diff --git a/view/tpl/rating_slider.tpl b/view/tpl/rating_slider.tpl index 6bdb57cd1..4702fc65b 100644 --- a/view/tpl/rating_slider.tpl +++ b/view/tpl/rating_slider.tpl @@ -1,4 +1,4 @@
-- cgit v1.2.3 From 597b07e8cc40144abce63f0779d28c2dbc376a22 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 15 Jan 2015 17:32:41 -0800 Subject: poco rating - add a test module for pulling out ratings --- mod/connedit.php | 18 ++++++++++++++---- mod/prep.php | 38 ++++++++++++++++++++++++++++++++++++++ view/tpl/abook_edit.tpl | 3 ++- view/tpl/prep.tpl | 36 ++++++++++++++++++++++++++++++++++++ 4 files changed, 90 insertions(+), 5 deletions(-) create mode 100644 mod/prep.php create mode 100644 view/tpl/prep.tpl diff --git a/mod/connedit.php b/mod/connedit.php index 87d5e9eca..c27f4588a 100644 --- a/mod/connedit.php +++ b/mod/connedit.php @@ -534,11 +534,21 @@ function connedit_content(&$a) { )); } + $poco_rating = get_config('system','poco_rating_enable'); + // if unset default to enabled + if($poco_rating === false) + $poco_rating = true; + + if($poco_rating) { + $rating = replace_macros(get_markup_template('rating_slider.tpl'),array( + '$min' => -10, + '$val' => (($contact['abook_rating']) ? $contact['abook_rating'] : 0), + )); + } + else { + $rating = false; + } - $rating = replace_macros(get_markup_template('rating_slider.tpl'),array( - '$min' => -10, - '$val' => (($contact['abook_rating']) ? $contact['abook_rating'] : 0), - )); $perms = array(); $channel = $a->get_channel(); diff --git a/mod/prep.php b/mod/prep.php new file mode 100644 index 000000000..e53f7ac4e --- /dev/null +++ b/mod/prep.php @@ -0,0 +1,38 @@ + 1) + $hash = argv(1); + + if(! $hash) { + notice('Must supply a channel identififier.'); + return; + } + + $p = q("select * from xchan where xchan_hash like '%s'", + dbesc($hash . '%') + ); + + $r = q("select * from xlink left join xchan on xlink_xchan = xchan_hash where xlink_link like '%s' and xlink_rating != 0", + dbesc($hash . '%') + ); + + $ret = array(); + + if($p && $r) { + $ret['poi'] = $p[0]; + $ret['raters'] = $r; + + $o = replace_macros(get_markup_template('prep.tpl'),array( + '$header' => t('Ratings'), + '$poi' => $p[0], + '$raters' => $r + )); + + return $o; + } + return ''; +} + + \ No newline at end of file diff --git a/view/tpl/abook_edit.tpl b/view/tpl/abook_edit.tpl index 3709944e9..7c75bfac4 100755 --- a/view/tpl/abook_edit.tpl +++ b/view/tpl/abook_edit.tpl @@ -76,11 +76,12 @@
{{/if}} +{{if $rating}} {{if $notself}}

{{$lbl_rating_txt}}

{{/if}} - +{{/if}} {{if $multiprofs }}
diff --git a/view/tpl/prep.tpl b/view/tpl/prep.tpl new file mode 100644 index 000000000..d0c1e5ec6 --- /dev/null +++ b/view/tpl/prep.tpl @@ -0,0 +1,36 @@ +

{{$header}}

+ +{{if $poi}} + +
+ +
+
+{{$poi.xchan_addr}} +
{{$poi.xchan_name}}
+
+
+{{/if}} + +{{if $raters}} +{{foreach $raters as $r}} + +
+ +
+
+{{$r.xchan_addr}} +
{{$r.xchan_name}}
+
+Rating: {{$r.xlink_rating}} +{{if $r.xlink_rating_text}} +Reason: {{$r.xlink_rating_text}} +{{/if}} +
+{{/foreach}} +{{/if}} + + + + + -- cgit v1.2.3