[UserFiles] - Файлы пользователя.

[2016-02-27 17:54:36] (ERROR @ /assets/components/userfiles/connector.php) Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'UserFile.context' in 'field list'
)

<?=$modx->runSnippet('ufForm', array(
	"anonym" => '1' ,
	"list" => 'image' ,
	"tplForm" => 'uf.form' ,
	"source" => 8, //    "assets/images/goods/"
	"dropzone" => '{"maxFilesize":10,"maxFiles":3,"acceptedFiles":".jpg, .jpeg, .gif, .png","template":"edit"}' ,
))?>

<script>
    jQuery.Modal = jQuery.Modal || true;
</script>

return md5_file($scriptProperties['file'])

[[!ufform?
&class=`modResource`
&list =`plan`
&parent=`[[+id]]`
&onlyCreatedby=`1`
&dropzone=`{"maxFilesize":4,"maxFiles":5,"acceptedFiles":".jpg, .jpeg, .gif, .png","template":"edit"}` 
]]

<div class="userfiles-form-wrapper">

    <form class="userfiles-form userfiles-dropzone" id="[[+propkey]]" method="post" action=""
          data-clickable=".userfiles-form-clickable-[[+propkey]]" data-sorting="1">

        <div class="dz-message needsclick">[[%userfiles_msg_needsclick]]</div>

    </form>

    <a class="userfiles-form-clickable userfiles-form-clickable-[[+propkey]]">[[%userfiles_msg_select_files]]</a>

</div>

[[!pdoResources?
    &limit=`10`
    &showLog=`0`
    &class=`UserFile`
    &loadModels=`UserFiles`
    &sortby=`rank`
    &sortdir=`ASC`
    &tpl=`@INLINE 
    <div class="item">
        <a href="[[+url]]" target="_blank"><img src="[[+thumb]]" title="[[+name]]"></a>
    </div>`
    &where=`{
        "UserFile.class":"modUser",
        "UserFile.parent":[[!+modx.user.id]],
        "UserFile.createdby":[[!+modx.user.id]]
    }`
    &leftJoin=`{
	"Thumb": {
		"class": "UserFile",
		"on": "Thumb.parent = UserFile.id AND Thumb.properties LIKE '%w\":120,\"h\":90%'"
	}
    }`
    &select=`{
	"UserFile": "*",
	"Thumb": "Thumb.url as thumb"
    }`
]]

{var $photo_before_html = "!pdoResources" | snippet: [
    'class'=>'UserFile',
    'loadModels'=>'UserFiles',
    'sortby'=>'rank',
    'where'=>'{
        "UserFile.list": "photos_before",
        "UserFile.parent": '~$_modx->user.id~',
        "UserFile.createdby": '~$_modx->user.id~'
    }',
    'leftJoin'=>'{
        "Thumb": {
            "class": "UserFile",
            "on": "Thumb.parent = UserFile.id"
        }"
    }',
    'select'=>'{
        "UserFile": "*",
        "Thumb": "Thumb.url as thumb"
    }',
    'tpl'=>'@INLINE 
    <div class="item">
        <a href="[[+url]]" target="_blank">[[+name]] - [[+size]]</a>
    </div>'
]}

"Thumb": "Thumb.url as thumb"

&where=`{"UserFiles:!=":""}`

[[!ufForm?
 
&list=`upload` 
&anonym=`1` 
&dropzone=`{«maxFilesize»:3,«maxFiles»:1,«acceptedFiles»:".zip,.rar"}`
]]

{"profile":"Gallery","size": "width: 225, height: 135"}

{"profile":"Gallery","size": "225x135}

[[!ufForm?
   &tplForm=`uf.form`
   &list=`image`
   &anonym=`0`
   &dropzone=`{
   "maxFilesize":2,"maxFiles":1,"acceptedFiles":".jpg, .jpeg, .gif, .png","template":"edit"
   }`
]]

[[!pdoResources?
                    &limit=`1`
                    &showLog=`0`
                    &class=`UserFile`
                    &loadModels=`UserFiles`
                    &sortby=`rank`
                    &sortdir=`ASC`
                    &class=`UserFile`
                    &tpl=`@INLINE 
                    <img src="[[+url]]" title="[[+pagetitle]]">
                    `
                    
                    &where=`{
                        "UserFile.parent":[[+id]]
                    }`
                    
                ]]

[[!pdoPage?
              &element=`pdoResources`
              &parents=`[[!BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`66`]], [[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`70`]], [[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`68`]], [[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`243`]]`
              &hideContainers=`1`
              &includeContent=`1`
              &useWeblinkUrl=`1`
              &limit=`24`
              &setMeta=`0`
              &sortdir=`DESC`
              &sortby=`menuindex`
              &tpl=`portfolio-tpl`
              &tvFilters=`
              [[++cultureKey:is=`[[++cultureKey]]`:then=`[[*id:is=`[[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`14`]]`:then=`category-portfolio==%category1%||category-portfolio==%category2%||category-portfolio==%category3%||category-portfolio==%category4%`]]`]]
              [[++cultureKey:is=`[[++cultureKey]]`:then=`[[*id:is=`[[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`66`]]`:then=`category-portfolio==%category1%`:else=``]]`]]
              [[++cultureKey:is=`[[++cultureKey]]`:then=`[[*id:is=`[[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`70`]]`:then=`category-portfolio==%category2%`:else=``]]`]]
              [[++cultureKey:is=`[[++cultureKey]]`:then=`[[*id:is=`[[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`68`]]`:then=`category-portfolio==%category3%`:else=``]]`]]
              [[++cultureKey:is=`[[++cultureKey]]`:then=`[[*id:is=`[[BabelTranslation? &contextKey=`[[*context_key]]` &resourceId=`243`]]`:then=`category-portfolio==%category4%`:else=``]]`]]
              `
              &includeTVs=`portfolio-images, portfolio-gallery`
              &tplPage=`@INLINE 
              <li class="page-item">
                <a class="page-link" href="[[+href]]">[[+pageNo]]</a>`
                &tplPageWrapper=`@INLINE 
                <nav aria-label="Page navigation example">
                  <ul class="pagination">[[+first]][[+prev]][[+pages]][[+next]][[+last]]</ul>
                </nav>
                `
                &tplPageActive=`@INLINE 
              <li class="page-item active"><a class="page-link" href="[[+href]]">[[+pageNo]]</a></li>
              `
              &tplPageFirst=``
              &tplPageLast=``
              &tplPagePrev=`@INLINE 
              <li class="page-item"><a class="page-link" href="[[+href]]"><i class="fas fa-chevron-left"></i></a></li>
              `
              &tplPageNext=`@INLINE 
              <li class="page-item"><a class="page-link" href="[[+href]]"><i class="fas fa-chevron-right"></i></a></li>
              `
              &tplPageSkip=`@INLINE 
              <li class="page-item"><a class="page-link" href="[[+href]]">[[%pdopage_right]]</a></li>
              `
              &tplPageFirstEmpty=``
              &tplPageLastEmpty=``
              &tplPagePrevEmpty=``
              &tplPageNextEmpty=``
              &loadModels=`UserFiles`
              &leftJoin=`{
              "File": {
              "class": "UserFile",
              "on": "File.parent = modResource.id AND File.rank = 0"
              },
              "Thumb": {
              "class": "UserFile",
              "on": "Thumb.parent = File.id AND Thumb.class = 'UserFile' AND Thumb.properties LIKE '%w\":400,\"h\":400%'"
              }
              }`
              &select=`{
              "modResource": "*",
              "Thumb": "Thumb.url as thumb"
              }`
              ]]

[{"profile":"free"},{"profile":"square","ratio": "1/1"},{"profile":"4x6 wide","ratio": "6/4"}]

"profile":"square"